Update statistics on a table updates ALL statistics on that table, index and column alike.

I thought I remembered object_Id working. Hmmm...

There are, but what's wrong with running profiler (or preferably a server-side trace) and recording the duration column?

sys.columns 🙂

Table variables have their columns recorded in the TempDB system tables just like any other table. They're a little harder to identify because the table name is changed. Edit:...

Hmm.. I wonder what chocolate drum rolls taste like. :hehe:

How are you restoring it? If the backup was taken via Red Gate's SQL backup, it needs to be restored via Red Gate's SQL backup. If you're already doing that,...

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1519944-392-1.aspx

The database you're using is corrupt. Call your DBA and tell him there's corruption in the database.

It means enough of the transaction log so that the restore can recreate the database in a transactionally consistent way. Don't worry about what from what file, just focus on...

A differential backup is a backup of the data changes since the last full backup. It's a data backup, not a log backup, so mostly the data file with enough...

No, because it's inaccessible (can't be read or written). However in the list above, 'set to read only'...

In unrelated news, slightly belated drum rolls please..

<---------

All of them....

Those aren't books, they're publishers.

Favourite books: Inside SQL Server 2008 (soon to be replaced with...

Table definitions and index definitions please?