Thanks for the feedback.

It's going to be a bit... the new forum software has a problem in it that made all...

Heh... and here we are trying to teach someone on an interview to be either a DBA or a Developer how to be ethical.  This should be an innate attribute...

Heh... I wasn't going to tell the OP about that... I didn't want to make it any easier for him to do it the wrong way.  The SSNs have to...

Well, crud... I resurrected an old "Passport" disk and found my old animated "Death Star" explosion of rebar but the new forum apparently doesn't support animated GIFs.  Had...

This guy has asked a half dozen interview questions.  I'm not helping him to get a job he's not qualified to do.

Are these all interview/homework questions? ethical question, replication, Adjusting T-sql to prevent injection, accidenly dropping production, failover, idol steps to take. Why don't...

Another option it to dynamically create the resulting table. Starting from a table with all the items and an empty price column, and loop through all the price lists....

Lordy... all these interview questions you're asking.  And the word should be "ideal" and not "idol". 😉

The bottom line should be that NO ONE gets any privs to prod without...

Again, this sounds like another interview question.  Again, I'll only provide hints because if you're applying for a DBA job, it's YOU that has to learn and simple memorization isn't...

This sounds like an interview question... especially since you've asked so many similar questions.

I'll give you some hints, though...

BEGIN TRANSACTION

ABSOLUTE HONESTY

@s-2.bellini

Yes, I appreciate that a lot of people abuse TempDB and thanks for the feedback there.  For these type of articles, though, I can't presume that it's safe to sometimes...

If you did a shrink-file, you inverted some index and that's the worst form of fragmentation there is.  You MUST do index maintenance to any fragmented index immediately after a...

First of all, you don't want it to be a VARCHAR(MAX).  You can't index LOBs.

Second of all, there aren't many SSNs and it wouldn't take much more than a day...

Hi Grant, Do I really need to have any kind of certificate to apply for an entry level job? And also I graduated high school and have some college...