Oleg Netchaev (3/5/2010)

---

Implementation of the sparse column makes...

CirquedeSQLeil (2/18/2010)

---

Saurabh Dwivedy (2/18/2010)

---

Paul White (2/17/2010)

---

With an exclusive lock, no other transactions can modify data (except for operations with NOLOCK hint or read uncommitted isolation level)

What???!!! :w00t:

I want my point...

Paul White (2/17/2010)

---

With an exclusive lock, no other transactions can modify data (except for operations with NOLOCK hint or read uncommitted isolation level)

What???!!! :w00t:

I want my point back!

Unless someone can...

SELECT HASHBYTES('SHA1', REPLICATE(CAST('A' AS varchar(max)), 8000)) returns a 20-byte value, and SELECT HASHBYTES('SHA1', REPLICATE(CAST('A' AS varchar(max)), 9000)) returns the same warning message and no value.

Why the IF comparison between...

Hugo Kornelis (1/27/2010)

---

If I critisize a QotD, I always try to maintain a positive tone. Especially since, after having submitted some of my own, I know how hard it is...

Kelsey Thornton (1/27/2010)

---

CirquedeSQLeil (1/26/2010)

---

if one examines execution plans for these two queries and run them together, the query optimizer treats them as the same execution plan and equates both queries...

I had chosen - "both are equally cost-effective" simply because I felt that the correlated subquery still needs to check for the existence of the equality condition for which the...

Why don't you share your solution with us for our enlightenment?

I thought it helpful to add the following from MSDN

The REVOKE statement can be used to remove granted permissions, and the DENY statement can be used to prevent a principal...

I too, like most others, initially felt inclined to believe none of the answers was PERFECTLY CORRECT because the text - in the middle of the answer set - was...

I have one confusion with regards to the following comment made in the answer ...

Msg 3903 The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

If I understand correctly, since...

I realized that the poster had cut-paste from the link he has included in the answer. This could have been avoided by careful proof-reading; It might have been a case...

Zerofusion - thanks for clearing my doubt.

When the query is executed - the JOIN clause gets evaluated first and the WHERE Clause operates subsequently on the rows returned by the JOIN clause. It seems therefore that...

Why so, though? First, why does ISNUMERIC return 1 when obviously parameter is of type char and not numeric? And then even assuming that a string of 1's can be...