Obtaining Information about Oracle Redo Log Files
The Oracle X$KCCCP table contains information about the current redo log file, and the X$KCCLE table contains information about all redo log files. Learn more.
Read MoreMost Popular Databases
Types of Oracle Wait Events
Oracle DBAs frequently classify wait events into four main categories: Foreground, Background, Idle, and Non-Idle events. Learn more.
Read MoreSQL Server Latch and Spinlock Extended Events
Learn which extended events are available for latches and spinlocks, and which you might want to collect.
Read MoreAvoid the SQL Server Halloween Effect When Index Tuning
Although SQL Server protects against the Halloween effect, it’s important to keep in mind when considering an indexing strategy. Learn more.
Read MoreChoose and Configure Hardware for SQL Server Redundancy
Learn about the first steps to take in designing a high-availability solution for your SQL Server data tier to eliminate as many single points of failure as possible at the hardware and configuration level.
Read MoreUses for SQL Server Integration Services (SSIS)
SQL Server Integration Services (SSIS) provides data integration and workflow for extraction, transformation, and loading (ETL) of data from various sources to various destinations. Learn about best uses for SSIS.
Read MoreUnderstanding the SQL Server Columnstore Index
A SQL Server columnstore index is a column-based non-clustered index used to increase query performance for workloads that involve large amounts of data, like data warehouse fact tables. Learn more.
Read MoreUnderstanding SQL Server Indexes
SQL Server indexes can be classified in several ways depending on the way they store data, their internal structure, their purpose, and the way they are defined. Learn more.
Read MoreSQL Server Multiserver Administration: Master and Target Servers
A SQL Server master server (MSX) can send jobs to run on one or more target servers (TSX), but may not also be a target server that receives jobs from another master server. Learn more.
Read MoreUpdating Statistics Fixes Poor SQL Server Query Performance
A possible reason for poor query performance after upgrading to SQL Server 2012 is old statistics that can’t be used by the query optimizer. Learn more.
Read MoreResolving Issues Identified by SQL Server Upgrade Advisor
The SQL Server Upgrade Advisor’s report contains a wealth of information. Learn how how this information appears, what you need to resolve, and when.
Read MorePlanning an Upgrade to SQL Server 2012
A smooth upgrade to SQL Server 2012 requires a good plan with pre-upgrade tasks, upgrade tasks, and post-upgrade tasks. Learn more.
Read More