I think you're on the right track. How about something like (data types would probably need to be adjusted & this is psuedo-code)...

DECLARE @ComparePwd nvarchar(10), @CompareEmail nvarchar(100)

SELECT @ComparePwd = u.Pwd

,u.*

FROM...

If it's that big & complex, script or proc probably won't make a difference in performance terms. The procedure is likely to be easier to maintain since you can set...

I agree with Matt. Stay away from simply trying to mask real data. If you need to get the precise types of data distribution that real data gives you, then...

ritesh (2/28/2008)

---

The second query should pull back info from the first and itself. so the second query will match on the first and pull this like First Date, Last Date...

It really depends on the SQL statement in question. To a large degree, depending on what the SQL is doing, there is no substantive difference between a script and a...

Oh yeah, we'll ask about deadlocks too. Isolation levels would be a grossly inadequate answer, just so you know.

The thing is, we seldmon hire for entry level dba positions. Much...

I'm mainly interested in hearing how they're going to troubleshoot stuff. I want to hear what they're going to do, how, when... I've had interviewees that insist the only way...

Yeah, we had a guy who said he was a 10 on internals. We asked him how an index was stored... "In the database."

Ta-Da!

Thanks for playing. Our parting contestants will...

Mark Markov (2/28/2008)

---

He said: Which one is better? ---> umm... I didn't know what to say

He said: If you need to do a lot of SELECT, would you use a...

What ahutchens says and check the configuration manager.

Yeah, but did you log in from a different machine to the server? The reason is, you need to confirm that it's allowing external connections.

ODBC works fine with instance names....

leea (2/28/2008)

---

Does the case not cause very similar performance problems, I remember having to rewrite an SP a little while ago to improve performance by removing the case from a...

Verify that you've got the names correct. Can you connect using management studio from a different machine?

GSquared (2/28/2008)

---

Good article.

One small quibble with it. In one of the examples, you use "((FullName1 = 'Ed Jones') OR (FullName1 IS NULL))", as an example of how to get...

What about using DATEDIFF on days where it equals zero?

Still, joining on something like this is going to be problematic. Most problematic of all, you're joining on columns that clearly...