Thanks Barry! You made the points exactly as I intended - apologies for the brief comment initially, but I don't have a lot of time at the moment.

There are...

Elliott W (9/23/2009)

---

As far as logical reads of a table variable.. Keep in mind that if they are not too big they will probably reside fully in memory and...

Working stupid hours on a major project....

It's probably worth clarifying that 64-bit SQL Server does not have a 'MemToLeave' region - see http://blogs.msdn.com/psssql/archive/2009/08/26/come-on-64bit-so-we-can-leave-the-mem.aspx

You might also like to read this: http://blogs.msdn.com/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx since it covers some poorly-documented issues...

Adam Haines (10/2/2009)

---

The cross tab method allows you to "customize" the case expression, which allows you to save IO and increase performance, while you cannot do this via the pivot...

Jeff Moden (10/2/2009)

---

Nope... not sure anymore. The machine at work favored Lynn's method. My machine at home favors the original method you posted above. Unfortunately, I've changed...

Jeff Moden (9/22/2009)

---

Actually, it doesn't come close. To generate 1 to 10,000,000 numbers, Lynn's method pretty much blows the doors off that type of cross join (ie: more than...

:blink: How?

Daft...

¿???p??? o? p??? si?? pui? lli? ????dsi??? u?????ou ??? ?o?? ?ldo?d ?i ??puo? i

Found the article!

Maybe it's because I've been unusually busy at work this week, but I must say I found some of the comments left for you quite irritating.

Specifically...

Tony Fountain (9/16/2009)

---

Without getting elaborate and pulling the logs into a spreadsheet, from what I've been seeing is the range for the PLE is 0 to 600. An average...

So, overall, a good article and another interesting contribution to the SSC archives from Lynn 🙂

Paul

kjs714 (9/15/2009)

---

I have not run across anything more definitive what is in BOL. I recommend that you setup a test database and run Profiler, looking for the Lock Escalation event...

Lynn Pettis (9/17/2009)

---

Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here on ssc as well. Keep an eye out as...