The choice of which one comes first does matter. If you were to have a composite with the leading edge of FamilyId and a single index with the leading edge...

Just a guess, any chance that the database is in compatibility mode? I'm not sure that would affect anything, but that's odd behavior.

I agree with the Ninja, killing the process is a bandaid at best. You need to address the issue and fix that set of procs so that they're not stepping...

Another thing to take a look at are some of the new data types, especially the CLR types, and some of the new options with indexes. Those things made a...

Most systems I've managed we updated the statistics daily. But some were less volatile so we updated statistics weekly. You're approaching dealing with large databases at 1TB. You might need...

I'd try uninstalling and then reinstalling.

Sounds like some kind of hardware issue. Was the restore run across the network? Might have glitched there. You're using a third party product? Might have been something in there...

You can't...

1. What ever process you're using would need to keep track of which index has been done. There's nothing automatic around that.

2. CHECKDB outputs it's results, and yes, you can...

I'm pretty sure that FILESTREAM stores individual files, not a single file like a database file. Each time you write a file out to the FILESTREAM, it gets stored out...

Hold a second. TableB has an identity column. You can't make that a foreign key to another table, it will cause errors because, in theory, you're creating values automatically in...

skrilla99 (8/19/2011)

Grant Fritchey (8/19/2011)

skrilla99 (8/19/2011)

SELECT dtat.transaction_begin_time,

dtat.transaction_status,

dtat.transaction_state,

...

skrilla99 (8/19/2011)

SELECT dtat.transaction_begin_time,

dtat.transaction_status,

dtat.transaction_state,

der.blocking_session_id,

...

This will get you started[/url].

Here's an introduction to the topic[/url].