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

SQL SERVER – Location of Natively Compiled Stored Procedure and Naming Convention

September 16, 2014

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

Yesterday I wrote about SQL SERVER – Beginning In-Memory OLTP with Sample Example. One of the questions I received right after I published a blog post was why do I call stored procedure natively coded stored procedure when the entire code is in T-SQL. Indeed a very good question. The…

SQL SERVER – Beginning In-Memory OLTP with Sample Example

September 15, 2014

Pinal Dave

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

In-Memory OLTP, SQL Memory

In-Memory OLTP is a wonderful new feature introduced in SQL Server 2014. My friend Balmukund Lakhani has written amazing series on A-Z of In-Memory on his blog. All serious learner should study it for deep understanding of the same subject. I will try to cover a few of the concepts…

SQL SERVER – Video Introduction to Delayed Durability – SQL in Sixty Seconds #074

September 10, 2014

Pinal Dave

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

SQL Server Management Studio

Earlier I wrote blog post based on my latest Pluralsight course on learning SQL Server 2014. SQL Server 2014 has introduced many new features and one of performance is Delayed Transaction Durability. This concept is indeed very interesting. To explain this feature in detail, we will require to understand what…

SQL SERVER – How to Setup Delayed Durability for SQL Server 2014?

September 7, 2014

Pinal Dave

SQL Performance

SQL Memory, SQL Scripts, SQL Server

Yesterday we discussed about the Basics of Delayed Durability in SQL Server 2014. Today we will learn one more topic about this subject – How to Setup Delayed Durability for SQL Server 2014?

SQL SERVER – Live Plan for Executing Query – SQL in Sixty Seconds #073

September 3, 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 live plans. For query before you execute it, you can see the estimated execution plan and after you executed you can see the actual execution plan – however, how to…

SQL SERVER – How to Know Cardinality of Executed Query?

September 1, 2014

Pinal Dave

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

Earlier I wrote three blog posts on SQL Server 2014 Cardinality. Read them over here to get the context of this blog post. SQL SERVER – How to Force New Cardinality Estimation or Old Cardinality Estimation SQL SERVER – Simple Demo of New Cardinality Estimation Features of SQL Server 2014 SQL…

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

August 21, 2014

Pinal Dave

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

Notes from the Field

[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…