Did you read the article that I references?

I don't see table definitions, I don't see index definitions and there's no execution plan.

Also, have you checked to see if the...

Not with the native backup tools. Some 3rd party backup tools do have that feature.

Don't think it is. The PhD candidate has complained in the past...

Why backup several tables to file? Are you not taking database backups? If you are, why also backup the tables to file?

Can you post at least the query? Almost impossible to give useful advice on performance without seeing code. Also the exec plan, table definitions and index definitions. Please take a...

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/Topic766034-360-1.aspx

What do you mean by 'impact on the size of the column'? A column size isn't affected by creating indexes.

Why on earth are you storing a guid in a...

Jeff Moden (8/2/2009)

---

Even if you could, I wouldn't do that. What would happen to the index if you were inserting rows with the index turned off? They would...

If you disable an index SQL drops the index tree completely, leaving just the metadata bahind. When you re-enable the index, the index is completely rebuilt from scratch, just as...

You have noticed that the OP...

If you want singing.....

http://12seconds.tv/channel/CraigN/218481

On the left, Nicholas, an Exchange MVP. On the right, Zlatan, a Sharepoint MVP.

I more meant in general. That wasn't the only session that I played, just the only one...

I was playing guitar, not singing

If you include all the table columns as include in every index then you're incuring major overhead in two places.

1) Space. Each index will be the same size as the...

if emergency mode repair fails and you have no backup, you are out of luck. emergency mode repair is the last resort.

What might work is if you select the data...