A Tale of Two Sandy Bridge Laptops
I recently bought a new teaching and presentation laptop, which is a Toshiba Portege R835-P55X, which I found at the...
2011-06-21
952 reads
Rebuild all the Indexes of a SQL Database in one go
Introduction
In my last post, I had explained what could be the best value of Fill Factor for the indexes in...
2011-06-20
5,425 reads
Miss TechEd 2011? No problem, all videos are online
While nothing beats going to a conference, the next best thing is to watch the recorded sessions. Fortunately, Microsoft has...
2011-06-20
827 reads
T-SQL Formatting Workaround (Word Macro)
Hi all! I’m on vacation this week, but I’ve cleverly scheduled this blog post so you won’t miss me too...
2011-06-20
1,578 reads
Double Hop of Doom
I recently had to battle through THE DOUBLE HOP OF DOOOOOMMM!! It was a very rewarding experience and I think...
2011-06-20
4,431 reads
Indexes Aren’t Always the Answer
There’s a tendency to think all problems can be solved with an index or two (or partitions, or other performance...
2011-06-20
985 reads
Evaluating Sessions You Attend
I have seen more than a few posts about feedback that speakers get from sessions in the last couple months....
2011-06-20
1,429 reads
Code Snippet for an SSIS DataFlow Performance Wiretap
I was recently tweaking a few Data Flows, and settled on a very small, but very useful script to help record execution timing inside the flow.
Decomposition Is Time...
2011-06-20
15 reads
Code Snippet for an SSIS DataFlow Performance Wiretap
I was recently tweaking a few Data Flows, and settled on a very small, but very useful script to help record execution timing inside the flow.
Decomposition Is Time...
2011-06-20
15 reads
Make the Optimizer Work Harder
One of my favorite indicators for whether or not you have a good execution plan is when you see the...
2011-06-20
2,803 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