Nice article Kathi. Good job.

This article[/url] covers the basics on backups in 2005.

When you say database integrity, do you mean, data integrity as defined by primary keys, foreign keys, constraints, etc. or are you looking at database consistency and running the database...

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