Column Order in an Index

This short article shows the importance of order of columns in an index.

Clustered Indexes

Creating indexes on computed columns

Moving Indexes with Powershell and SMO

Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.

sp_helpindex2

Retrieve included columns info as well along with other column list

Mid September Free Training from PASS

There's going to be over 30 hours of free online SQL Server training in the upcoming week and you're not going to want to miss out!

Disabling Indexes

Rebuilding Indexes using the SSMS Database Maintenance Wizard

Index fragmentation can cause problems with query performance. Indexes therefore need to be occasionally rebuilt. the Rebuild Index task of the SSMS Database Maintenance Wizard drops and rebuilds every index in a database. It is effective but an off-line activity that is resource-intensive, so it not always the best way of avoiding index fragmentation in a production database. Brad explains..

Discuss content posted by Thanh Ngay Nguyen

Discussions about content posted by Thanh Ngay Nguyen

Tips to Optimize Your SQL Statements - Part 1

Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly.