SQL Server Checkpoint Monitoring with Extended Events
See how you can use Extended Events to find your worst performing checkpoints.
Category: SQL Server
Use caution with sys.dm_db_database_page_allocations
In this tip, I talk about a concerning behavior in the dynamic management function, sys.dm_db_database_page_allocations.
Fun with (columnstore) compression on a very large table – part 3
I continue my series on large table compression with results from row and page compression as well as a process involving scheduler manipulation.
A reliable and flexible replacement for sp_MSforeachdb
Find out about the replacement I wrote for the undocumented, unsupported, and ill-advised system procedure, sp_MSforeachdb.
How soft deletes can slow ghost record growth in Availability Groups
In this tip, I show how soft deletes and a filtered index can help minimize the cost of ghost records in an Availability Group.
Fun with (columnstore) compression on a very large table – part 2
I continue my series on investigating compression for a 1TB table, honing in on clustered columnstore and partitioning.
Using metadata to troubleshoot metadata
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.
Filtered Indexes and Forced Parameterization (redux)
Discover a simple way to keep your filtered indexes effective – even under forced parameterization.
Should we still chunk delete operations?
Conventional wisdom has suggested that deletes should be batched, but in some cases this can actually take a lot longer.
PASS Summit 2019 Keynote – Day 2
See the highlights from the second keynote at PASS Summit 2019 in Seattle.
Focus Groups at PASS Summit 2019
Register now for focus groups hosted by the product teams at PASS Summit next week!
Simulating ON DELETE CASCADE
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.
T-SQL Tuesday #119 : Changing My Mind
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.
Document Columns Across Systems
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, Meet Filtered Indexes
Forced Parameterization can be a useful setting to tune workloads, but this can work against you if you're also using filtered indexes.
A quick tip when using multiple Docker containers and SQL Server
Give your Docker container port numbers meaning to avoid confusion, especially when presenting or giving demos.
Bad habits to kick : avoiding the schema prefix
Originally published in 2009, I updated this in 2019 with an example showing an effect on the plan cache.
Materials from Music City Data
Aaron shares his slides and demos from his most recent delivery of T-SQL : Bad Habits and Best Practices.
Features and Fixes in SentryOne Plan Explorer 19.1.2
Read about the improvements in the latest version of SentryOne Plan Explorer, 19.1.2.
Another limitation of STRING_SPLIT
Did you know that not all characters can be used as the separator for STRING_SPLIT?
Partitioning Data without using Partitioned Tables
Read about an approach to partitioning a result set without the performance impact of NTILE.