SQL Server with Mr. Denny:

Clustered Index


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

June 5, 2013  2:00 PM

What does the RCSI overhead mean?

Posted by: Denny Cherry
AlwaysOn, Availability Groups, Clustered Index, Index, Indexing, Nonclustered Index, SQL Server, Tables

Earlier I posted a blog post which talked about the fact that when you turn on readable secondary replicas there are an

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

March 26, 2009  3:00 AM

So really, how many clustered indexes can I create on a table?

Posted by: Denny Cherry
Clustered Index, Index

This used to be a very easy question to answer as the answer was 1. However these days, with some creativity you can get some extra ones.

Bookmark and Share     0 Comments     RSS Feed     Email a friend

February 2, 2009  1:31 PM

Back To Basics: Clustered vs NonClustered Indexes; what’s the difference?

Posted by: Denny Cherry
Back To Basics, Clustered Index, Index, Nonclustered Index

SQL Server has two basics kinds of indexes. They are clustered and nonclustered indexes. There are some fundamental differences to the two which are key to understanding before you can master index tuning.


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: