For developers working with SQL Server, few performance tuning techniques are as essential--or as frequently misunderstood--as indexing. Done right, indexing can drastically improve application ...
I'm currently working on a particular table that is about 7 million records. Size on disk is about 2GB. It so happens that the way this is indexed, The size of the index is about double the size of ...