What is index fragmentation and why should I care about it: Fragmentation exists when indexes have pages in which the logical ordering within the index, based on the key value of the index, does not ...

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 ...

As part of my weekly maintenance routine, I rebuild the indexes on several of my larger high-activity tables. I'd like to try and get an idea of just how long the rebuilds take. The rebuilds are ...

Log files can be damaged due to malware or virus attacks on the system hosting the SQL server; If the SQL Server account permissions and configuration are modified incorrectly, it can impact the log ...

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 ...

Microsoft's SQL Server has a handy command that rebuilds all indexes in a table. Oracle users typically rebuild each index in a table individually. Microsoft SQL Server ...