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,265 reads
Blog Posts
Free eBook: “Protecting SQL Server Data”
SQL Server security expert, John Magnabosco, has just authored the new book, Protecting SQL Server Data, the first book of...
2009-09-22
718 reads
Gila Monster on Estimated vs. Actual Row Counts
I don’t generally do lots of blog aggregation and cross post linking & stuff. It’s just not something I’m that into....
2009-09-22
1,288 reads
New Cumulative Updates For SQL Server 2008
Yesterday, Microsoft released SQL Server 2008 SP1 CU4, which is Build 2734, and SQL Server 2008 RTM CU7, which is...
2009-09-22
645 reads
PASS Book List
Since the beginning of the year I’ve been trying to include a SQL related book in the bi-weekly Connector. Basically...
2009-09-22
550 reads
PASS Connector Editorial for September 23, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-22
561 reads
Searching for Data in Images
I tried out Bing’s new visual search after seeing a few people note it on Twitter. I was a little...
2009-09-22
1,065 reads
September OPASS Meeting Recap
OPASS met last Tuesday, September 14th, with a mini (15 minute) presentation by Todd Holmes on Backup Basics and Jorge...
2009-09-22
435 reads
Built In Alerts
The more I think about this, the more I think it should be built into SQL Server as a default....
2009-09-21
934 reads
Free eBook: “Protecting SQL Server Data”
SQL Server security expert, John Magnabosco, has just authored the new book, Protecting SQL Server Data, the first book of...
2009-09-21
1,246 reads
Blogs
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers