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...

There are not timeouts for objects, it's a connection timeout or query timeout that you need to set.

I'm not sure what you're putting in and what you think it should be. Please post the URL and the text that should be there separately.

Thanks and it's something to consider. Lots of people use the Active Threads link on the left, so they see what's new, but it might make sense to move threads...