Stuart Davies (11/26/2014)
rahul.neekhra 81176 (11/26/2014)
Hi,Find the interview questions and answers here http://www.sqlserverpeoples.com/Examples.aspx%5B/quote%5D
Not sure about that being useful in the real world, a comment from a script (first one I looked at) from the website:-
exclude these databases as these are system databases which you might not be interested to take backup
OK - I'll remember that :w00t:
They're great if he's trying to sabotage other people by giving them stupid answers that will cause them to fail interviews.
A couple other gems (that if told to me in an interview would persuade me fast that the person I'm interviewing has no clue)
Use of Inner join instead of IN clause gives performance advantage.
I have to assume that this is a statement that was never tested. Common myth though, great for seeing if someone takes statements at face value or tests them.
The convert CSV to table uses a horribly slow method. Again proves that anyone presenting that has done no research or investigation on the subject
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability