How Duplicate Indexes Affect SQL Server Performance
Duplicate indexes in SQL Server can create unneeded overhead. Learn how exact duplicate indexes affect performance.
Read MoreMost Popular
SQL Server Primary Key vs Clustered Index, Part 3: Table Partitioning and Partition Key Selection
SQL Server table partitioning is generally suggested on a natural key. Learn how to implement it when there are child tables.
Read MoreSQL Server Primary Key vs. Clustered Index: Query Performance and Benchmarking Analysis
Learn about query performance and some SQL Server benchmarking comparisons of the primary key and the clustered index.
Read MoreSQL Server Primary Key vs. Clustered Index: Part 1
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 MoreSQL Server Index Hints–Caution Advised!
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 MoreSQL Server Index Compression – Why Not?
Learn about benefits of SQL Server table compression, including row and page compression, with performance benchmarks in terms of CPU utilization.
Read MoreSQL Server Foreign Keys: Some Mystery Explained! (Part 2)
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 MoreSQL Server Foreign Keys: Some of the Mystery Explained! (Part 1)
Foreign keys have a bad reputation, but here you can learn how they can benefit and even improve query performance.
Read MoreSQL Server Locks and Blocks
The performance impact of database locks can be substantial. Learn best practices for detecting and resolving these blocking scenarios quickly.
Read MoreOracle Row Cache Lock Wait Event Explained
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 MoreSolving Oracle enq: TM Contention Wait Events
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 MoreORA 06502 Numeric or Value Error
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