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

The most important performance-tuning technique available is having the needed indexes created on the tables to ensure that the SQL Server database engine is able to get the data that it needs to ...

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

SQL Server 2012 then borrowed this columnar processing technique for its own use. As an example of how the new SQL Server could speed performance, Kelly explained how a retail chain could benefit ...

SQL Server 2012 then borrowed this columnar processing technique for its own use. As an example of how the new SQL Server could speed performance, Kelly explained how a retail chain could benefit ...

SQL Server is a robust and mature product and the number of features available to database administrators and developers continues to mount. Do not let fear of upgrading – to a new version or to a new ...

While some resources listed basic SQL Server performance tips for what seemed to be every wait type, most had the following information in common. So, I compiled a list of common wait types and ...

In a previous TechRepublic column about SQL Server 2005, I showed how you can convert some of your iterative queries (cursors) to set-based operations in order to enhance performance. You should ...