Thank you for the post, good one.

(on Monday, I was checking this on my VMs, has a script and launched the 2008r2 instance, changed the compatibility to 90 and then...

that word "query" is confusing... I guess he means in one "batch" or in...

Thank you for the post, Shiva, interesting one.

(at first I did not pay attention on the variable size, so I selected two options which seemed right, then I re-read the...

Thank you for the post, very very interesting one, never new the word "SARGable" really exists, learnt a good amount of new stuff today. thank you.:-)

I have one SP where I use...

Thank you, Tom. As they say, there is no good or bad, and it is just a person's point of view. Not just on in this post, not SQL.....

Thank you for the post, Steve, good one.

Thank you for the post, SJ, actually funny one for me after reading the choices, can't stop laughing for this ... "Big Infrastructure Manipulation Language".

(well, at least week's ending...

TomThomson (8/21/2014)

---

It's valid in every...

SqlMel (8/20/2014)

---

Hany Helmy (8/6/2014)

---

Easy, another fast way (but maybe not the fastest), just highlight the table then press Alt + F1 will give you all table structure, definition, columns names,...

SqlMel (8/20/2014)

---

In my case, I didn't know about the limit when using TABLOCK, so I learned something today.

Well, I don't feel so bad since 83% so far have been incorrect...

TomThomson (8/19/2014)

---

The pro is of course that if you put all the declarations combined with assignment in a non-repeated part of the stored procedure, trigger, or batch the assignments get...

Thanks, Nils, this makes a...

John Mitchell-245523 (8/19/2014)

---

And that is just as worrying as if dozens of users had complained. The only thing worse than incorrect data is incorrect data that you don't know...

Thank you, Tom, very interesting one.

As the old saying goes "everything has pros and cons", so any one see the "pros" side of it?

(I am kind of feeling now, its...