You'll need to set a flag on the table itself, marking the records that no one else can access and include that check in your queries.

Otherwise, you have maintain...

Cool. Sounds like you're in the right track.

Sorry, I was spending more time thinking about the logic than the syntax. You can cut my pay for this job. 😉

How about something like this (this assumes one row...

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...