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