SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Gavin Draper's SQL Server Blog

Software Dev/DBA living the dream in sunny Brighton, UK. I've been playing with SQL Server about nearly 20 years now and still feel just as clueless as I did back then. I love writing about things I find as I go along.

Archives: February 2018

What Do Read Counts On Your SQL Server Execution Plans Even Mean?

If you’ve ever spent any time looking at execution plans you will have almost definitely noticed all the read counts on the different operators, you’ve probably already realised lower reads is best as that equates to less time reading disks. Have you ever wondered what the number actually means though?… Read more

0 comments, 57 reads

Posted in Gavin Draper's SQL Server Blog on 27 February 2018

SQL Server Tune Your Transaction Log

Whenever a transaction log file grows the space it is allocated is divided up into virtual log files (VLFs). Depending on the amount the log file is set to grow by the amount of VLFs that are added varies, on instances < SQL Server 2014

  • A growth of 0mb to…

Read more

0 comments, 27 reads

Posted in Gavin Draper's SQL Server Blog on 26 February 2018

Stop Worrying About Index Fragmentation and Manage Your Statistics

I see a lot of posts online about rebuilding indexes in a scheduled maintenance task, this is a pretty intensive task with some potentially large gotchas with things like online/offline, replication etc… I’ve never seen an index rebuild magically fix an issue that just rebuilding the stats wouldn’t have sorted… Read more

0 comments, 28 reads

Posted in Gavin Draper's SQL Server Blog on 25 February 2018