Reading Time: 2 minutes Since returning from my one month break I’ve been giving some 2018 posts a makeover. Because I felt that some deserved it for various reasons.…
A blog about Microsoft Data Platform offerings
Reading Time: 2 minutes Since returning from my one month break I’ve been giving some 2018 posts a makeover. Because I felt that some deserved it for various reasons.…
Reading Time: 2 minutes In this post I want to cover some thoughts about SQL Server index fragmentation recommendations I have had. Because recently I provided some feedback about…
Reading Time: 6 minutes Since I’ve been giving some advice to others recently I thought I would share tips for dealing with large SQL Server scripts. Which are based…
Reading Time: 3 minutes Recently there’s been a few questions asked online about slow clustered index rebuilds within SQL Server for rowstore indexes. So, I thought I would cover…
Reading Time: 2 minutes Last year I did some posts about maintaining larger SQL Server databases better. Since then I have had to answer some questions on the SQLHelp…
Reading Time: 3 minutes Recently I made an interesting discovery about SQL Server 2019 database scoped settings. Because I tested the one that sets index rebuilds to be online…
Reading Time: 2 minutes Since it’s the holiday season I thought I’d post a list of all posts published since PASS Summit. Even though I only started this site…
Reading Time: 4 minutes Introduction In this post I cover part 4 of a series about maintaining your larger databases better if you use SQL Server. It covers personally…
Reading Time: 5 minutes In this post I cover personally recommended SQL Server DMV’s, part 3 of a series about maintaining your larger databases better if you use SQL…
Reading Time: 3 minutes In this post I want to cover fixing some of the problems caused when you introduce rowstore filtered indexes. Because issues can occur. In addition,…