Okay here are the wait stats gathered using this query running regularly during the process:

INSERT INTO #more_stats

(

session_id,

wait_duration_ms,

wait_type,

blocking_session_id,

resource_description,

program_name,

text,

dbid,

cpu_time,

memory_usage

)

SELECT

owt.session_id,

owt.wait_duration_ms,

owt.wait_type,

owt.blocking_session_id,

owt.resource_description,

es.program_name,

est.text,

est.dbid,

es.cpu_time,

es.memory_usage

FROM

sys.dm_os_waiting_tasks owt

INNER JOIN sys.dm_exec_sessions es

ON owt.session_id = es.session_id

INNER JOIN sys.dm_exec_requests er

ON es.session_id =...

If there are no other online index operations happening then I'm out of ideas.

That's what I thought. I'll do that during the current run. It could be awhile before I have any good information.

Can you check to see if the database is set to AUTOSHRINK?

I should be ashamed that I posted in the 2008 forums when the query is running against 2005. My excuse is that the...

Check out the great maintenance scripts created by Ola Hallengren (http://ola.hallengren.com/), as they will allow you to schedule all this using SQL Server agent.

I assume you are running this against the principal database not the mirror? I have to ask.

Have you checked to see if the index rebuild is running already using...

Good article. I have one comment/question. It looks like this solution can only handle databases with one data file. How would handle a database with multiple data...

Hey can an execution plan expert (Grant?) take a look at this thread, http://www.sqlservercentral.com/Forums/Topic1181619-338-1.aspx. Interesting behavior noted in execution plan properties with SET ANSI NULLS.

WayneS (9/27/2011)

---

Hey Threadizens... I received an email for what looks like an interesting permanent/full-time DBA position in the Phoenix area (I know some of you'll are from that area). PM...

I'm on 2k8 SP2:

Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (X64) Feb 25 2011 13:56:11 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows...

Hope you have a great trip.

I don't know if Andy Warren told you but we discussed doing the SQLBits format with SQLRally, but we couldn't make the numbers work to...

Trey Staker (9/27/2011)

---

@craig-2

Did you hear that Itzik Ben-Gan is teaching an advanced t-sql class here in Phoenix the week after pass? It's really pricey but I got my company...

SDB15 (9/27/2011)

---

These are just a couple rules of thumb that has been useful in my experience. As you said, CTEs, temp tables and table variables all have their uses.

The...

That's interesting. I am seeing similar behavior, but the results are being returned according the active setting, not by what's reported in the execution plan.