My PC goes into energy saving mode, but I reboot probably less than once a month. XP, even 2000 before it, have been extremely stable. If you're not getting that...

select * hits every row. If you have an update in a transaction locking those rows, which is what it does, then you can't read every row.

Try reading specific rows,...

you can save to a file on any drive that the process can see. You can also set a rollover so that you don't get huge files. Maybe script a...

Bigger bandwidth, QOS, more machines to spread the load. Not sure how else you can do this.

Good excuse to see if the procedures work! Put on your serious face and "sell it"!

Shouldn't be any difference.

SQLAgent is a service monitored by Windows. You can set it to restart on issues and even notify you if it's down.

As far as shutting down, how can you tell...

Use System Monitor to track counters. SQL Server has a number of them and you can grab user counts, transactions/sec, and anything else that might impact your decision.

It's really load...

I haven't dealt with this in a clustered environment, but there are times when SPIDs seem to get stuck. Can you failover to the other side and reboot this one?...

Add your vote and let them know this is important. Please go to Connect and vote!

No experience, but what's D3?

How many procedures are we talking about? the maintenance issues are also better security practices. If you can't do what Jeff suggested, put a comment in each procedure listing all...

I have heard that the counters under Windows are not accurate with using VMs. You might want to check with VMware about that.

Also, keep in mind that the load is...

I'm not sure about either of those courses directly, but it does seem that the MS courses teach more to the exam than than the real world. If you have...

I'm wary of deleting data since it's often needed the day after it's deleted, but since you are moving to a history table, I'm be inclined to agree with everyone...