SQL Server: Part 2 : All About SQL Server Statistics :Histogram
In the Part 1 about SQL server Statistics, we have discussed about density vector information stored in the the statistics. In...
2013-06-27
16,295 reads
Blog Posts
Visual Studio 2013 preview available
Wow, Visual Studio 2012 is just out of diapers and here comes the next version!
Microsoft officials released the preview of...
2013-06-27
1,622 reads
Checkout SQL Server 2014 CTP1 and Windows 2012 R2 preview up in the cloud
You must be really busy spinning up VMs to test SQL Server 2014 CTP1 and Windows Server 2012 R2 preview.
If...
2013-06-26
1,621 reads
Indexing Fundamentals Presentation
**This Session has been rescheduled for July 10th @ Noon EST (16:00 UTC)** On July 10th 2013 @ Noon EST (16:00 UTC)...
2013-06-26
1,257 reads
Natural Born Killers (The series) – Day 7 Table Variables vs Temp Tables
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-26
2,666 reads
Non-Clustered Indexes on Table Variables in SQL Server 2014
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Earlier today I...
2013-06-26
7,409 reads
Oracle and Microsoft are in the Cloud Together
What an interesting week this has been. On Monday Microsoft and Oracle announced a partnership that rocked the cloud world....
2013-06-26
1,358 reads
PASS Nominating Committee for 2013 Elections Announced
I was pleased to see the email this morning announcing that community volunteers Erin Stellato, Ryan Adams, and Tamera Clark...
2013-06-26
1,252 reads
SQL Server 2014 CTP1 Now Available!
Sweet! SQL Server 2014 CTP1 is now available for download at Microsoft.com! Get it while it is hot, and start...
2013-06-26
748 reads
SQL Server: Identifying Edition Specifc features Used in a Database
I had a situation which forced me to do a feasibility study to move SQL server 2008 enterprise edition environment to standard edition. It is...
2013-06-26
1,693 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers