Thank you for the post, Steve, good one.

(but confusing... for me. I like to see an example of printf style and then the same written in throw line. I thought...

+1

I do that. Sometimes I have write a script where it also contains...

Thank you for the post, Steve, very important one.

TRY/CATCH first choice - or go classic (sql 2000 way, it works) store the error status in the variable on each DML...

Thank you for the post, Steve, interesting one.

(I have not used OUTER apply and was sure of the CROSS, so the choice was easy for me, I made the selection,...

Thank you for the post, Steve, nice one.

(first I saw the options and saw 16 there and then selected it as "cool... sweet 16"... and submitted, then I read the...

Thank you for the post, Steve, good one.

Happy weekend!!!

(To all Indians out there - Happy Dussehra)

Thank you for the post, Steve, good one.

Well, this was bit challenging one for me especially when you are working in cmd mode, but after generating few errors manually...

Thanks for the question Steve, very interesting one.

At first, I did not see the difference in RANK and the DENSE_RANK for the given data ...

1> CREATE TABLE custsale

2> (...

+1

I was reading the book on sql 2012 internals by Kalen Delaney, one of the line it states "It reduces the maintenance...

Thank you for the post, good one. (guessed the answer right also the explanation behind it)

Thanks for the post, very interesting one. I referred the local_help to know the difference between these two, and picked the geography, it states clearly on what type of data...

Thank you for the post, Steve, interesting one, I never tried this before, so had to check practically.

I started the service via powershell, then launched the cmd window and then,...

ctrl+c

ctrl+v

(sql is so beautiful)

Thank you, Steve, good one.

Thank you for the post, steve, good one. (Selected the correct answer by experience)

Happy weekend.:-)