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

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

Denny's SQL Secrets. Are Too Many SQL Server Indexes Hurting ... such as stock trading database applications where a few ... if you need the index back you can quickly rebuild the ...

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

Non-clustered index corruption leads to incorrect reading of the SQL database query or multiple read operations on the same value. SQL database in suspect mode: SQL database suspect mode is a frequent ...

SQL Server 2012 includes a lot of new and exciting features. One feature that has caught the imagination of many in the user community is the high-performance feature called Columnstore Indexes.