First introduced in SQL Server 2012, columnstore indexes can give you major performance gains -- provided you have the right workloads. Here's how columnstore indexes work and what types of data ...

Do keep in mind that the sys.dm_db_index_usage_stats dynamic management view is reset to all zeros every time the SQL Server instance is restarted, so don't restart SQL Server then disable ...

This number is often as small as 20 percent -- if SQL Server has to look at more than 20 percent of your rows, SQL Server will decide that it's faster just to look at all of the rows in the table. An ...

SQL Server 2012 has a lot of metadata about columnstore indexes. For example, sys.indexes show column store indexes as type = 6 and type_desc as ‘NONCLUSTERED COLUMNSTORE.’ There also are two new ...

I wanted to get some suggestions for scheduled maintenace on a SQL Server 2000 box that is hosting a relatively small database ...

Due to zero-based counting, indexes 1 and 2 map to the second and third columns in the Player table, which are the handle and the emailAddress.. When the code builds and runs, the output is as follows ...