Sort – Is it Really a Blocking Iterator?
SQL Server has two types of execution plan iterators: Blocking and Non-Blocking.
A non-blocking iterator gets rows in and sends rows...
2014-10-30
1,306 reads
Matan Yungman
Track My Query Utility
Were you ever in a situation where you ran a query, it ran for a long time and you didn’t...
2014-10-06 (first published: 2014-10-01)
7,556 reads
How to Make Sure Your Clients Can Connect to a Multi-Subnet Cluster
When you set up a multi-subnet cluster, whether it’s a Failover Cluster Instance or an Availability Group, you need to...
2014-09-29
955 reads
My SQLBits Session Recordings
Last month, I had the pleasure of presenting two of my favorite sessions at the SQLBits conference in Telford, UK.
A few days...
2014-08-28
1,027 reads
Announcing SQL Server Radio – English Edition!
About a year and a half ago, I approached Guy and asked him if he wanted to start a podcast...
2014-08-14
1,396 reads
The Real Reason You Should Be a Proactive DBA
If you’re reading this, you probably think, like me, that SQL Server is an awesome product. One of the great...
2014-08-11
1,380 reads
Things You Can Find in the Plan Cache at SQLBits
On Saturday, I had the pleasure to present my session, “Things You Can Find in the Plan Cache”, at SQLBits!
Thanks to...
2014-07-19
440 reads
Goodbye Microsoft, Hello New Adventure
About two months ago, after two and a half years, I left Microsoft.
Microsoft is an amazing place to work for. It’s...
2014-07-17
473 reads
Goodbye Microsoft, Hello New Adventure
About two months ago, after 2.5 years, I left Microsoft.
Microsoft is an amazing place to work for. It’s conformable, balanced,...
2014-07-17
554 reads
The 3 Factors That Will Get You a Job You’ll Love
It’s T-SQL Tuesday time, and this month’s host, Boris Hristov (blog|twitter) chose the topic of interviews.
Over the time as a...
2014-05-13
716 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Restore Job fails in Replication
Dear Folks, Restore jobs in my SQL2022 Standard edition replication were failing on a...
visual studio seems to lose "provider" on pkg imports
hi, just to get this part out of the way, if my intended target...
ERD Tools recommendation
Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...
Question of the Day
Vector Datatype Dimensions
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers