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

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

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

The next version of Microsoft’s relational database management system (RDMS) promises to bring immense performance gains to online transactional processing systems. SQL Server 2014 will come ...

SQL Server 2022: Here’s what you need to know Your email has been sent TIOBE Index: Top 10 Most Popular Programming Languages WWDC: Apple Unveils Unified Design Language and Built-In AI Tools ...

The next version of Microsoft’s relational database management system (RDMS) promises to bring immense performance gains to online transactional processing systems. SQL Server 2014 will come ...

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

When it comes to assigning value to different components in today's IT environment, it would be a serious mistake to underestimate the value of data and databases. Whether you are looking to reduce ...

These cloud-connected features include integration with Azure SQL Database Managed Instance -- the Microsoft-managed, cloud-based deployment of the SQL Server box product.