Two Important ‘ONLINE’ Column-Level Operations in SQL Server

Today Kendra talks about two of the online options used when working with indexes.

Updating Statistics

Rebuild vs Reorganize

More Computed Column Indexes

The Basics of INCLUDE

Learn how the INCLUDE phrase of an index can change the performance of a query.

Indexing A Numeric Computed Column

Indexing Computed Column

“Included columns” for non-clustered indexes explained

Microsoft SQL Server has the feature to use “Included columns” for the creation of non-clustered indexes. This feature and its benefits and disadvantages will be explained in the following article. Included columns can be used to create a covering indexes without including all the data into the key columns. This covering index has the advantage […]

Reindexing a database

How much will it cost or save to rebuild that index? (SQL Oolie)

What's the true and permanent cost of lowering the Fill Factor of an index in SQL Server? It's a lot more than many people think. 9 year SQL Server MVP veteran, Jeff Moden, demonstrates how to calculate the extra space that will be used by lowering the Fill Factor and saved by increasing it.