Getting the CREATE INDEX statement is as simple as adding in one more column, shown below, to this query which then generates the T-SQL CREATE INDEX statement. 'USE [' + DB_NAME(c.database_id) + ']; ...

SQL Server 2016 partially compensates for this limitation by allowing one of those eight indexes to be a Columnstore Index. But there are rules that you need to follow: ...

Non-clustered Columnstore Indexes (NCC Index) are also getting some enhancements in SQL Server 2016. The most notable of these enhancements is the ability to be updated.

Microsoft’s Bradley Ball dives into the inner workings of SQL Server indexing to help developers and DBAs speak the same ...

Indexing is a critical part of database optimization. Indexing can dramatically increase query speed. However, DBAs still struggle with finding optimal indexes or optimal SQL plans. DBTA held a ...

SQL Server 2012’s ColumnStore Index stores data for columns you designate and then joins those database columns to give you a read-only, column-based index into the data (traditional indexes are ...

I wanted to get some suggestions for scheduled maintenace on a SQL Server 2000 box that is hosting a relatively small database (<=13GB). I already have a weekly integrity check that reorganizes ...