Pretty. But I didn't see a question or a statement in there.

Please use the forum to ask questions only. There are other places to properly post pretty code...

"A bird in the hand is worth a bird in the hand!". Hahahaha.

Ya, I've seen that happen too - sometimes to the tune of a lot of thousands. Ouch. But,...

There is a different way of thinking about "the business". Perhaps the motivation of a consultant is not hours or money, but reputation. Or perhaps they desire to...

Thank you! I've never blogged before and am looking to setup my own real soon. I know that safari is not perfect when it comes to some...

Oh, right. Good point.

Ya, different hardware would definitely be best.

Jim

In many industries, separation of duties is a good thing. One reason already discussed is for one developer changing code in dev, while another person (DBA) implements the change...

I use mine extensively for work. I find myself in one of several apps throughout the day (aside from safari, mail, etc.).

iTAP RDP - remote desktop client. Best...

Right. Exactly. The reindex will handle index stats, but not column stats, so it sounds like you have a plan and a good strategy. I just wanted...

Even if you restore to the same server, you will get some benefit; in fact, most listed here. Course, don't restore over the same DB and ensure you have...

Great minds think alike.... and so do ours.

Oh yea? How about four birds: Restore functions as a poor-mans 'reporting' Day-Old.

Jim

Good to know. Perhaps I'll sleep better tonight. Thanks.

Jim

I have to agree; also helps minimize the maintenance...

Oh, pardon me. Going from rebuilding all stats, like it or not, to only building the stats where 'stuff has changed too much', will decrease your maintenance time; possibly...

Here is your answer: http://msdn.microsoft.com/en-us/library/ms187348%28v=sql.90%29.aspx

UPDATE STATISTICS

... will by default do a 20% sample (if I remember correctly).

UPDATE STATISTICS Production.Product(Products)

WITH SAMPLE 50 PERCENT;

Jim

sqlservr.exe -f

Then run alter database for tempdb.

http://www.sqlservercentral.com/Forums/Topic545301-146-1.aspx

Jim