I start a series looking at using clustered columnstore indexes and page compression to address storage footprint for a 1TB table.
Yearly Archive: 2019
I show how I tried to chase down a very unexpected issue with SQL Server metadata. Spoiler: it didn't end the way I thought it would.
For this month's T-SQL Tuesday, I talk about an opportunity earlier this year to significantly change my career trajectory.
Discover a simple way to keep your filtered indexes effective – even under forced parameterization.
Conventional wisdom has suggested that deletes should be batched, but in some cases this can actually take a lot longer.
Let's talk a bit about the launch of SQL Server 2019 and the flagship, bet-the-farm feature: Big Data Clusters.
I talk a little bit about two big enhancements for SQL Server 2019: installation options for setting MAXDOP and Max Server Memory.
Notes and ramblings from the annual WIT Luncheon once again sponsored by SentryOne.
Get a quick overview of a powerful new feature in SQL Server 2019 that will drastically improve certain tempdb-heavy workloads.
See the highlights from the second keynote at PASS Summit 2019 in Seattle.
See the highlights from the first-day keynote at PASS Summit 2019 in Seattle.
I share some thoughts about the upcoming SQL Server 2019 release and edition-specific features.
Register now for focus groups hosted by the product teams at PASS Summit next week!
See how to generate a set of scripts that will delete rows from dependent tables and show you how many rows will be deleted from each.
I take a quick look at the performance and storage impact of the new UTF-8 collations in SQL Server 2019.
For this month's T-SQL Tuesday, I talk about an incident where I've changed my mind about something I was previously pretty stubborn about.
Find out how to use dynamic SQL to quickly generate metadata queries to pull attributes for all columns across a database or even a set of databases.
Forced Parameterization can be a useful setting to tune workloads, but this can work against you if you're also using filtered indexes.
Give your Docker container port numbers meaning to avoid confusion, especially when presenting or giving demos.
Originally published in 2009, I updated this in 2019 with an example showing an effect on the plan cache.
Aaron shares his slides and demos from his most recent delivery of T-SQL : Bad Habits and Best Practices.