SQL Server with Mr. Denny:

Execution Plans


February 12, 2014  2:00 PM

How Much Is That Query Costing?



Posted by: Denny Cherry
Database Administration, Execution Plans, Indexing, SQL, SQL Server

When we think about the cost of the query we typically think about the cost which SQL Server assigns to execute the query. However when we look at performance tuning queries there is another cost that we need to think about. This additional cost is the cost to the company while the query is...

December 3, 2013  6:15 PM

Upcoming SQL Saturday Precon in Albuquerque



Posted by: Denny Cherry
Clustered Index, Database, Database Administration, Database Design, Execution Plans, Indexing, Nonclustered Index, Recovery Model, SQL PASS, SQL Saturday, SQL Saturday 271, SQL Server

I'm very pleased to announce that I will be presenting a precon at the Albuquerque SQL Saturday at SQL Saturday 271 on...


August 7, 2013  2:00 PM

Back To Basics: Statistics



Posted by: Denny Cherry
Back To Basics, Index Performance, Index Scan, Index Seek, Indexing, SQL Server, Statistics

Statistics are magical little objects within the database engine that have the ability to make your queries run fast or painfully slow.  The...


June 26, 2013  2:00 PM

Performance Tuning a Spotlight for SQL Server Query



Posted by: Denny Cherry
Database Administration, Execution Plans, Indexing, Nonclustered Index, Quest Software, SoSSE, SQL Server, Table Scan

The other day I was looking at parallel query plans on a customers system and I noticed that the bulk of the parallel queries on the...


May 28, 2013  4:27 PM

Extra Bytes Per Row With AlwaysOn Availability Groups



Posted by: Denny Cherry
AlwaysOn, Database Administration, Execution Plans, Index, Index Performance, Index Seek, Indexing, SQL Server, SQL Server 2012

One of things to keep in mind with SQL Server 2012 AlwaysOn Availability Groups is that when the availability group has readable secondary replicas any...


January 23, 2013  9:00 AM

NOLOCK is not a turbo button



Posted by: Denny Cherry
CREATE INDEX, Database, Execution Plans, Indexing, SELECT statement, SQL Server, T/SQL, Tables

All 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...


April 25, 2011  2:00 PM

We get many warnings in our SQL error log about I/O requests taking longer than 15 seconds to complete. What do we do in such scenario?



Posted by: Denny Cherry
Index, Index Scan, Index Seek, SQL Server, Storage

There 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

Slide Decks for the OC SQL Users Group



Posted by: Denny Cherry
DACPAC, Execution Plans, In Person Events, OC SQL User Group

Tomorrow I'll be speaking at the Orange County SQL Server Users Group.  I'll be presenting two sessions at the meeting.  One will be "   Bookmark and Share     0 Comments     RSS Feed     Email a friend


September 17, 2009  11:00 AM

Dates can easily be the hardest datatype to work with.



Posted by: Denny Cherry
Index Performance, Index Scan, Index Seek, Indexing, T/SQL

The 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

SoCal Code Camp – LA #2 has been announced



Posted by: Denny Cherry
Execution Plans, In Person Events, Indexing, SoCal Code Camp, Storage

The 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...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: