How to Look at SQL Server 2012 Query Plans
There are several ways to view SQL Server query plans, but perhaps the easiest is to view the graphical plan using SQL Server Management Studio (SSMS).
Read MoreMost Popular Databases
SQL Server Plan Caching and Recompilation–Plan Cache
To find performance issues caused by long lookup times, you can look into the contents of the SQL Server DMV sys.dm_os_memory_cache_hash_tables. Learn more.
Read MoreSQL Server Plan Caching and Recompilation–Parameterization
When SQL Server Query Optimizer comes up with a plan, it caches the plan using parametrization options to ensure it can be reused as widely as possible.
Read MoreSQL Server Query Optimization–Understanding Statistics
Statistics provide critical information needed by SQL Server when performing query optimization, including details about the data and what the data looks like in each table within the database.
Read MoreSQL Server Query Optimization: Parallel Plans
Learn how SQL Server Query Optimizer chooses parallel plans–any plan in which the Optimizer splits as applicable operator into multiple threads–and how this can impact performance.
Read MoreSQL Server Query Optimization
Get a high-level overview of the secret inner workings of the SQL Server 2012 Query Optimizer.
Read MoreDeploy SQL Server Log Shipping as a Report Database Solution
Learn in which cases you can deploy SQL Server log shipping as a low-cost solution for production reporting.
Read MoreDeploy SQL Server Log Shipping as a Disaster Recovery Solution
Learn how to deploy SQL Server log shipping to a secondary server to protect your organization from a power grid failure or local disaster.
Read MoreDeploy SQL Server Log Shipping to Create a Warm Standby Server
Learn about deploying SQL Server log shipping to create a warm standby server.
Read MoreSQL Server Clustering Alternative Options
Learn about SQL Server active/active clustering, multi-node clustering and how to cluster multiple instances on the same server.
Read MoreHow SQL Server Clustering Works, Part 2
Learn about how SQL Server clustering works, including how a failover works.
Read MoreHow SQL Server Clustering Works, Part 1
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