So, if you have a couple of minutes, I'd be grateful if you could c&p the following into an email to me,
, and answer the questions for one or more of your databases. I'd especially like to hear from those of you who work for Microsoft and look after multiple customers. If I get a worthwhile number of responses (say 100 or so) then I'll collate the responses and post a summary. I'd love to hear about databases larger than 1TB.
For the first 10 Microsoft and the first 10 non-Microsoft people to respond, I'll send you the Always-On DVD loaded with Hands-On Labs that walk you through a bunch of the various HA/DR technologies. (I'll let you know whether you win and you need to send me your address).
How large is the database?
What's the size of the largest table?
Do you have any indexed views?
Which command do you run, including options?
How long does the command take to run?
How often do you run it?
Which version & edition of SQL Server are you running?
(If SQL Server 2005, did you notice an increase or decrease in runtime?)