Jeff Moden (9/5/2012)

---

I have to agree with Peter, here. If I extrapolate some of the things you said in your fine blog post, I can see possible explanations for...

Jeff Moden (9/4/2012)

---

Paul,

I just noticed something on your blog. You have...

© 2012 Paul White

For some reason, some countries are required to recognize that unless you also include the...

Adam Machanic (9/4/2012)

---

Interestingly, I ran some tests on a machine that has both SQL Server 2008 R2 and SQL Server 2012 installed, and all of my test queries (for either...

Evil Kraig F (9/4/2012)

---

... Every damn time I start thinking I'm 'good' at this software, you come by and break my brain gently. ...

I just checked with Rob Farley and it's just as...

Blog post is up: http://bit.ly/ComputeScalar

I try to avoid the word completely, using a synonym or rephrasing the whole statement. Pronouncing it 'rowt' has never...

REBUILD supports the ONLINE option. I presume you have Enterprise Edition and...

You're getting a deadlock between one process that is updating a large object (text) column, and another that is inserting a new row (which will also include the text column,...

Not at all. I wasn't criticising you....

Usman Butt (8/29/2012)

---

I did some testing and explicit conversion to varchar(max) after entitization process optimized it quite a bit. So with your code formatting style and with no implicit conversions...

Sergiy (8/28/2012)

---

So, when exactly an exclusive (X) lock is taken on a row? Why X lock are taken on the rows when IX would be perfectly enough in a...

Good question, Wayne.

The varchar version will be half the size of the...

Ha! Very good. You know passing NEWID as a parameter is...