Darling Data

Learn T-SQL With Erik: UNION and UNION ALL

https://erikdarling.com/learn-t-sql-with-erik-union-and-union-all/

Learn T-SQL With Erik: Pivot and Unpivot

https://erikdarling.com/learn-t-sql-with-erik-pivot-and-unpivot/

SQL Server Performance Office Hours Episode 23

https://erikdarling.com/sql-server-performance-office-hours-episode-23/

It's Time to Get Rid of the Cost Threshold for Parallelism Setting.

https://erikdarling.com/its-time-to-get-rid-of-the-cost-threshold-for-parallelism-setting/

‘Si quidem deus,’ inquit, ‘est, unde mala? Bona vero unde, si non est?

How To Think Like A Batch (Mode) In SQL Server

https://erikdarling.com/how-to-think-like-a-batch-mode-in-sql-server/

Spotting Batch Mode Opportunities in SQL Server Query Execution Plans

https://erikdarling.com/spotting-batch-mode-opportunities-in-sql-server-query-execution-plans/

A Little About: Old vs New Cardinality Estimators In SQL Server

https://erikdarling.com/a-little-about-old-vs-new-cardinality-estimators-in-sql-server/

SQL Server Performance Office Hours Episode 22

https://erikdarling.com/sql-server-performance-office-hours-episode-22/

Dell Pro Max 18 Plus comes with up to 128GB RAM, and will soon double it, but avoids AMD Ryzen entirely Dell Pro Max 18 Plus with a mere 128GB of RAM is already on sale

DRAMs do come true: www.techradar.com/pro/dell-wil...

Carry Over Sort vs Batch Mode Window Functions

https://erikdarling.com/carry-over-sort-vs-batch-mode-window-functions/

Learn T-SQL With Erik: Window Function Tricks for SQL Server 2022+

https://erikdarling.com/learn-t-sql-with-erik-window-function-tricks-for-sql-server-2022/

Learn T-SQL With Erik: Window Functions and Aggregates

https://erikdarling.com/learn-t-sql-with-erik-window-functions-and-aggregates/

Common Table Expression Fork Bombs

https://erikdarling.com/common-table-expression-fork-bombs/

SQL Server Performance Office Hours Episode 21

https://erikdarling.com/sql-server-performance-office-hours-episode-21/

Learn T-SQL With Erik: Grouping Sets vs Union All

https://erikdarling.com/learn-t-sql-with-erik-grouping-sets-vs-union-all/

Erik Tests a New Microphone

https://erikdarling.com/erik-tests-a-new-microphone/

Spurious Left Join Logic

https://erikdarling.com/spurious-left-join-logic/

Stubborn NOT EXISTS Ordering

https://erikdarling.com/stubborn-not-exists-ordering/

My Upcoming Speaking Schedule

https://erikdarling.com/my-upcoming-speaking-schedule-3/

This article has a number of nifty animations in it, but of course this is my favorite. planetscale.com/blog/caching

Life is full of possibilities.

I should sue.

I thought you were just busy shoveling snow.

That must be hell on the kidneys

Brutal.

i'm sure there are openings in the fabric mvp program.

It’s the Nana bear paw sticker that really brings it all home.

I have questions but I’m not sure I want answers.

finally documented: no cte materialization in sql server: learn.microsoft.com/en-us/sql/t-...