Other News

Editorials

Index Defragmentation

New SelecTViews Show Meredith Ryan Smith on the show today, plus the latest news for the database world. Also, what do fingers have to do with injection and SQL Server? Find out on the show… [Watch the Show] Also: Watch last week’s show here Index Defragmentation Indexes are one of the key components impacting the performance of a relational database. […]

Uncategorized

Index Maintenance

Index Maintenance Yesterday I talked about SQL Server Indexes and how important it is to keep them from becoming fragmented in your database. Defragmenting clustered indexes cause all the data to be grouped contiguously on the disk. Defragmenting non-clustered indexes cause those indexes to also be located contiguously on the disk. So, in order to defragment both the data and […]