How do you choose an index type?

Indexes are on-disk structures tied with a table/view that helps reduce I/O. Implementing a good indexing solution can have dramatic performance gains in the database. However, too many indexes will…

Database Files and Filegroups

Managing database files and filegroups appropriately will help with the availability of a database and of course its performance. FilesThere are at least two file types and you can have…