If the criteria for winning involves having...

GilaMonster (3/3/2010)

---

Does anyone have time to go into detail on this one?

http://www.sqlservercentral.com/Forums/Topic875858-338-1.aspx

Probably a variant of parameter sniffing, from all that's been said. The procs and exec plans have been made...

--- Duplicate thread ---

GilaMonster (3/3/2010)

---

Yeah, that's due to the incorrect results bug I mentioned. The functionality was removed quite early, pre SP1. I have demoed this on 2008 RTM and there's a very...

david.pelizzari (3/2/2010)

---

I am trying to figure out how to split one single field that has data with commas into multiple fields. Ideally, this is something I would need to...

This is...

...and the exception to that would be if it were a global temp table 😀

Seriously,...

I only mention it because no-one else ever does 😛

Jeff Moden

---

A lot of the tests were done with rows of data where all of the...

A skilled and experienced person can tell more about performance from an 'actual' execution plan than profiler will ever...

Steve Jones - Editor (3/2/2010)

---

Well this was interesting. Had someone ask for their account to be closed here since the questions haven't been good the last month and the quality...

Barry-193141 (3/3/2010)

---

To counter performance issues, the easiest thing to do is add tablesample (10 percent) to the query.

This way the newid() function only needs to run on an already randomized...

That would be awesome! I can never find a stapler...

Performance results for that (huge) thread were summarized very nicely by Florian Reischl on his blog:

http://florianreischl.blogspot.com/2009_09_01_archive.html

It covers all the main methods, including WHILE loops, Tally tables, XML, and CLR.

Paul

Spoiler: CLR...

Seems like a good plan to me. It kinda bugs me to start blogging too...maybe.

Non-sequential/non-contiguous.

I feel ok commenting for Jeff...