Someone beat me to it.

I'm 2.1GB of 3.1GB down now. Not moving too fast 🙁

Error log?

I think a Trace on sp_start_job might be the best way to pro-actively get this.

Don't have many writers, so this isn't much of a priority.

You're welcome and I'd love any you want to submit. Keep in mind answers must be short, not HTML allowed...

Quite a few of the heavy posters use the "Active Threads" link to check for changes since their last login and the post count is shown. That's how I scan...

You could left join with a table of all periods, including 0s for NULLs (CASE or ISNULL).

Or you could "populate" 0 orders with the missing periods.

Cursor opens a copy of the data, essentially and holds it. This isn't the most efficient way to do things. A While loop typically reruns a query to check if...

If you are testing/benchmarking, you can DBCC FREEPROCACHE, but it will slow down a production server as all plans have to be rebuilt then.

Thanks, glad you liked it and hope you enjoy the little one.

Steve

If it's a job, they only need to be able to run sp_startjob in the msdb database. You could create a batch file that runs SQLCMD/osql to make this work.

I'd go with something like Gianluca's idea. SSIS or import to a table.

Are you doing log backups during this process? Or are you in simple mode?

The commits every xx rows doesn't prevent the logging or clear the log. Only a checkpoint (simple...

Outlook shouldn't be running on the server. It needs to be installed, but the SQL Agent account will use the Outlook DLLs to connect to your Exchange server and send...

Thanks, that's interesting. I bet it's the order of replacements that cause an issue.

I'll see if there's anything we can change.

Jack has a good explanation. Basically statistics are meta data about the indexes and data. They help ensure the query optimizer performs well.

Glad to see most of you aren't afraid of un-retiring if you need to.

And if you get the chance to do something else you want, best of luck. Free cheesecakes...