SQL Server 2005 table partitioning provides many improvements in terms of manageability and availability. This is an enhancement on taking the performance advantage on the aspects of manageability by allowing improvements to metadata only switch-in and
Read More...
I'm great fan of Kimberly (aka 'SQL Queen') on her detailed explanation on Concurrency and performance which is a hardcore topic to go through for every DBA. I have watching closely about the debate on Clustered Indecx on SQLSkills(Kimberley's) website
Read More...