This article will discuss the importance of the PLAN_TABLE and how to make sure you are using the correct one. The PLAN_TABLE, shown below, is used to produce SQL Explain Plans. When SQL is submitted to Oracle and processed (details to follow in other articles), an execution plan is created and used to process the […]
Read More
The inventor of the relational model, Dr. Edgar Codd, was of the opinion that “[r]equesting data by its properties is far more natural than devising a particular algorithm or sequence of operations for its retrieval. Thus, a calculus-oriented language provides a good target language for a more user-oriented source language” (“Relational Completeness of Data Base […]
Read More
Learn what SQL Server experts know about database maintenance, including how and when to use plans or scripts, and the importance of a robust recovery strategy.
Read More
SQL Server and database experts share insights on features of SQL Server 2014 that promise significant performance potential.
Read More
SQL Server and database experts share insights on how to assess performance issues, including closely examining wait types to determine root cause.
Read More
SQL Server and database experts share insights on how hardware does and does not impact performance.
Read More
The main application area for the SQL Server MERGE statement is a data warehouse environment, where tables need to be refreshed periodically with new data arriving from OLTP systems. Learn more.
Read More
In DevOps, IT development and IT database production must work together to build and improve application and database performance.
Read More
Learn about SQL Server active/active clustering, multi-node clustering and how to cluster multiple instances on the same server.
Read More
Learn about how SQL Server clustering works, including how a failover works.
Read More
Learn how SQL Server clustering works, including active and passive nodes, the shared disk array, the quorum, public and private networks, and the cluster server.
Read More
Learn how to use SQL Server 2012 Dynamic Management Views (DMVs) to fine-tune SQL queries.
Read More