Darling Data
@erikdarling.com
📤 442
📥 75
📝 450
I will make your
#SQLServer
faster in exchange for money.
https://linktr.ee/darlingdata
I’m excited to announce a new corporate sponsorship.
about 13 hours ago
1
8
1
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/
about 18 hours ago
0
1
0
ICYMI: Learn all about the new Vector stuff in SQL Server 2025. Internals, usage, querying, performance, and production workload patterns.
add a skeleton here at some point
1 day ago
0
0
0
SQL Server Performance Office Hours Episode 41
https://erikdarling.com/sql-server-performance-office-hours-episode-41/
2 days ago
0
0
0
@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...
loading . . .
Decoding datetime2 columnstore segment range values
Ever queried sys.column_store_segments and wondered how to decode max_data_id and min_data_id for datetime2 values? No? Well, I’m going to show you anyway
https://chadbaldwin.net/2024/08/07/convert-datetime2-bigint.html
4 days ago
0
3
0
SQL Server 2025 is "AI-Ready", and you should be too:
training.erikdarling.com/get-ai-ready...
loading . . .
Get AI-Ready With Erik
Vector search is landing in your SQL Server whether you invited it or not. You don't have to know how it works - you just have to know how to work with it. Learn semantic search, embeddings, VECTOR ty...
https://training.erikdarling.com/get-ai-ready-with-erik?coupon=AIREADY
5 days ago
1
2
3
SQL Server 2025 is "AI-Ready", and you should be too:
training.erikdarling.com/get-ai-ready...
loading . . .
Get AI-Ready With Erik
Vector search is landing in your SQL Server whether you invited it or not. You don't have to know how it works - you just have to know how to work with it. Learn semantic search, embeddings, VECTOR ty...
https://training.erikdarling.com/get-ai-ready-with-erik?coupon=AIREADY
5 days ago
0
1
0
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/
5 days ago
0
4
0
Batch Mode Sorts and Row Mode Indexes in SQL Server
https://erikdarling.com/batch-mode-sorts-and-row-mode-indexes-in-sql-server/
6 days ago
0
3
0
Well, my rates are reasonable.
m.slashdot.org/story/450259
loading . . .
Slashdot
https://m.slashdot.org/story/450259
7 days ago
0
1
0
The Geometry of Performance Issues
https://erikdarling.com/the-geometry-of-performance-issues/
7 days ago
0
1
0
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/
8 days ago
0
3
0
SQL Server Performance Office Hours Episode 40
https://erikdarling.com/sql-server-performance-office-hours-episode-40/
9 days ago
0
2
0
typical.
www.reddit.com/r/sysadmin/c...
loading . . .
From the sysadmin community on Reddit
Explore this post and more from the sysadmin community
https://www.reddit.com/r/sysadmin/comments/1pl3bmk/i_would_be_embarrassed_to_send_this_message_to/
10 days ago
2
4
1
PASS Data Community Summit SWAG-A-THON!
https://erikdarling.com/pass-data-community-summit-swag-a-thon/
12 days ago
0
0
0
recently answered:
dba.stackexchange.com/a/349429/32281
loading . . .
Why doesn't SQL Server match computed column to an index when the expression is trivial?
I have a table with two computed columns (indexed, but not persisted). The first computed column matches an existing column exactly. The second computed column is an expression that adds 0 to the v...
https://dba.stackexchange.com/a/349429/32281
13 days ago
0
1
0
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/
13 days ago
0
1
0
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/
14 days ago
0
0
0
Faster Better Wronger
https://erikdarling.com/faster-better-wronger/
15 days ago
0
0
0
SQL Server Performance Office Hours Episode 39
https://erikdarling.com/sql-server-performance-office-hours-episode-39/
16 days ago
0
1
0
reposted by
Darling Data
Andy Pavlo
18 days ago
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...
loading . . .
2025 in Review with Mike Stonebraker and Andy Pavlo
Webcast Dec 10: DBMS researchers Mike Stonebraker (MIT / DBOS) and Andy Pavlo (CMU) discuss which data and CS trends are heating up or cooling down heading into 2026.
https://www.dbos.dev/webcast-2025-in-review-with-mike-stonebraker-and-andy-pavlo
3
74
20
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/
19 days ago
0
3
0
A Weird Thing With NOEXPAND
https://erikdarling.com/a-weird-thing-with-noexpand/
20 days ago
0
2
0
color me shocked: "Zig leadership puts the blame on Microsoft's growing AI-first priorities and declining engineering quality."
slashdot.org/story/25/12/...
loading . . .
Zig Quits GitHub, Says Microsoft's AI Obsession Has Ruined the Service - Slashdot
The Zig Software Foundation has quit GitHub after years of unresolved GitHub Actions bugs -- including a "safe_sleep" script that could spin forever and cripple CI runners. Zig leadership puts the bla...
https://slashdot.org/story/25/12/03/070228/zig-quits-github-says-microsofts-ai-obsession-has-ruined-the-service
21 days ago
0
1
0
A Bug In Batch Mode Adaptive Join Plan Timings
https://erikdarling.com/a-bug-in-batch-mode-adaptive-join-plan-timings/
21 days ago
0
3
1
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 😤
21 days ago
0
3
0
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...
22 days ago
0
0
0
A Little About Default Constraint UDFs in SQL Server
https://erikdarling.com/a-little-about-default-constraint-udfs-in-sql-server/
22 days ago
0
1
0
SQL Server Performance Office Hours Episode 38
https://erikdarling.com/sql-server-performance-office-hours-episode-38/
23 days ago
0
2
0
today officially marks 25 years of developers being misinformed about table variables.
24 days ago
1
5
1
Celebrating the only four German words I know.
24 days ago
2
6
0
Black Friday Deal #2: 30% off all bundled consulting hours packages:
training.erikdarling.com?coupon=BLACK...
loading . . .
Darling Data
https://training.erikdarling.com/?coupon=BLACKFRIDAYCONSULTING
26 days ago
0
1
1
Black Friday Deal #1: 50% off all full training class purchases:
training.erikdarling.com?coupon=BLACK...
loading . . .
Darling Data
https://training.erikdarling.com/?coupon=BLACKFRIDAYTRAINING
26 days ago
0
0
0
Row Goals: Part 4
https://erikdarling.com/row-goals-part-4/
26 days ago
0
0
0
Row Goals: Part 3
https://erikdarling.com/row-goals-part-3/
27 days ago
0
0
0
my first ssms 22 bug report:
developercommunity.visualstudio.com/t/SSMS-22:-C...
loading . . .
Developer Community
Developer Community
https://developercommunity.visualstudio.com/t/SSMS-22:-CTRLR-Shortcut-Doesnt-Work-Fr/11007268
28 days ago
0
0
0
Row Goals: Part 2
https://erikdarling.com/row-goals-part-2/
28 days ago
0
1
0
Row Goals: Part 1
https://erikdarling.com/row-goals-part-1/
29 days ago
0
0
0
My first SQL Server 2025 bug report:
feedback.azure.com/d365communit...
loading . . .
Community
https://feedback.azure.com/d365community/idea/296be6d3-6bc9-f011-ad8f-7c1e52baa666
30 days ago
0
5
0
SQL Server Performance Office Hours Episode 37
https://erikdarling.com/sql-server-performance-office-hours-episode-37/
30 days ago
0
1
0
Guess he read the SQL Server 2025 release notes.
finance.yahoo.com/news/bill-ga...
loading . . .
Bill Gates Just Dumped 65% of His Microsoft Stock. Should You Sell?
Microsoft co-founder (NASDAQ:MSFT) Bill Gates once held the vast majority of his personal wealth in the company’s shares. Over decades, he gradually reduced his direct ownership through sales and mass...
https://finance.yahoo.com/news/bill-gates-just-dumped-65-154711186.html
about 1 month ago
0
8
0
Erik cries when SSMS lies
https://erikdarling.com/erik-cries-when-ssms-lies/
about 1 month ago
0
0
0
Lost In Costs: Part 3
https://erikdarling.com/lost-in-costs-part-3/
about 1 month ago
0
0
0
just finished my new book.
about 1 month ago
2
15
1
Lost In Costs: Part 2
https://erikdarling.com/lost-in-costs-part-2/
about 1 month ago
0
0
0
And all this time I thought my eyes were just getting worse:
www.howtogeek.com/heres-why-th...
loading . . .
Here’s why The X-Files still looks amazing 30 years later
The truth is in here
https://www.howtogeek.com/heres-why-the-x-files-still-looks-amazing-30-years-later/
about 1 month ago
0
1
0
i woke up today wishing it was friday, so i pushed friday's release of my sql server troubleshooting procedures early:
github.com/erikdarlingd...
loading . . .
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...
https://github.com/erikdarlingdata/DarlingData/releases/tag/Updates_20251114
about 1 month ago
0
1
0
Lost In Costs: Part 1
https://erikdarling.com/lost-in-costs-part-1/
about 1 month ago
0
0
0
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/
about 1 month ago
0
0
0
SQL Server Performance Office Hours Episode 36
https://erikdarling.com/sql-server-performance-office-hours-episode-36/
about 1 month ago
0
0
0
Load more
feeds!
log in