Grant Fritchey (12/16/2011)

---

Anyone have a script that will reliably generate a deadlock from a single process? I need to be able to repeatedly generate a parallelism deadlock for some internal...

An email distribution list. I saw the change on Connect before coming here, or looking at the DL, and already added a comment that basically...

Reposting these links from earlier, for those looking for the details:

http://blogs.msdn.com/b/sqlprogrammability/archive/2006/04/03/567643.aspx

http://blogs.msdn.com/b/sqlprogrammability/archive/2006/04/03/567648.aspx

http://blogs.msdn.com/b/sqlprogrammability/archive/2006/04/03/567660.aspx

http://blogs.msdn.com/b/sqlprogrammability/archive/2006/04/03/567663.aspx

jshahan (12/15/2011)

---

Thanks, Paul. I re-read the Extra Credit section of part II (great job by the way and thank you) and your last response and believe I can paraphrase...

jshahan (12/15/2011)

---

I read both parts one and two of that article prior to my post. It does appear that CROSS APPLY = INNER JOIN is not an absolute....

That is part 2, the first part is here: http://www.sqlservercentral.com/articles/APPLY/69953/

Hugo,

I can't find any BOL documentation, but you should find this four-part blog series on the SQL Programmability & API Development Team Blog answers most, if not all of the...

Hi Robert,

It helps to know a little bit about...

GSquared (12/14/2011)

---

But do keep in mind that DataLength on Unicode strings can require math on the CharIndex result, or you'll get the wrong position. Len vs DataLength depends on...

raistlinx (12/14/2011)

---

If we assume for a minute that deadlocking wasn't part of the reason, say it was just to get a snapshot in time. In theory would you expect this...

If you want to avoid this in future, get into the habit of specifying a typed UNIQUEIDENTIFIER rather than a string. Either use the curly brace format, or an...

raistlinx (12/13/2011)

---

If there were many row-level X locks on the table from other processes doing INSERT or UPDATE would that not slow down a query selecting all the rows from...

None, but I have a tidy mind. Can we get back to the question...

Simple example:

USE tempdb

GO

CREATE TABLE dbo.Test

(

pk INTEGER PRIMARY KEY,

data ...

I use it because COUNT introduces a pointless conversion to integer. Saves me a Compute Scalar...