SQL Backup command – STATS keyword

I’m not sure why I hadn’t noticed this before, or why it suddenly seemed like such a novel concept to me, but while I was running a backup command one on SQL I realized what the STATS keyword actually does (red circle below). Then it hit me, it’s the...

Getting whipped by GetDate()

I have recently been working on tuning a job that purges data out of various tables that are older than 13 months using getdate. Pretty straight forward right? Well originally the job consisted of 6 different statements like so: delete from table1 where...

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.