I’m excited to announce a new corporate sponsorship.

T-SQL Scalar UDF Plan Caching and Reuse in SQL Server https://erikdarling.com/t-sql-scalar-udf-plan-caching-and-reuse-in-sql-server/

ICYMI: Learn all about the new Vector stuff in SQL Server 2025. Internals, usage, querying, performance, and production workload patterns.

SQL Server Performance Office Hours Episode 41 https://erikdarling.com/sql-server-performance-office-hours-episode-41/

@chadbaldwin.net thanks for this post! it took a bit of work to get things to work with datetime, but it saved me a ton of time. chadbaldwin.net/2024/08/07/c...

SQL Server 2025 is "AI-Ready", and you should be too: training.erikdarling.com/get-ai-ready...

SQL Server 2025 is "AI-Ready", and you should be too: training.erikdarling.com/get-ai-ready...

New in SQL Server Management Studio 22: Open Execution Plans In a New Tab! https://erikdarling.com/new-in-sql-server-management-studio-22-open-execution-plans-in-a-new-tab/

Batch Mode Sorts and Row Mode Indexes in SQL Server https://erikdarling.com/batch-mode-sorts-and-row-mode-indexes-in-sql-server/

Well, my rates are reasonable. m.slashdot.org/story/450259

The Geometry of Performance Issues https://erikdarling.com/the-geometry-of-performance-issues/

Introducing sp_QueryReproBuilder: Quickly Get Executable Query Examples from Query Store https://erikdarling.com/introducing-sp_queryreprobuilder-quickly-get-executable-query-examples-from-query-store/

SQL Server Performance Office Hours Episode 40 https://erikdarling.com/sql-server-performance-office-hours-episode-40/

typical. www.reddit.com/r/sysadmin/c...

PASS Data Community Summit SWAG-A-THON! https://erikdarling.com/pass-data-community-summit-swag-a-thon/

recently answered: dba.stackexchange.com/a/349429/32281

A Follow Up On Fixing Parallel Plan Row Skew In SQL Server https://erikdarling.com/a-follow-up-on-fixing-parallel-plan-row-skew-in-sql-server/

How Many Plan Variants Can You Get With The Parameter Sensitive Plan Optimization In SQL Server? https://erikdarling.com/how-many-plan-variants-can-you-get-with-the-parameter-sensitive-plan-optimization-in-sql-server/

Faster Better Wronger https://erikdarling.com/faster-better-wronger/

SQL Server Performance Office Hours Episode 39 https://erikdarling.com/sql-server-performance-office-hours-episode-39/

Do you like databases? Do you want to hear two database professors rant about them? Do you need one of those professors to have a Turing Award for databases? If yes, then join Mike Stonebraker and I next Wed Dec 10 @ 1:00pm EST for database hot takes: www.dbos.dev/webcast-2025...

Why DISKANN Indexes Are So Slow To Create In SQL Server https://erikdarling.com/why-diskann-indexes-are-so-slow-to-create-in-sql-server/

A Weird Thing With NOEXPAND https://erikdarling.com/a-weird-thing-with-noexpand/

color me shocked: "Zig leadership puts the blame on Microsoft's growing AI-first priorities and declining engineering quality." slashdot.org/story/25/12/...

A Bug In Batch Mode Adaptive Join Plan Timings https://erikdarling.com/a-bug-in-batch-mode-adaptive-join-plan-timings/

not sure what all the fuss about vector is in sql server 2025. we were all getting along just fine with soundex and difference functions 😤

Discounts good through Friday: 50% off all training class bundles: training.erikdarling.com?coupon=BLACK... 30% off all consulting hours bundles: training.erikdarling.com?coupon=BLACK...

A Little About Default Constraint UDFs in SQL Server https://erikdarling.com/a-little-about-default-constraint-udfs-in-sql-server/

SQL Server Performance Office Hours Episode 38 https://erikdarling.com/sql-server-performance-office-hours-episode-38/

today officially marks 25 years of developers being misinformed about table variables.

Celebrating the only four German words I know.

Black Friday Deal #2: 30% off all bundled consulting hours packages: training.erikdarling.com?coupon=BLACK...

Black Friday Deal #1: 50% off all full training class purchases: training.erikdarling.com?coupon=BLACK...

Row Goals: Part 4 https://erikdarling.com/row-goals-part-4/

Row Goals: Part 3 https://erikdarling.com/row-goals-part-3/

my first ssms 22 bug report: developercommunity.visualstudio.com/t/SSMS-22:-C...

Row Goals: Part 2 https://erikdarling.com/row-goals-part-2/

Row Goals: Part 1 https://erikdarling.com/row-goals-part-1/

My first SQL Server 2025 bug report: feedback.azure.com/d365communit...

SQL Server Performance Office Hours Episode 37 https://erikdarling.com/sql-server-performance-office-hours-episode-37/

Guess he read the SQL Server 2025 release notes. finance.yahoo.com/news/bill-ga...

Erik cries when SSMS lies https://erikdarling.com/erik-cries-when-ssms-lies/

Lost In Costs: Part 3 https://erikdarling.com/lost-in-costs-part-3/

just finished my new book.

Lost In Costs: Part 2 https://erikdarling.com/lost-in-costs-part-2/

And all this time I thought my eyes were just getting worse: www.howtogeek.com/heres-why-th...

i woke up today wishing it was friday, so i pushed friday's release of my sql server troubleshooting procedures early: github.com/erikdarlingd...

Lost In Costs: Part 1 https://erikdarling.com/lost-in-costs-part-1/

A Little About Scalar UDFs and Read Committed Snapshot Isolation In SQL Server https://erikdarling.com/a-little-about-scalar-udfs-and-read-committed-snapshot-isolation-in-sql-server/

SQL Server Performance Office Hours Episode 36 https://erikdarling.com/sql-server-performance-office-hours-episode-36/