Estimated rows, actual rows and execution count
It’s often said that a major discrepancy between estimated and actual row counts in a query’s execution plan is a...
2009-09-22
2,188 reads
SQL In The Wild
Multiple Execution Paths
It’s not uncommon to find stored procedures that have multiple IF statements controlling the flow of execution within the procedure....
2009-09-15
741 reads
Thoughts on the 24 hours of PASS
From all indications, the first 24 hours of PASS was a resounding success. Hundreds of attendees for each session, minimal...
2009-09-03
361 reads
Backing up to NUL vs Backup with Truncate only
Or “It’s 10pm, do you know where your log records are?”
Something that I’ve started to see recently is the idea...
2009-08-31
2,206 reads
Corruption in sys.dependencies
The second type of corruption I want to look at is that of missing references in sys.sql_dependencies. This typically appears...
2009-08-26
424 reads
Stats blob corruptions
There have been a couple odd types of corruption that I’ve been seeing on the forums. I want to take...
2009-08-24
350 reads
Blogs
Why use XACT_ABORT?
This came up one day at my work when a developer was using it....
Using AI for Data Conversion
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
Advice I Like: Tipping
By Steve Jones
When in doubt, overtip – from Excellent Advice for Living This is close to...
Forums
Two Events, Two Worlds: A Week in the Life of a Technologist
Comments posted to this topic are about the item Two Events, Two Worlds: A...
Installing SQL Instance on a Clustered Virtual Disk
Hi Everyone, I have a question, I am trying to setup a Lab environment...
Upgrades to SQL Server 2022
Comments posted to this topic are about the item Upgrades to SQL Server 2022
Question of the Day
Upgrades to SQL Server 2022
What is the earliest version from which you can directly upgrade to SQL Server 2022?
See possible answers