Chris Morris-439714 (9/7/2010)

---

Feature-packed and very readable article as always Paul.

It's a little like watching your favourite tv program - just as you're really getting into it, you reach the end...

For sure:

Craig Freedman: http://blogs.msdn.com/b/craigfr/

SQL Server Storage Engine: http://blogs.msdn.com/b/sqlserverstorageengine/

CSS: http://blogs.msdn.com/b/psssql/

Query Processing: http://blogs.msdn.com/b/sqlqueryprocessing/

White Papers: http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx

SQLCAT: http://blogs.msdn.com/b/sqlcat/

Conor vs. SQL:...

jim.jaggers1 (9/7/2010)

---

Can you help me understand the difference in the Nested Loops operator between the first and second plan? Other than the '!' point warning symbol in the first...

Everything (in detail) will be revealed in subsequent parts...stay tuned 🙂

Very nice, Tom! That would indeed be sufficient to avoid the issue. 😎

Hugo Kornelis (9/5/2010)

---

Indeed. The check itself changes the options for the optimizer. The method now even appears to be immune to parallel execution problems, since the parallel streams have to...

Wayne,

The post you're looking for is: http://www.sqlservercentral.com/Forums/FindPost816917.aspx

Paul

Jeff Moden (9/4/2010)

---

Hugo, it takes one awesome professional to post something like that above. Even if we vehemently disagree (and you'll be surprised that we disagree less than you...

Hugo Kornelis (9/4/2010)

---

I thought that this method of finding a starting point and then scanning a range of rows was called a scan, but I just double checked in SSMS...

If we add the safety check, things work out nicely:

DECLARE @Sequence INTEGER = 0,

...

Jeff Moden (9/3/2010)

---

... one of the few people who argues on my side and I have to disagree with him a bit. :pinch: I believe there may be...

Jeff,

Just so you know, I had a similar reaction from someone asking about how to do a dynamic PIVOT via Twitter's #sqlhelp hash tag today. He/she was very impressed.

I...

The Dixie Flatline (9/3/2010)

---

My son and daughter are both grown and living in Dunedin, about 5 or six hours drive south and west of the quake. ...

You know what I meant,...

http://www.stuff.co.nz/national/4094986/Massive-quake-hits-South-Island