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

Lynn,

We'll let you work from home in the winter. Less to distract you down there 😉

Who knows.

My son wants the Wii gun 🙂

Sorry for the delay in answering.

We could, decided not to. Our position is that most articles have a discussion section with them and it doesn't make sense for people to...