SQL Server

High LCK_M_SCH_M waits

I describe a scenario where Common Criteria compliance was deemed the cause of high LCK_M_SCH_M waits for multiple customers.

Readable secondaries on a budget

I demonstrate an affordable approach to readable secondaries, without the need for Availability Groups and all the licensing costs involved with Enterprise Edition and Software Assurance.

Bad Habits to Kick: AttachDBFileName

I point out that an often-used connection setting, AttachDBFileName, may be the source of many wasted hours of debugging and troubleshooting.

Grouped concatenation

I show the safest and most efficient ways to perform grouped concatenation in SQL Server.

New trace flag to fix table variable performance

Following a recent update, I take a first look at a new performance enhancement and trace flag (2453) aimed at improving cardinality estimates for table variables and table-valued parameters.

Dude, who owns that #temp table?

I show how you can use Extended Events to track temp table creation and identify which session created which #temp table.