Practical guides and insights for modern data practitioners
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 it. My feedback was to do with the current recommendations from Microsoft about when to either reorganize or rebuild an index. Because I had talked about it online a couple … Read more
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 on my own experiences over the years. Of course, we all have our own ideas about what a large SQL Server script is. Some people would say it’s hundreds of … Read more
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 some of the reasons that I have experienced here. In truth, some of these I discussed in a series I posted last year about maintaining larger SQL Databases better. You … Read more
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 hashtag on Twitter about information which is in these posts. So, I have decided to do this post as a quick recap about them to help others. Reading these posts … Read more
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 by default. Setting this at the database level allows index rebuilds to be online by default. Without having to specify it in the index rebuild command. When you select this … Read more
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 recommended free tools you can use. I decided to cover free tools because in general people prefer things that are free. With this in mind, I wanted to recommend ones … Read more
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 Server. I’ve done this post about personally recommended DMV’s because they can help you maintain your larger databases better. If you’ve yet to read the other parts of this series, … Read more
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, in a past post here I did an overview of different index types. I said in that post that I think filtered indexes could be more popular. Some of you … Read more
Introduction I want to do a unique review of SQL Server index types in this post. In order to help raise awareness about some of them. Because one thing I have noticed in various places is that people still tend to use the traditional clustered and non clustered indexes. However, I rarely see the filtered … Read more