SQL Server CXPacket Wait Type
SQL Server CXPACKET wait types mean there are queries running in parallel on the SQL Server instance and that they may be taking longer than desired to complete.
Read More
SQL Server CXPACKET wait types mean there are queries running in parallel on the SQL Server instance and that they may be taking longer than desired to complete.
Read More
DBCC LOG lets you view the commands in the Transaction Log file and can provide essential information about changes to data in the SQL Server database.
Read More
OLEDB wait types in SQL Server indicate that a query is waiting on something outside of the SQL instance. Tuning the query will involve tuning what is being accessed.
Read More
Duplicate indexes in SQL Server can create unneeded overhead. Learn how exact duplicate indexes affect performance.
Read More
SQL Server table partitioning is generally suggested on a natural key. Learn how to implement it when there are child tables.
Read More
Learn about query performance and some SQL Server benchmarking comparisons of the primary key and the clustered index.
Read More
Some SQL Server experts advocate letting an identity column define the primary key for large tables. Here we examine the pros and cons as well as the syntax for breaking apart the primary key and the clustered index.
Read More
SQL Server Index Hints are a great tool for understanding index use, and identifying missing indexes. Learn why caution is advised for these hints.
Read More
Learn about benefits of SQL Server table compression, including row and page compression, with performance benchmarks in terms of CPU utilization.
Read More
This article provides detailed information on Foreign Keys in SQL Server. Get a free Stored Procedure to find Foreign Keys in a child table.
Read More
Foreign keys have a bad reputation, but here you can learn how they can benefit and even improve query performance.
Read More
The performance impact of database locks can be substantial. Learn best practices for detecting and resolving these blocking scenarios quickly.
Read More