When doing query tuning, sometimes the answer can be that it’s just better to get SQL Server to recompile a plan based on the data passed in. You might have a batch process that runs every hour and sometimes it has only a few hundred rows, other times it has a few billion rows. The […]
In a previous post, I showed how you can create a clustered scheduled task. Now we could use that trick to change the schedule of a scheduled task by deleting and then importing a new one, but wouldn’t it be better to just change the schedule? Using PowerShell, this is quite simple. First, connect to […]
Do you use Scheduled Tasks as part of your production environment? Maybe to run those end of month reports for finance, or to run a nightly batch process, to import data from some uploaded flat files, or to download data from an external source on a regular interval. Scheduled Tasks are a really simple way […]
