All Articles - SQL Authority with Pinal Dave

SQL SERVER – Simple Example of Delayed Durability

September 8, 2014

Earlier I wrote two blog posts on Delayed Durability. Please read them before continuing this example, as they will give you good information about this concept before we start. SQL SERVER – Basics of Delayed Durability in SQL Server 2014 SQL SERVER – How to Setup Delayed Durability for SQL…

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 – Basics of Delayed Durability in SQL Server 2014

September 6, 2014

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

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 is Full Transaction Durability. The current default of SQL Server is Full Transaction Durability. A common…

SQL Authority News – 2 Days to Go – FalafelCON 2014: 2 days with the Best Developers in the World

September 5, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

It is only two weeks away. On September 20-21, 2014 I will be in San Francisco presenting at an amazing conference of Falafel Conference 2014. I love presenting at various forums on various technologies. I am extremely excited that I got invited to speak at Falafel Conference 2014 in San…

SQL SERVER – The Basics of the SSIS Execute SQL Task – Notes from the Field #044

September 4, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SSIS

[Note from Pinal]: This is a new episode of Notes from the Field series. SSIS is an interesting concept. There are more hidden features with SSIS than any other product. Additionally, there are many visible features which are not known to most of the people. Earlier I mention to SQL developer that…

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 – Live Plans for Long Running Queries

September 2, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

If you are a SQL Server DBA or developer who is majorly dealing with queries which are running for a long time, you may have one request every time you see a long running query. The request is how to see a plan for a query when it is still…

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 Authority News – 3000th Blog Posts and Thank You

August 31, 2014

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL Milestone

3000th Blog Posts! When I realized that I am writing my 3000th blog post (list of all of my blog posts), I just got blank with happiness. I could not come up with what exactly to write. It has been a long time since I have stopped writing about milestones.…

SQL SERVER – CTRL + R Shortcut Does Not Work in SSMS

August 30, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio, SQL Shortcut

I just formatted my computer and installed fresh SQL Server 2014. The very first thing which I did was to open SQL Server Management Studio and execute a sample query. As soon as I executed the query, it returned me some result. Once I did not need the result, my…