SQL Server with Mr. Denny:

Query tuning


March 12, 2014  5:00 PM

Learn Before You Plan



Posted by: Denny Cherry
Data Normalization, Database Administration, Database Design, Query tuning, SQL, SQL Server, SQL Server stored procedures, T/SQL, Tables

Walking into a new shop every couple of weeks has its challenges. What sort of problems are they going to throw at me. Recently I had the...

July 17, 2013  7:00 AM

Nolock and your financial application



Posted by: Denny Cherry
Index Performance, Indexing, Nonclustered Index, Query tuning, SQL Server

The NOLOCK indexing hint gets used way, way to frequently.  The place that I hate seeing it the most is in financial applications, where...


February 6, 2012  2:00 PM

Stop putting it off, it’s time to sign up for SQL Pre-Cons



Posted by: Denny Cherry
In Person Events, Performance, Query tuning, SQL Server, Tech Ed, Tech Ed 2012, Tech Ed Europe, Tech Ed North America

If you are headed to Microsoft's Tech Ed North America or Tech Ed Europe you should really look at signing up for a SQL Server Pre-Con.  The pre-cons are full day sessions focusing on a specific topic, led by an industry expert.  In the case of the SQL Server pre-con "Microsoft SQL Server...


November 17, 2008  8:00 AM

I’ll be speaking at the Inland Empire .Net User Group (reminder)



Posted by: Denny Cherry
In Person Events, Query tuning, Resource Governor

The nice folks at the Inland Empire .NET User Group have invited me to come and speak to them.  This is a great speaking opportunity for me as they are about 20 minutes from my house. I won't be speaking there until...


October 13, 2008  11:01 AM

Why is my SELECT COUNT(*) running so slow?



Posted by: Denny Cherry
Query tuning, SQL

Take a look at the execution plan for your query. You'll notice that the query is doing an Index Scan (or a table scan), not an Index Seek which is why the SELECT COUNT(*) takes so long. The reason for this is that the COUNT(*) function needs to look at every record in the table. As a workaround...


July 21, 2008  11:00 AM

A better way to index text data



Posted by: Denny Cherry
Index Performance, Query tuning, SELECT statement, T/SQL, Tables, Uni-code

Indexing text data (varchar, nvarchar, char, etc) is a good way to make it faster to find the data you are looking for.  However these indexes can end up being very hard on the disks behind the index, as well as the memory of the server.  This is because of the large amount of data being put in...


July 14, 2008  11:00 AM

Using batching to do large operations without filling the transaction log



Posted by: Denny Cherry
DELETE statement, Query tuning, SQL, Tables

Deleting large amounts of data from a table is usually an important task, but if you don't have a maintenance window to work within then you can end up causing locking and blocking against the other processes which are accessing the database.  Not to mention you will cause a very large amount of...


May 5, 2008  9:00 AM

I’ll be speaking at the Inland Empire .Net User Group



Posted by: Denny Cherry
In Person Events, Query tuning, Resource Governor

The nice folks at the Inland Empire .NET User Group have invited me to come and speak to them.  This is a great speaking opportunity for me as they are about 20 minutes from my house. I won't be speaking there until...


May 1, 2008  9:00 AM

Checking the cached execution plans



Posted by: Denny Cherry
Cache, Execution Plan, Query tuning, SQL Server 2005, sys.dm_exec_cached_plans, sys.dm_exec_plan_attributes, sys.dm_exec_query_plan, sys.dm_exec_requests

As we all know SQL Server, will for good or bad, cache execution plans.  Up until now it's been very tough to see the cached execution plans.  You pretty much had to grab the query or procedure (with the parameters) and run it with Query Analyzer and have it return the execution plan.  The only...


April 7, 2008  11:00 AM

SQL Server 2008 changes the way that CONVERT/CAST works



Posted by: Denny Cherry
Query tuning, SQL, SQL Server 2008

Normally when running a query against a table and using a CAST or CONVERT function against a datetime field any index is made useless.  In SQL Server 2008 this problem is fixed.  Microsoft has come up with a way for SELECT statements which use CAST or CONVERT against a column of the datetime...


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: