Atul DBA (12/4/2009)

---

I am not sure about you OS. You can use the /F option with KILL command to make it forcefully kill the process. If you have TaskKill utility...

The title's actually Inside SQL Server 2005: The Storage Engine. There...

Is the non-recoverable IO error on the drive with the data file or the drive that you're backing up to? If it's the data drive, you got lot bigger problems...

I've pinged Paul R and asked if he'll...

GSquared (12/4/2009)

---

Would be better in SQL 2005/2008, since you could use the Include clause for most of the columns, but in SQL 2000, you may or may not get what...

Can someone keep an eye on this one please. I'm not going to be around much this weekend

http://www.sqlservercentral.com/Forums/Topic828709-65-1.aspx

Table and index definitions?

Brent Ozar was asking on Twitter about anyone in or willing to relocate to the San Fran area looking for a Senior SQL DBA position. Scaling and management experience required.

Smells like sinking ship to me. Definitely fix up resume. Even it's not needed, good thing to do.

Reminds me of 1st place I worked. For 2 months upper management were...

Only three?

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Correct. MAXDOP sets the maximum degree of parallelism,...

Query sys.indexes

Query sys.dm_db_index_physical_stats

What's it not doing, what error is it throwing? Basically, what's wrong with that code that you want help in...