"0 to 60" : Switching to indirect checkpoints
I talk about a recent change where I started turning on indirect checkpoints across all user databases.
Category: SQL Server
Removing the default trace – Part 3
I finish up my series on replacing the default trace with views to simplify consumption and a caveat about reports in SSMS.
File and Filegroup Space Usage – Part 1
See the stored procedure I wrote to help me put all file, filegroup, and index information in one place.
Removing the default trace – Part 2
I continue my series on replacing the default trace with a more efficient and more complete Extended Events session.
Illogical errors can be a factor of the plan
See a quick example where plan shape can cause errors that really shouldn't happen.
Changing a function's interface but staying backward compatible
In this tip, see ways you can change how a function is called without having to modify all calling code at the same time.
Attaching / restoring databases inside a container
Need to get data, log, or bak files into your container's file system? See how, with docker cp.
Removing the default trace – part 1
I start a series explaining how I evaluated the default trace and decided to replace it with a slimmer Extended Events session across all of production.
SQL Server Checkpoint Monitoring with Extended Events
See how you can use Extended Events to find your worst performing checkpoints.
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.
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.