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,577 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,428 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
983 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,427 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
11 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
14 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,799 reads
Poor man’s SQL monitor
Here is quick tip that can help you track SQL Job and Alert notifications in Microsoft Outlook. Many of you...
2011-06-20
933 reads
Non use of persisted data – Part deux
In my last blog I showed how persisted data may not be used if you have used the base data...
2011-06-20
537 reads
Difference between Checkpoint and LazyWriter
Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...
2011-06-20
1,039 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers