Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/

SAinCA, I think this is the code you are referencing from this tip ( http://www.mssqltips.com/tip.asp?tip=1112 ): -- Table - The base table is stored with the -- clustered index, so moving the clustered -- index moves the base table CREATE CLUSTERED INDEX IDX_ProductID ON dbo.OrdersDetail(ProductID)...