Darling Data
@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/
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/
A Little About *Why* Local Variables Give Weird Cardinality Estimates in SQL Server
https://erikdarling.com/a-little-about-why-local-variables-give-weird-cardinality-estimates-in-sql-server/
https://erikdarling.com/a-little-about-why-local-variables-give-weird-cardinality-estimates-in-sql-server/
October 28, 2025 at 1:01 PM
A Little About *Why* Local Variables Give Weird Cardinality Estimates in SQL Server
https://erikdarling.com/a-little-about-why-local-variables-give-weird-cardinality-estimates-in-sql-server/
https://erikdarling.com/a-little-about-why-local-variables-give-weird-cardinality-estimates-in-sql-server/
SQL Server Performance Office Hours Episode 34
https://erikdarling.com/sql-server-performance-office-hours-episode-34/
https://erikdarling.com/sql-server-performance-office-hours-episode-34/
October 27, 2025 at 1:01 PM
SQL Server Performance Office Hours Episode 34
https://erikdarling.com/sql-server-performance-office-hours-episode-34/
https://erikdarling.com/sql-server-performance-office-hours-episode-34/
I spent some time this weekend trying to get spatial results into sp_QuickieStore to help show the magnitude of query performance issues. It sort of works, but I’m not thrilled with it. There’s no way to label the X/Y axis or have a default label for the shapes.
October 26, 2025 at 5:42 PM
I spent some time this weekend trying to get spatial results into sp_QuickieStore to help show the magnitude of query performance issues. It sort of works, but I’m not thrilled with it. There’s no way to label the X/Y axis or have a default label for the shapes.
This year's PASS Data Community Summit t-shirts are COMING IN HOT! If you're attending me and @kendralittle.bsky.social's precons, you just might could score one!
October 24, 2025 at 7:24 PM
This year's PASS Data Community Summit t-shirts are COMING IN HOT! If you're attending me and @kendralittle.bsky.social's precons, you just might could score one!
Learn T-SQL With Erik: Inline Table Valued Functions
https://erikdarling.com/learn-t-sql-with-erik-inline-table-valued-functions/
https://erikdarling.com/learn-t-sql-with-erik-inline-table-valued-functions/
October 24, 2025 at 1:01 PM
Learn T-SQL With Erik: Inline Table Valued Functions
https://erikdarling.com/learn-t-sql-with-erik-inline-table-valued-functions/
https://erikdarling.com/learn-t-sql-with-erik-inline-table-valued-functions/
I finally got my first unfriendly stack overflow comment
https://erikdarling.com/i-finally-got-my-first-unfriendly-stack-overflow-comment/
https://erikdarling.com/i-finally-got-my-first-unfriendly-stack-overflow-comment/
October 24, 2025 at 5:33 AM
I finally got my first unfriendly stack overflow comment
https://erikdarling.com/i-finally-got-my-first-unfriendly-stack-overflow-comment/
https://erikdarling.com/i-finally-got-my-first-unfriendly-stack-overflow-comment/