Sure. Check sys.dm_exec_requests. You should be able to get what you need from there or by joining to one of the other execution DMV/F's to prevent a secondary execution while...

Lynn Pettis (4/29/2009)

---

Now for something totally the same...

How many...

It's right there in the signature line, The Scary DBA.

It could be something you have to monitor. Do you have an idea as to why you're getting so many page splits? Does the table have a clustered index that's...

There are great articles right here on SQL Server Central. Just type something like 'index design' in the search box and then limit the scope to articles. There are a...

You can take advantage of the default return value from procedures like this (untested code):

DECLARE @retval int

EXEC @retval = ProcA @param1='a',@param2='b'

IF @retval = 0

BEGIN

EXEC ProcB

EXEC ProcC

END

How much data is in the table, specifically how many pages?

For very small tables, less than 10 pages, you might not see any change in fragmentation, even after a rebuild...

Yeah, that sounds familiar. I'd suggest recompiling after the data load and avoid using query hints. Since you know it's going to happen, take care of it that way. Also,...

Without details it's not possible to give you specific advice. In general, make sure you have a clustered index on the table. Make it as narrow as you can, but...

Track down a copy of Brad McGehee's "How To Be An Exceptional DBA." It's a great read. For a fantastic introduction to the concept of being a DBA, I recommend...

You need to use a server-side trace. You can build this manually using the T-SQL commands or you can use the SQL Profiler tool to build it for you. This...

Thanks for posting the answer. It's always good to know when I got something right.

Bruce W Cassidy (4/28/2009)

---

[font="Verdana"]This morning I had an idea. After I had had a bit of a sit down to recover from that novel feeling, and to reassure myself...

There are several articles on Gail Shaw's blog[/url]. There are several good articles here on SQL Server Central, just search in the window in the upper right. For real depth...

GilaMonster (4/28/2009)

---

You and me both. I started writing a blog post on this, explaining that there could be serial and parallel plans in cache....