ChrisM@Work (5/9/2013)

kapil_kk (5/9/2013)

IgorMi (5/9/2013)

What does its execution plan say? Are there any missing indexes? How big are the tables? Check the statistics on them.

You can replace the IN with EXISTS...

Thats a great question. For some reason last few questions have been very efficient. 🙂

Huge thanks. This was really awesum question. Though i got it correct for wrong reasons but after going through all the comments got it rectified in my mind. It really...

Gosh. This question should be appeared in "question of the week" rather than "question of the day". Too lengthy. Don't know if only i felt this little heat. But after...

SQL Show (4/30/2013)

Correct me if am wrong. If backup never taken, then db...

Another lovely question. 🙂

There can be many many solutions to what you are looking for. What i woul dsuggest is don't touch the products table and create a new

Product-Application mapping table with product_id...

Good if you are able to regenerate the issue. Setup the profiler with deadlock events under lock event groups along with deadlock graphs. Run the profiler and start generating the...

Great question. Tells the nature of t-statements in batches. Good stuff. 🙂

Another good question showing basics of joins. Thanks for this simple question with brilliant approach. +10

This is pure shot in the dark and luckily I got it right. Sincerely new to me but glad to know. +1

Very good question. Too good to clarfy many doubts all in one. Woul dlove to see many such questions. :-):-):-)

Hi Dinesh, Audit definition might help. could you post here ?

What i think is some of the CHARINDEX is either returning a NULL or a 0. check it individually one at a time. If not so, even I woul dbe...

I found the question easy. but definitely it was very good question and hopefully brought good understanding of joins for few. 🙂