Nice comparison.

On the other hand, it could be better to see physical table performance comparison instead of / in addition to temporary tables.

I am sure you can set it up, while I really don't have the time. 🙂

Hi @caoxp930,

Two possibilities that I can think of:

1) You might have ran the query on a SQL 2005 server, via SQL 2008 interface. The sys.dm_exec_procedure_stats doesn't exist on...

You are welcome. Hope you find it useful.

Hi there,

It seems the post page on SQL Server Central replaces certain characters(space / tab) with others, due to a bug I assume.

I have checked the characters on the error...

Nice code.

This is an old topic, but nevertheless: There is a tiny typo in "last_exectued_step_date" column. Raises error if not corrected.

Jeff Moden (5/3/2011)

---

adnan.korkmaz (5/3/2011)

---

Great job! Thank you all those who have written, contributed or inspired Jeff.

I have done some tests on real data before using this new one, executing both...

Great job! Thank you all those who have written, contributed or inspired Jeff.

I have done some tests on real data before using this new one, executing both under same parameters...

Great article!

I had downloaded the following scripts for a very similar database schema, that speeds up "select" queries against the blocks table. It increased my "lookups per second" from around...

So, isn't some similar scanning occur when...

edit: this should be one of the most basic queries ever. so, i have been surprised why you have choosen to add an identity column and querying the table twice...