Welcome Guest — Sign Up or Login

Articles, code, videos and a community of DBA and database developer experts to help you find and fix database performance issues faster.

 Editor’s Picks

Article

Solving Oracle enq: TM Contention Wait Events

Waits on enq: TM - contention in Oracle indicate there are unindexed foreign key constraints. In this article, I examine how foreign key...

by Dean Richards, Senior DBA, Confio Software | @confiodean

Article

SQL Server Primary Key vs. Clustered Index, Part 1

by Mike Byrd, ByrdNest Consulting, Senior SQL Server engineer, developer, instructor, and speaker

 

Video

Oracle RAC on VMware: Insights from a Confio...

Insights on performance tuning for Oracle RAC on VMware from...

Article

Oracle Wait Event Explained: Direct Path Read Temp

When a session reads buffers from disk directly into the PGA, the wait is on direct path read temp. This is closely related to the direct path read...

by James Koopmann, Consultant, Pinehorse, Inc. James is a  20+ year veteran of database administration and highly sought after consultant, speaker,  writer and blogger.

 Highest Rated

Article

SP_AddMessage System Stored Procedure

The sp_addmessage system stored procedure lets you add error messages to SQL Server that can be referenced in code. This is helpful for standardized error messages that will be used throughout your application, especially if they need to be able to support multiple languages, but not so much for ad-hoc error messages.
0 comments
|

Article

Extended Optimizer Statistics in Oracle 11g Improve Performance

Better execution plans for faster running SQL is a common goal. Unfortunately good index choices may often be missed in an execution plan. Learn how extended optimizer statistics in Oracle 11g can lead to better execution plans and improved performance.

by James Koopmann, Consultant, Pinehorse, Inc. James is a  20+ year veteran of database administration and highly sought after consultant, speaker,  writer and blogger.

Tags: 
0 comments
|

Article

SQL Server Clustering Alternative Options

Two popular SQL Server clustering options include active/active clustering and multi-node clustering. Additionally, it is available to cluster multiple instances of SQL Server on the same server. This article discusses these options in detail.
0 comments
|

Article

Why Ignite Uses SQL Server Trace Flag 2861 and Zero Cost Plans

This article explores the reasons why Confio Ignite uses the SQL Server trace flag 2681 and the pros and cons of disabling this flag.

by , Technical Evangelist and Senior DBA, Confio Software| Microsoft MVP | @SQLRockStar

0 comments
|

Article

The Pivot Operator Is More than Just a Report Option

The release of SQL Server 2005 gave us the PIVOT operator. Let’s review the PIVOT operator syntax and do some benchmarking relative to the "old" way of pivoting prior to SQL Server 2005.

by Mike Byrd, ByrdNest Consulting, Senior SQL Server engineer, developer, instructor, and speaker

 

0 comments
|

Article

SQL Server Concurrency--Dirty Reads

Database concurrency ensures that when multiple operations are occurring at once, the final result is still in agreement — that they concur. The problems described in this three-part article only occur when multiple sessions are occurring at once in your database, including lost updates, dirty reads and non-repeatable reads. 
Tags: 
0 comments
|