Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Cardinality Estimation and Performance – SQL in Sixty Seconds #072

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQL Video
SQL Server Management Studio
Yesterday I wrote blog post based on my latest Pluralsight course on learning SQL Server 2014. I discussed newly introduced cardinality estimation in SQL Server 2014 and how it improves the performance of the query. The cardinality estimation logic is responsible for quality of query plans and majorly responsible for improving…
Read More

SQL SERVER – Introduction to SQL Server 2014 In-Memory OLTP

Pinal Dave
SQL Performance
In-Memory OLTP, SQL Scripts, SQL Server

In SQL Server 2014 Microsoft has introduced a new database engine component called In-Memory OLTP aka project “Hekaton” which is fully integrated into the SQL Server Database Engine. It is optimized for OLTP workloads accessing memory resident data. In-memory OLTP helps us create memory optimized tables which in turn offer significant performance improvement for our typical OLTP workload.

Read More

SQL SERVER – SQL Server High Availability Options – Notes from the Field #032

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Notes from the Field, Shrinking Database
[Notes from Pinal]: When it is about High Availability or Disaster Recovery, I often see people getting confused. There are so many options available that when the user has to select what is the most optimal solution for their organization they are often confused. Most of the people even know…
Read More