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
743 reads
Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even...
2014-04-15
743 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,622 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,090 reads
DBAs are the gatekeepers, but if we make it an unpleasant process then people will find a way around the...
2014-02-13
506 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,051 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,694 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
849 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,179 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
959 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,113 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hi, I have a trigger, that works fine elsewhere but is not working at...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers