Barry!!! Welcome Back!!!

Hope everything went well with your surgery.

tstaker (3/23/2010)

---

One of these days (probably nights) I'm going to have to check out what this twitter thing is. It's blocked at work. Am I the only person...

You might want to check out the 15 ways to lose your cursor[/url] articles by RBarryYoung.

Are you using any catch-all queries?

Does your code utilize the "WHILE" statement?

Are recursive CTEs being utilized?

Have the execution plans for the query been analyzed FOR EACH condition of parameters?

Do the...

Here's another way (note that it uses a virtual tally table - if you already have one, jump to the final select statement). If there are no gaps, this also...

I'm not sure how you saved out your users, but you might want to take a look at sp_help_revlogin. It scripts them out keeping the same SID (avoiding orphaned users),...

huston.dunlap (3/23/2010)

---

I am using dynamic SQL to build a query that looks like the following:

SELECT BEGDOC

INTO [#EDC-GH-GF]

FROM TABLE 1

WHERE PROCESSID = 'EDC-GH-GF'

When I use a PRINT(@QUERY) command to see the...

Paul - thank you for showing me an area of improvement.

and

Never...

What do you base the inefficiency on? I read...

GilaMonster (3/23/2010)

---

WayneS (3/23/2010)

---

That being said, employers are still impressed by having certifications. For that reason, I feel that all the denizons of the thread would benefit from being certified... that...

CirquedeSQLeil (3/22/2010)

---

I also believe the same could easily be said about people with College Degrees. There is a person in our finance dept that got a degree in CS....

GilaMonster (3/23/2010)

---

Dave Ballantyne (3/23/2010)

---

Not odd, ive always thought the exams are based around , can you remember obscure syntax for obscure functionality used once in a blue moon. ...

You might want to take a look at TRY/CATCH blocks, i.e.:

BEGIN TRANSACTION

BEGIN TRY

CREATE TABLE [dbo].[XXX](

[a] [smallint] NOT NULL,

...

From what I can gather, there is a...