SQLMidlands & SQLLunch
Many thanks to all those that turned out to see my presentation on Thursday (16th of Feb) of “Cursors are...
2012-02-18
762 reads
Dave Ballantynes blog
[BUG] Inserts to tables with an index view can fail
Unfortunately some of the more troubling bugs can be very hard to reproduce succinctly. Here is one that has been...
2012-01-06
1,382 reads
Book review - SQL Server Secret Diary (Know the unknown secrets of SQL Server)
Like a lot of people within the SQL community, I can never read enough on the subject. Books, whitepapers, academic...
2011-12-31
2,327 reads
Extended Events - inaccurate_cardinality_estimate
Extended events have been a bit of a personal “Elephant in the room” for me. I know they are there...
2011-12-06
2,737 reads
MythBusting–“Table variables have no statistics”
Ok, as myths go, its a pretty weak one. In fact, it is true, this whitepaper explicitly states that. But...
2011-12-02
3,077 reads
Execution plan warnings–The final chapter
In my previous posts (here and here), I showed examples of some of the execution plan warnings that have been...
2011-11-29
1,858 reads
Blogging from 37,000ft
Im currently on my way to Sql Rally nordic and looking forward to a few days of full on SQL...
2011-11-06
636 reads
Execution plan warnings–All that glitters is not gold
In a previous post, I showed you the new execution plan warnings related to implicit and explicit warnings. Pretty much...
2011-11-06
847 reads
More Denali Execution Plan Warning Goodies
In my last blog, I showed how the execution plan in denali has been enhanced by 2 new warnings ,conversion...
2011-10-19
796 reads
Implicit Conversions warning
After adding an index, ensuring that an index is actually used is probably the biggest win you will get in...
2011-10-17
1,264 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers