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
726 reads
Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even...
2014-04-15
726 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,610 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,076 reads
DBAs are the gatekeepers, but if we make it an unpleasant process then people will find a way around the...
2014-02-13
471 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
1,981 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,674 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
834 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,158 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
945 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,082 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;