Darling Data
@erikdarling.com
November 15, 2025 at 12:40 AM
November 14, 2025 at 2:00 PM
just finished my new book.
November 13, 2025 at 11:52 PM
just finished my new book.
November 13, 2025 at 2:00 PM
And all this time I thought my eyes were just getting worse: www.howtogeek.com/heres-why-th...
Here’s why The X-Files still looks amazing 30 years later
The truth is in here
www.howtogeek.com
November 12, 2025 at 5:52 PM
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...
Release It's lonely out in space · erikdarlingdata/DarlingData
What's Changed
burg by @erikdarlingdata in #636
Dev by @erikdarlingdata in #642
sp_QuickieStore: Correct window function in lasts by @ReeceGoding in #644
Dev by @erikdarlingdata in #647
Full Chan...
github.com
November 12, 2025 at 2:42 PM
i woke up today wishing it was friday, so i pushed friday's release of my sql server troubleshooting procedures early: github.com/erikdarlingd...
November 12, 2025 at 2:00 PM
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/
https://erikdarling.com/a-little-about-scalar-udfs-and-read-committed-snapshot-isolation-in-sql-server/
November 11, 2025 at 2:00 PM
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/
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/
https://erikdarling.com/sql-server-performance-office-hours-episode-36/
November 10, 2025 at 2:01 PM
SQL Server Performance Office Hours Episode 36
https://erikdarling.com/sql-server-performance-office-hours-episode-36/
https://erikdarling.com/sql-server-performance-office-hours-episode-36/
I came to the realization that my espresso machine is just an expensive Giga Pet. It runs out of beans and I feed it. It runs out of water and I refill it. The drip tray or waste bucket fill up and I change its diaper. Descale. Replace filter. On and on. It's loud. Just for some caffeine.
November 9, 2025 at 4:05 PM
I came to the realization that my espresso machine is just an expensive Giga Pet. It runs out of beans and I feed it. It runs out of water and I refill it. The drip tray or waste bucket fill up and I change its diaper. Descale. Replace filter. On and on. It's loud. Just for some caffeine.
A Little About Serializable Escalation In SQL Server
https://erikdarling.com/a-little-about-serializable-escalation-in-sql-server/
https://erikdarling.com/a-little-about-serializable-escalation-in-sql-server/
November 7, 2025 at 2:00 PM
A Little About Serializable Escalation In SQL Server
https://erikdarling.com/a-little-about-serializable-escalation-in-sql-server/
https://erikdarling.com/a-little-about-serializable-escalation-in-sql-server/
Why Partitioning Is Not A Performance Feature In SQL Server
https://erikdarling.com/why-partitioning-is-not-a-performance-feature-in-sql-server/
https://erikdarling.com/why-partitioning-is-not-a-performance-feature-in-sql-server/
November 6, 2025 at 2:00 PM
Why Partitioning Is Not A Performance Feature In SQL Server
https://erikdarling.com/why-partitioning-is-not-a-performance-feature-in-sql-server/
https://erikdarling.com/why-partitioning-is-not-a-performance-feature-in-sql-server/
A Lot About Multi-Statement Table Valued Function In SQL Server
https://erikdarling.com/a-lot-about-multi-statement-table-valued-function-in-sql-server/
https://erikdarling.com/a-lot-about-multi-statement-table-valued-function-in-sql-server/
November 5, 2025 at 2:00 PM
A Lot About Multi-Statement Table Valued Function In SQL Server
https://erikdarling.com/a-lot-about-multi-statement-table-valued-function-in-sql-server/
https://erikdarling.com/a-lot-about-multi-statement-table-valued-function-in-sql-server/
A Little About Optimizer Nudging In SQL Server
https://erikdarling.com/a-little-about-optimizer-nudging-in-sql-server/
https://erikdarling.com/a-little-about-optimizer-nudging-in-sql-server/
November 4, 2025 at 2:01 PM
A Little About Optimizer Nudging In SQL Server
https://erikdarling.com/a-little-about-optimizer-nudging-in-sql-server/
https://erikdarling.com/a-little-about-optimizer-nudging-in-sql-server/
SQL Server Performance Office Hours Episode 35
https://erikdarling.com/sql-server-performance-office-hours-episode-35/
https://erikdarling.com/sql-server-performance-office-hours-episode-35/
November 3, 2025 at 2:04 PM
SQL Server Performance Office Hours Episode 35
https://erikdarling.com/sql-server-performance-office-hours-episode-35/
https://erikdarling.com/sql-server-performance-office-hours-episode-35/
how on earth does this not get simplified out of the query plan
November 2, 2025 at 3:17 PM
how on earth does this not get simplified out of the query plan
amusing morning symmetry.
November 1, 2025 at 3:13 PM
amusing morning symmetry.
recently answered: dba.stackexchange.com/a/349130/32281
The query times out when executed through the application
I have a query that, when executed in SQL Server Management Studio takes only 2 seconds to run, but when I execute it through the application, it takes 1 minute and times out. I increased the timeo...
dba.stackexchange.com
October 31, 2025 at 7:11 PM
recently answered: dba.stackexchange.com/a/349130/32281
Yeah AlwaysOn more like AlwaysGone
October 31, 2025 at 5:01 PM
Yeah AlwaysOn more like AlwaysGone
Introducing My SQL Server Performance Engineering Course
https://erikdarling.com/introducing-my-sql-server-performance-engineering-course/
https://erikdarling.com/introducing-my-sql-server-performance-engineering-course/
October 31, 2025 at 1:00 PM
Introducing My SQL Server Performance Engineering Course
https://erikdarling.com/introducing-my-sql-server-performance-engineering-course/
https://erikdarling.com/introducing-my-sql-server-performance-engineering-course/
A Little About Table Variable Deferred Compilation Depth In SQL Server
https://erikdarling.com/a-little-about-table-variable-deferred-compilation-depth-in-sql-server/
https://erikdarling.com/a-little-about-table-variable-deferred-compilation-depth-in-sql-server/
October 30, 2025 at 1:00 PM
A Little About Table Variable Deferred Compilation Depth In SQL Server
https://erikdarling.com/a-little-about-table-variable-deferred-compilation-depth-in-sql-server/
https://erikdarling.com/a-little-about-table-variable-deferred-compilation-depth-in-sql-server/
recently answered: dba.stackexchange.com/a/349124/32281
SSMS Noob Error: The query references an object that is not supported in distributed processing mode
I'm new to SQL and am trying to query a view (dbo.) made from a D365 table. My goal is to do a recursive joins on 4 different views but to start with I tried something basic and received the follow...
dba.stackexchange.com
October 29, 2025 at 1:47 PM
recently answered: dba.stackexchange.com/a/349124/32281
It's just another day for you...
You and me in paradise
You and me in paradise
October 29, 2025 at 1:37 PM
It's just another day for you...
You and me in paradise
You and me in paradise
Table Variable vs Local Variable Cardinality Estimates in SQL Server
https://erikdarling.com/table-variable-vs-local-variable-cardinality-estimates-in-sql-server/
https://erikdarling.com/table-variable-vs-local-variable-cardinality-estimates-in-sql-server/
October 29, 2025 at 1:00 PM
Table Variable vs Local Variable Cardinality Estimates in SQL Server
https://erikdarling.com/table-variable-vs-local-variable-cardinality-estimates-in-sql-server/
https://erikdarling.com/table-variable-vs-local-variable-cardinality-estimates-in-sql-server/