Browse by Tags

Site sponsored by:

The gold standard of SQL Server performance monitoring & diagnostics

RSS Feeds

clustered index (RSS)

How to make join performant?

I have 3 tables Library , Book and Library_Book which is a many-to-many join table containing primary keys of Library and Book tables as the only 2 columns. Both these columns form a composite primary key for the join table Library_Book. LibraryId is of type GUID and BookId is of type int. The Library...

Posted to SQL Server 2008 Questions (Forum) by Drake on 11-06-2008
Default Sort Order for Query With No Sort Specified

I have two databases, each having the same table (the table is the same structurally--tables, indexes, constraints, etc.--but could have different data). One particular set of data is exactly the same. When I query that set of data, using a query with no sort parameters, the data is returned in a different...

Posted to General DBA Questions (Forum) by SQLDBA1976 on 10-29-2008
FIX: Error message after you run the DBCC DBREINDEX Transact-SQL statement on a table that does not have a unique clustered index on a SQL Server 2005-based computer: "Msg 2511"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New FIX: Error message after you run the DBCC DBREINDEX Transact-SQL statement...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 07-03-2008
Re: Creating Identity Column After Clustered Index is Changed

Thank you all for your responses. Adriaan - I have tried this with no luck. The id column values are set in an order I am not expecting. There seem to be "chunks" of correct rows grouped together, but also "chunks" of completely misplaced rows. Will the rows by physically sorted by...

Posted to General DBA Questions (Forum) by SpeedyZ on 05-15-2008
Creating Identity Column After Clustered Index is Changed

Hello all, I have an existing table with a 3-column clustered PK. I want to create an identity column where the values are in a specific sequence other than the current 3-column clustered PK. I tried changing the clustered PK to a nonclustered PK. Then I created a new index that is clustered in the sequence...

Posted to General DBA Questions (Forum) by SpeedyZ on 05-14-2008
TSQL to get clustered index information in SQL Server 2005

Recently within a supportal case with CSS we have been given the following TSQL to get information on indexes, where I have modified a bit to get 'Clustered' index information alone that was helpful to see which tables lack of clustered index alone. declare @tablename sysname ; Set @tablename...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 03-10-2008
Find Indexes and their size

Hi Can anyone tell me how can I find how many indexes I have in my database and what's their size? I am using SQL Server 2000 (Ent Edition). Thanks

Posted to General DBA Questions (Forum) by tariq745 on 10-10-2007
Re: Difference between clustered index and non clustered index

Please remember to check Books On Line and forums search before posting your query, here are some additional referrence http://www.sql-server-performance.com/articles/per/index_data_structures_p1.aspx http://www.sql-server-performance.com/articles/per/index_not_equal_p1.aspx http://www.mssqlcity.com...

Posted to SQL Server 2008 Questions (Forum) by ghemant on 10-04-2007
Re: Update clustered index value?

This is a recommendation, not a requirement. Here is the main reason for the recommendation. If the table has any non-clustered indexes on it, then everytime the clustered index is changed, then each of the non-clustered indexes have to also be updated. This creates additional IO. If you can select a...

Posted to General DBA Questions (Forum) by bradmcgehee on 09-24-2007