Including a primary key in a nonclustered index in SQL Server 2005
The query optimizer for SQL Server 2005 is suggesting that we include a primary key as part of a nonclustered index. Is it OK to include that to increase SQL performance?
View Answer
| Jul 2 2008 5:36 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Primary keys, Index
SQL Server error message ‘Could not find the index entry for RID ‘1628000000a412030044160000869a0000040000′ in the database
I'm getting the error 'Could not find the index entry for RID '1628000000a412030044160000869a0000040000' in the database. The table is a very big table and lots of transactions are happening every minute. Please let me know what would be the possible cause and solution for this problem.
View Answer
| May 7 2008 4:21 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, Index, SQL Server errors
Filegroup in SQL Server 2005
I have very large tables (5,000,000 records each year) which are frequently joined to each other, should I put each of them on a different filegroup? what about their indexes which are used in join conditions?
View Answer
| Jan 1 2008 4:53 AM GMT
| asked by
Gerayeli
Filegroup, Index, SQL Server 2005
