Darling Data
@erikdarling.com
📤 431
📥 73
📝 348
I will make your
#SQLServer
faster in exchange for money.
https://linktr.ee/darlingdata
The best way to understand any hype cycle in IT is to watch this movie.
2 days ago
1
2
1
Adaptive Join operator times do not work correctly in some cases
feedback.azure.com/d365communit...
loading . . .
Community
https://feedback.azure.com/d365community/idea/5b3432ab-b5aa-f011-aa44-7c1e52926d78
2 days ago
0
2
0
niche funny.
3 days ago
0
3
0
Learn T-SQL With Erik: Bad Trigger Habits
https://erikdarling.com/learn-t-sql-with-erik-bad-trigger-habits/
9 days ago
0
2
0
Learn T-SQL With Erik: Indexed View Ups and Downs
https://erikdarling.com/learn-t-sql-with-erik-indexed-view-ups-and-downs/
10 days ago
0
1
1
Learn T-SQL With Erik: Views and TOP 100 PERCENT
https://erikdarling.com/learn-t-sql-with-erik-views-and-top-100-percent/
11 days ago
0
1
0
SQL Server Performance Office Hours Episode 32
https://erikdarling.com/sql-server-performance-office-hours-episode-32/
12 days ago
0
0
0
Learn T-SQL With Erik: Fun with RAISERROR!
https://erikdarling.com/learn-t-sql-with-erik-fun-with-raiserror/
13 days ago
0
1
0
My noon flight to Edinburgh got so delayed that I’ve been rebooked on a direct flight from Amsterdam at 5pm. Who would like to talk to me for three hours?
15 days ago
0
1
0
Learn T-SQL With Erik: How to Pick a Temporary Object
https://erikdarling.com/learn-t-sql-with-erik-how-to-pick-a-temporary-object/
16 days ago
0
2
0
Learn T-SQL With Erik: Just Use QUOTENAME!
https://erikdarling.com/learn-t-sql-with-erik-just-use-quotename/
17 days ago
0
0
0
SQL Server Performance Office Hours Episode 31
https://erikdarling.com/sql-server-performance-office-hours-episode-31/
18 days ago
0
1
0
Finally on a movie screen where there’s no “adults only” sign out front.
18 days ago
0
13
0
Learn T-SQL With Erik: Cursor Loops Are Better Than While Loops
https://erikdarling.com/learn-t-sql-with-erik-cursor-loops-are-better-than-while-loops/
19 days ago
0
0
0
Learn T-SQL With Erik: Writing Smarter While Loops
https://erikdarling.com/learn-t-sql-with-erik-writing-smarter-while-loops/
20 days ago
0
0
0
Learn T-SQL With Erik: Control Your Flow
https://erikdarling.com/learn-t-sql-with-erik-control-your-flow/
23 days ago
1
1
0
just office hours questions.
23 days ago
1
4
0
Learn T-SQL With Erik: SET, SELECT, and Data Types for Local Variables
https://erikdarling.com/learn-t-sql-with-erik-set-select-and-data-types-for-local-variables/
24 days ago
0
0
0
is there a more annoying ui choice than having toast notifications appear at the top of a phone screen, precisely where all the icons to interact with apps are?
25 days ago
0
2
0
SQL Server Performance Office Hours Episode 30
https://erikdarling.com/sql-server-performance-office-hours-episode-30/
25 days ago
0
0
0
A Little About Using Windows Performance Recorder
https://erikdarling.com/a-little-about-using-windows-performance-recorder/
26 days ago
0
0
0
A Little About Skewed Data and Skewed Parallelism
https://erikdarling.com/a-little-about-skewed-data-and-skewed-parallelism/
27 days ago
0
0
0
a buggy bug bug:
feedback.azure.com/d365communit...
loading . . .
Community
https://feedback.azure.com/d365community/idea/832f4c93-e994-f011-aa44-7c1e52926d78
30 days ago
0
0
0
ah-hem. yes. thank you. you can go now.
about 1 month ago
0
2
0
Learn T-SQL With Erik: Query Behavior Under Read Committed Row Versioning
https://erikdarling.com/learn-t-sql-with-erik-query-behavior-under-read-committed-row-versioning/
about 1 month ago
0
0
0
SQL Server Performance Office Hours Episode 29
https://erikdarling.com/sql-server-performance-office-hours-episode-29/
about 1 month ago
0
1
0
Learn T-SQL With Erik: Read Committed, Not So Committed
https://erikdarling.com/learn-t-sql-with-erik-read-committed-not-so-committed/
about 1 month ago
0
1
0
Just launched my SQL Server Performance Engineering course! 14 hours of deep-dive content, covering everything from wait stats analysis to query tuning techniques. Perfect for DBAs, developers, and consultants who need to fix pesky performance problems.
training.erikdarling.com/sql-server-p...
loading . . .
SQL Server Performance Engineering
Every SQL Server professional needs to understand not just what makes queries fast, but what makes them slow. This knowledge is essential whether you're aiming to become a performance wizard or trying...
https://training.erikdarling.com/sql-server-performance-engineering?coupon=SALESENGINEERING
about 1 month ago
0
4
1
My beloved Don and Jerry. bobblehead has lost the Don desk placard. Do I know anyone with a 3D printer who can make one?
about 1 month ago
5
3
0
@dublindata.net
drew you owe me 1000 pull ups
about 1 month ago
1
2
0
Learn T-SQL With Erik: Reads Deadlocking Writes Under Read Committed
https://erikdarling.com/learn-t-sql-with-erik-reads-deadlocking-writes-under-read-committed/
about 1 month ago
0
3
1
Learn T-SQL With Erik: Reads Blocking Writes Under Read Committed
https://erikdarling.com/learn-t-sql-with-erik-reads-blocking-writes-under-read-committed/
about 1 month ago
0
1
0
recently answered:
dba.stackexchange.com/a/347720/32281
loading . . .
Why didn't the transaction fail?
I used SSMS to add a composite primary key to a table with 64 million rows. Because the table was so large, I used the change script generated by SSMS. One of the PK fields (REVENUE_CODE) originally
https://dba.stackexchange.com/a/347720/32281
about 1 month ago
0
0
0
Recently answered:
dba.stackexchange.com/a/347708/32281
loading . . .
Is it better to add conditional logic to a heavily used stored procedure or create a separate one for a new use case?
We have a core stored procedure that's a critical part of our system and gets called thousands of times every hour to handle important operations. Now, there's a new application being introduced that
https://dba.stackexchange.com/a/347708/32281
about 1 month ago
0
2
1
Learn T-SQL With Erik: What Does Read Committed Guarantee?
https://erikdarling.com/learn-t-sql-with-erik-what-does-read-committed-guarantee/
about 1 month ago
2
3
0
You know, for kids.
about 1 month ago
0
2
0
SQL Server Performance Office Hours Episode 28
https://erikdarling.com/sql-server-performance-office-hours-episode-28/
about 1 month ago
0
0
0
😭😭😭😭😭😭
about 1 month ago
0
7
0
if this gets 20 upvotes
@erinstellato.bsky.social
will give me an azure data studio t-shirt:
developercommunity.visualstudio.com/t/Add-option...
loading . . .
Developer Community
Developer Community
https://developercommunity.visualstudio.com/t/Add-option-to-keep-actual-execution-plan/10952667
about 1 month ago
1
1
0
back to school release of my sql server performance troubleshooting stored procedures:
github.com/erikdarlingd...
loading . . .
Release Back to School · erikdarlingdata/DarlingData
What's Changed Update sp_HumanEventsBlockViewer.sql by @erikdarlingdata in #622 Dev by @erikdarlingdata in #626 Fix Incorrect syntax near NULL when using @include_query_hash_totals = 1 by @Kysluss...
https://github.com/erikdarlingdata/DarlingData/releases/tag/Updates_20250901
about 1 month ago
0
0
1
Learn T-SQL With Erik: Optimistic Isolation Levels Don't Allow Dirty Reads
https://erikdarling.com/learn-t-sql-with-erik-optimistic-isolation-levels-dont-allow-dirty-reads/
about 1 month ago
0
0
0
Nine quintillion, two hundred twenty-three quadrillion, three hundred seventy-two trillion, thirty-six billion, eight hundred fifty-four million, seven hundred seventy-five thousand, eight hundred and seven.
about 1 month ago
3
0
0
Learn T-SQL With Erik: Writing Bad Data With NOLOCK Hints
https://erikdarling.com/learn-t-sql-with-erik-writing-bad-data-with-nolock-hints/
about 1 month ago
0
0
0
Learn T-SQL With Erik: Unfortunate Deadlocks Under Read Committed Locking
https://erikdarling.com/learn-t-sql-with-erik-unfortunate-deadlocks-under-read-committed-locking/
about 2 months ago
0
1
0
Learn T-SQL With Erik: Lock Compatibility
https://erikdarling.com/learn-t-sql-with-erik-lock-compatibility/
about 2 months ago
0
0
0
SQL Server Performance Office Hours Episode 27
https://erikdarling.com/sql-server-performance-office-hours-episode-27/
about 2 months ago
0
1
0
time is a flat circle.
about 2 months ago
1
2
0
Learn T-SQL With Erik: Serializable Is Not A Snapshot
https://erikdarling.com/learn-t-sql-with-erik-serializable-is-not-a-snapshot/
about 2 months ago
0
3
0
Learn T-SQL With Erik: Transactions and Blocking and Confusion
https://erikdarling.com/learn-t-sql-with-erik-transactions-and-blocking-and-confusion/
about 2 months ago
0
0
0
Learn T-SQL With Erik: Row Versioning vs Locking Isolation Levels
https://erikdarling.com/learn-t-sql-with-erik-row-versioning-vs-locking-isolation-levels/
about 2 months ago
0
1
0
Load more
feeds!
log in