That's a stored procedure. The logic could be flawed.

No, the conclusion is that a narrow clustered index is good, and that other non-clustered indexes, even on the same column, might help. However you have to look at the...

First, just to be clear, the clustered index isn't on the filegroup. You create a clustered index on a table, and place that in a filegroup to move the table...

Doh!, yes, edited to to say what I meant.

Narrow clustered key, not necessarily narrow non-clustered key.

First, don't confuse clustered index with primary key. Not related in any way. By default the PK is clustered, but that's a setting. They have nothing to do with one...

As long as you are sure you don't need point in time recovery, you did the right thing.

I would argue that most people don't think they need point in time...

Here's what I'd do, especially as you might need this later.

Get a sproc for every table that updates a field based on the PK.

That's a lot of writing, but you...

First, why switch to simple? If you don't have a good reason and don't understand the implication, don't do it.

Second, no. Just switch to simple. However, you are then limited...

Just a reminder, 24 hours of PASS, the Women's edition, is going on today.

http://www.sqlpass.org/24hours/spring2011/SessionsbySchedule.aspx

The negotiations have been a problem and the deal for a party did not work. As other companies have started to look for similar deals, and do their own referrals,...

Points have been awarded back and the question corrected to ask which one should be used, and then to note the DMV is the correct answer.

We do not have a code or a deal with PASS this year.

The early bird rates have typically never included a discount because they are always so heavily discounted.

Usually chapter...

Sorry, RESTORE HEADER ONLY: http://msdn.microsoft.com/en-us/library/aa238455%28v=sql.80%29.aspx

If you look through all the files, with a RESTORE HEADERONLY, you can check the for LSN (log sequence number). If you get to this highest one you have, you've...

restore with replace to copy over the existing database: http://msdn.microsoft.com/en-us/library/ms186858.aspx

Or in SSMS, on the options tab, check the "overwrite"

This, as Grant mentioned, overwrites everything in the database with what's in...