Ten seems high, but it depends on usage, as mentioned. You would want to look at the stats, see if they are really used. Also check the missing indexes view...

You might look at SQL Sentry's scheduling solution for help with the jobs.

As far as making this faster, you would need to get execution plan for each insert/update and see...

That's interesting. I'd think that there would be no problem reading it offline. Maybe some JS we have. I'll give it a try and save some files.

Micheal, sounds like a good article idea (hint, hint)

Don't shut down the Windows host, shut down the SQL Server server instance. Use SSMS, right click, shut down SQL Server.

Or Control Panel/Services, turn the service off.

There is always a bottleneck. You just have to decide if it's an issue on your system. Once you fix that bottleneck, or mitigate it, there will be another one.

You...

Jeff,

I think there's a good call for a T-SQL book from you 🙂

The other thing is that most authors aren't thinking performance when they write. They might be when the...

Paul does a restart of SQL, and a restart of tempdb clear this up?

What is the problem you're having?

The generator has been in for a little over a year, works great, no issues. We still might lose connectivity if the upstream links die (it happens), but so far...

IBM can run their business however they want, but I don't want to support them, and neither should our government.

Very nice! Great voice.

Perhaps I should get some guest music/video for a podcast 😉

Are we going to hear some singing without headphones?...

Are you trying to restore a copy of the MSR database OVER TOP of a copy on your local server?

The general process:

- Connect to production with SSMS

- run backup from...

good backup

good resume

you only need one