Minimizing PAGELATCH_EX waits in SQL Server 2019
In this tip, I show how you can evaluate a new index option in SQL Server 2019 aimed at reducing PAGELATCH_EX waits: OPTIMIZE_FOR_SEQUENTIAL_KEY.
Category: SQL Server 2019
SQL Server 2019 Adventures on CentOS 7.5
After thinking setting up SQL Server 2019 on CentOS 7.5 was going to be a piece of cake, I explain how my team helped resolve a TLS issue preventing remote connections.
SQL Server 2019 Cumulative Update #11
SQL Server 2019 Cumulative Update #11 is available, with 62 enhancements. The build number is 15.0.4138.2.
SQL Server 2019 Cumulative Update #10
SQL Server 2019 Cumulative Update #10 is available, with 63 enhancements. The build number is 15.0.4123.1.
SQL Server 2019 Cumulative Update #9
SQL Server 2019 Cumulative Update #9 is available, with 140 enhancements. The build number is 15.0.4102.2.
SQL Server 2019 Cumulative Update #8
SQL Server 2019 Cumulative Update #8 is available, with 104 enhancements. The build number is 15.0.4073.23.
Avoid SQL Server 2019 Cumulative Update #7
I like to encourage people to always be on the latest Cumulative Update, but lately my confidence has been eroding. The latest patch for SQL Server 2019 hasn't helped.
SQL Server 2019 Cumulative Update #7
SQL Server 2019 Cumulative Update #7 is available, with 56 enhancements. The build number is 15.0.4063.15.
SQL Server 2019 Cumulative Update #6
SQL Server 2019 Cumulative Update #6 is available, with 51 enhancements. The build number is 15.0.4053.23.
SQL Server 2019 Cumulative Update #5
SQL Server 2019 Cumulative Update #5 is available, with 86 enhancements. The build number is 15.0.4043.16.
Replace legacy splitting functions with STRING_SPLIT
See how to work around some of the blockers for replacing legacy UDFs with STRING_SPLIT.
SQL Server Cumulative Updates Delayed
Cumulative Updates for SQL Server 2019, SQL Server 2017, and SQL Server 2016 SP2 have been pushed back a month or more due to our current health crisis.
SQL Server 2019 Cumulative Update #4
SQL Server 2019 Cumulative Update #4 is available, with 50 enhancements. The build number is 15.0.4033.1.
SQL Server 2019 Cumulative Update #3
SQL Server 2019 Cumulative Update #3 is available, with 56 enhancements. The build number is 15.0.4023.6.
Measure Delayed Durability impact in SQL Server 2016 and later
In this tip, I show how to measure the positive effects of delayed durability, in cases where a small amount of data loss is acceptable.
SQL Server 2019 Cumulative Update #2
It's a few days later than many of us were expecting, but Cumulative Update #2 for SQL Server 2019 (15.0.4013.40) is overflowing with 134 fixes and enhancements.
SQL Server 2019 Cumulative Update #1
SQL Server 2019 Cumulative Update #1 is now available, with 83 fixes and improvements. Build # is 15.0.4003.23.
A simple use case for columnstore indexes
In this tip, I show how and why a columnstore index can provide benefits to COUNT(*) queries.
Introducing Big Data Clusters and SQL Server 2019
Let's talk a bit about the launch of SQL Server 2019 and the flagship, bet-the-farm feature: Big Data Clusters.
SQL Server 2019 Installation Enhancements
I talk a little bit about two big enhancements for SQL Server 2019: installation options for setting MAXDOP and Max Server Memory.
Memory-Optimized TempDB Metadata
Get a quick overview of a powerful new feature in SQL Server 2019 that will drastically improve certain tempdb-heavy workloads.