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
The row cache lock wait event is associated with a specific enqueue type on a data dictionary row. Learn why this happens and what you can do to tune for it.
Read More
Waits on enq: TM – contention in Oracle indicate there are unindexed foreign key constraints. Learn more about how foreign key constraints relate to this wait and how to tune for it.
Read More
The error ORA-06502 PL/SQL can be addressed by modifying the data, how it’s declared or the operations on it. Learn more.
Read More
The file open wait event signals problems outside the database, such as performance issues in the database server. Learn how to assess and fix these issues.
Read More
When a database isn’t properly configured or application logic stresses normal processing, you may have issues with the RO enqueue wait event. Learn more.
Read More
Learn how Oracle determines the best index access path for finding rows in a table, and how this may impact performance.
Read More