The problem - as with most advice - is that it's extremely hard to make generalizations. This is both because:

1) without lots of evidence many people (quite rightly) don't believe...

I wouldn't be concerned about it - if your indexes are being used regularly then most likely the majority of the upper levels will be in cache anyway. Also, the...

The problem is that your temp table doesn't contain all 20 columns that the output from RESTORE FILELISTONLY has (actually 21 in SS2008). Checkout the BOL for RESTORE FILELISTONLY for...

That worksfor extrapolating full backup times, but doesn't work for restore times. One of the phases of restore (well technically two of them) is to run recovery on the transaction...

That's usually because the file already exists or you don't have permission in the directory. What's the SQL that you're executing?

Short answer - no.

Quick question - why are you partitioning?

DBREINDEX is also deprecated and doesn't run the indexdefrag algorithm - it does offline index rebuilds....

These indexes aren't getting touched - you basically shouldn't bother with index fragmentation unless your index has more than 1000 pages as it'll most probably be entirely contained in cache...

Btw - I just blogged about this thread and my two responses (hey - a free blog post for me :)) and asked for any opinions and data on if...

Hi folks,

What's really not made clear in the MS literature is that the multiple-files in a database really only applies to tempdb. Even on tempdb, on 2005 you don't need...

Hmm - could be a bug. I'm going to blog about this today - I'll investigate and let you know what I find.

You're welcome. Checkout Kimberly's and my blogs for a ton of info that should help you. We're also doing a full-day workshop on 'Accidental DBA' at SQL Connections in the...

Doesn't make sense to split any database into multiple files for per-cpu performance, except tempdb which can suffer from multiple-CPUs all trying to modify the same allocation bitmaps under...

In Books Online there's a bunch of info for each of the components on globalization - checkout http://msdn2.microsoft.com/en-us/library/ms142795.aspx

I don't know of any comprehensive lists. In my book, the biggest feature you gain by moving to 90 compat mode is being able to use all the DMVs.