January 23, 2013 9:00 AM
Posted by: Denny Cherry
CREATE INDEX,
Database,
Execution Plans,
Indexing,
SELECT statement,
SQL Server,
T/SQL,
TablesAll to often when talking to developers they put the WITH (NOLOCK) table hint in place to speed up queries without understanding what the table hint does. I've even run across companies that have policies in place that every select statement must have the WITH (NOLOCK) table hint.
The WITH...
April 25, 2011 2:00 PM
Posted by: Denny Cherry
Index,
Index Scan,
Index Seek,
SQL Server,
StorageThere are a few things which you will want to look at. First make sure that you have enough RAM for the database to use. Without enough RAM in the SQL Server you’ll begin putting extra load on the disks because the same data is being pulled into the buffer cache from the disk over and...
August 5, 2010 3:40 AM
Posted by: Denny Cherry
DACPAC,
Execution Plans,
In Person Events,
OC SQL User GroupTomorrow I'll be speaking at the Orange County SQL Server Users Group. I'll be presenting two sessions at the meeting. One will be "
September 17, 2009 11:00 AM
Posted by: Denny Cherry
Index Performance,
Index Scan,
Index Seek,
Indexing,
T/SQLThe datetime data type can be one of the hardest to work with when it comes to index optimization. Most queries that use a datetime data type for filtering (part of the where clause) only want to match the date portion of the value. Most people handle this via a convert function around the date...
August 4, 2009 9:11 PM
Posted by: Denny Cherry
Execution Plans,
In Person Events,
Indexing,
SoCal Code Camp,
StorageThe SoCal Code Camp website has been reset and is ready for the next Code Camp. This code camp will be the second camp camp that we are doing up in LA. This time it is November 21st and 22nd and is being hosted...
January 22, 2009 3:00 PM
Posted by: Denny Cherry
Code Snippet,
Plan Guides,
SQL Server 2005,
SQL Server 2008,
sys.plan_guidesSo you've saved a plan guide into your SQL server, and you want to look at the plan. You can Query the sys.plan_guides catalog view and see the data exactly as you entered it, which works fine if you just have a hint in there. But if you have a full XML query plan that isn't going to do you a...
November 24, 2008 1:00 PM
Posted by: Denny Cherry
Back To Basics,
Index Performance,
Index Scan,
Index Seek,
SQL Server,
Table ScanThere are a few basic operations which SQL will perform when looking for the data that you need. Here they are listed in the order of worst to best.
- Table Scan
- Clustered Index Scan
- Index Scan
- Clustered Index Seek
- Index Seek
The...
