Optional Parameters Causing Index Scans
Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even...
2014-04-15
739 reads
Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even...
2014-04-15
739 reads
Many people see CXPACKET at the top of their waits and start trying to fix it. I know this topic’s...
2014-03-11
1,620 reads
My company cut the training budget this year, and it’s not that uncommon for that to happen anymore. However, I’m...
2014-03-04
1,087 reads
DBAs are the gatekeepers, but if we make it an unpleasant process then people will find a way around the...
2014-02-13
493 reads
Chances are you have extra information in the buffer pool for a bad query and it’s dragging down your PLE,...
2014-01-08
2,044 reads
First, lets understand what the types of indexes are. If you take a reference book, you have the two types...
2013-11-20
1,687 reads
I started a new job a month ago, but didn’t want to just figure things out as they came to...
2013-10-08
847 reads
Fires, SAN failures, tornados, and car accidents all came up today, yet it was a very good day at work. ...
2013-10-04 (first published: 2013-09-30)
2,174 reads
Here’s my full presentation for SQL Saturday #250 in Pittsburgh this past Saturday along with some notes on what I...
2013-09-20
953 reads
Trending database and table sizes helps give you an idea of what to expect, and, sometimes, points out problems and...
2013-09-11 (first published: 2013-09-10)
4,100 reads
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Comments posted to this topic are about the item Learn From History
Comments posted to this topic are about the item The SQL Server MCP Server
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers