Practical guides and insights for modern data practitioners
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
In this post I cover part 2 of a series about maintaining your larger databases better if you use SQL Server. It covers indexes. In my last post I covered some ways you can maintain your larger databases better. This post is the next in this series and covers indexes in more detail. So, here’s … Read more
In this post I will cover fixing some of the problems caused when you first introduce Columnstore indexes to a SQL Server database. Because in my last post I talked about fixing some of the problems caused when you introduce rowstore filtered indexes. Before we start I’d just like to point out I’m not going … Read more