Hi all,
I just started learning the SQL Server Indexes in SQL Server 2012 Management Studio (SSMS2012). I read some tutorials from the websites of Microsoft MSDN and sqlservercentral. I did 3 sets of basic sql codes of creating NonClusterIndex,
ClusterIndex and UniqueIndex (Microsoft msdn examples) successfully. From the sqlservercentral website, I read an article "Stairway to SQL Server Indexes: Level 1, Introduction to Indexes", written by David Durant (dated: 2011/01/26)
and tried to execute the following code (copied from the article):
-- Indexing Stairway; Level 1 code
USE AdventureWorks
GO
IF db_name() <> 'AdventureWorks' RAISERROR('Database AdventureWorks not found', 22, -1) with log;
GO
--***
--*** Batch 1.
--***
SET statistics io on
SET statistics time on
GO
--***
--*** Ensure that the FullName index does
--*** ...
Go to the complete details ...