SQL Server sp_addmessage System Stored Procedure
Learn how to use the sp_addmessage system stored procedure to add error messages to SQL Server that can be referenced in code.
Read MoreMost Popular
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 MoreOracle Log File Switch Completion
Log file switch completion is the time a session waits for recording and archiving changes to data through redo log generation. Learn about performance hits.
Read MoreOracle Buffer Busy Wait Event
Buffer busy wait occurs when a session tries to access a block in the buffer cache but the buffer is busy. Learn about performance impact.
Read MoreOracle Control File Read & Write Wait Events
The three control file read and write wait events all contribute to the time Oracle takes to keep the control file current. Learn more.
Read MoreSQL 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 MoreSQL 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 More