SQL Server fn_dblog() Function Details and Example
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 MoreMost Popular
SQL Server OLEDB Wait Type
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 MoreHow Duplicate Indexes Affect SQL Server Performance
Duplicate indexes in SQL Server can create unneeded overhead. Learn how exact duplicate indexes affect performance.
Read MoreSQL 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 More