SQL Performance Archives - Page 51 of 100 - SQL Authority with Pinal Dave

SQL SERVER – Backing Up and Recovering the Tail End of a Transaction Log – Notes from the Field #042

August 21, 2014

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

[Notes from Pinal]: The biggest challenge which people face is not taking backup, but the biggest challenge is to restore a backup successfully. I have seen so many different examples where users have failed to restore their database because they made some mistake while they take backup and were not…

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

August 20, 2014

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…

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

August 8, 2014

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.

SQL SERVER – Activity Monitor to Identify Blocking – Find Expensive Queries

June 27, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Activity Monitor

Recently when I was busy working on my next course for Pluralsight, one of my friend pinged me for some help over messenger. And the conversation went on a different spin, here is a gist of what we talked and I felt this was worth a share – Me: Hi…

SQL SERVER – In-Memory Databases and Caching Wars

June 25, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Server

The In-Memory Database and In-Memory Caching market is heating up and we (the users) are the real winners. Exciting!!!

SQL SERVER – Keeping MSDB System Database Lean and Fit – Notes from the Field #033

June 19, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Notes from the Field, Shrinking Database, SQL Scripts

[Notes from Pinal]: I am working with SQL Server for almost 10 years. I have seen the most ignored databases on any database server is system database. We hardly pay attention to them. Just for the sake of it – try to run queries in your master database and see…

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

June 12, 2014

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…