I have recently heard that the upcoming release of SQL Server 2016 will bring about several important enhancements for columnstore indexes. I want to learn more about these changes, so as to leverage them to achieve improved application performance and sc
Understand Memory Grants and Parallelism in SQL Server to optimize performance and manage resource contention effectively.
Learn about the importance and impacts of query plans in SQL Server 2016 and how to setup the Query Store for optimal performance in SQL Server 2016.
Database growth is something DBAs need to watch to make sure storage is not an issue. In this tip we look at how to find average growth rates for your databases.
Index-usage statistics get re-initialized when the SQL Server instance in question gets restarted and, starting with SQL Server 2012, after an index rebuild. This can obscure the true impact of indexes in day-to-day operations and lead to false determinat