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 More
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 More
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 More
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 More
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 More
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
Cache fusion reads occur when a user on one Oracle system queries a block and then a user on another system queries the same block. Learn how to identify causes of this.
Read More
Get a quick overview of the Oracle Exadata Storage Expansion Rack added in July, 2011, especially useful for storing petabytes of information.
Read More
Oracle hybrid columnar compression can make operations faster because the query runs without decompression. Learn why.
Read More
Oracle has two very important parameters to use to test major features of Exadata: CELL_OFFLOAD_PROCESSING and _KCFIS_STORAGEIDX_DISABLED. Learn more.
Read More
The Oracle memory command ipcs command displays the size of each shared memory segment for the SGA. Learn more.
Read More
If Oracle mutex or latch waits are high but shared and Java pool freespace is also high, it could indicate that sessions are spending time scanning the unnecessarily large list of free shared pool chunks. Learn more.
Read More