SQL Server with Mr. Denny:

Indexing


November 21, 2012  9:00 AM

Fixing a table that has overflowed its primary key



Posted by: Denny Cherry
Clustered Index, Data Types, Database, Database Administration, Database Design, SQL, SQL Server, Stored Procedures, T/SQL, Tables

During TechEd Europe I got a very scary phone call.  A very large table was throwing errors that the value being inserted into the primary key column was overflowing the data type that makes up that column.  In this case the data type in question was INT, so we were trying to stick the number...

June 4, 2012  2:00 PM

VMware vCenter Performance Tuning



Posted by: Denny Cherry
Index Performance, Nonclustered Index, SQL Server, vCenter, VMware

As hopefully everyone that is using VMware's vSphere in either data center knows VMware's vCenter runs off of a Microsoft SQL Server database (by default).  Now as good as they guys at VMware are at building a virtualization platform there database leave a little to be desired.  I've identified a...


December 12, 2011  2:00 PM

Fixing Performance in Vendor Apps



Posted by: Denny Cherry
Indexing, Social Commentary, SQL Server

Lots of people out there manage 3rd party vendor apps.  However as anyone who has managed a vendor app can tell you, you don't really manage the app.  You simply backup the vendor database (assuming that they allow you to backup the database) and call the vendor when there are performance...


November 7, 2011  2:00 PM

Slide Deck From Buena Park .NET User Group



Posted by: Denny Cherry
Development, Indexing, SQL Server

Last week on Wednesday night I had the privilege of presenting a session to the Buena Park .NET User Group.  The session that I gave was "Indexing for the .NET Developer".  The abstract for the session is: "In this session we will be looking at the...


September 19, 2011  7:13 PM

Slide Decks for #sqlsat95



Posted by: Denny Cherry
Clustering, Indexing, SQL Saturday, SQL Saturday 95, SQL Server

This last weekend was SQL Saturday 95, and it was a great event.  I was speaking during 5 sessions.  Three were my own sessions, and two were panels (one panel I did solo as my co-presenter got sick and couldn't make it).  For my three sessions you'll find my slide decks below.


August 3, 2011  4:21 PM

Lookout Dallas, here I come…



Posted by: Denny Cherry
Indexing, SQL Server, Virtualization

I'm pleased to say that I'm one of the great speakers who will be presenting at the Dallas Tech Fest on August 12th and 13th at the


August 1, 2011  2:00 PM

Slide decks from Dallas Tech Fest Sessions



Posted by: Denny Cherry
In Person Events, Indexing, Virtualization

This last Saturday I spoke at Dallas Tech Fest, where I had two great groups in my two sessions.  As promised here are the slide decks for the two sessions which I presented. Index Internals


June 30, 2011  2:00 PM

SQL Excursions and Index Internals #sqlexcursions



Posted by: Denny Cherry
Indexing, SQL Excursions, SQL Server

The fourth session that I'll be giving at SQL Excursions will be on index internals. In this session we'll dig into the internal structures of indexes.  We will explore the...


February 1, 2011  2:00 PM

My SoCal Code Camp slide decks



Posted by: Denny Cherry
Data Encryption, Encryption, In Person Events, Indexing, SoCal Code Camp, SQL Server, SQL Server 11, SQL Server 2012

So this last weekend was the 13th SoCal Code Camp (the 6th at this location).  I presented three different sessions at this code camp.  My slide decks can be downloaded below.   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...


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: