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
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…
Read MoreSQL Authority News – 2 Days to Go – FalafelCON 2014: 2 days with the Best Developers in the World
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…
Read MoreSQL SERVER – The Basics of the SSIS Execute SQL Task – Notes from the Field #044
[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…
Read MoreSQL SERVER – Live Plan for Executing Query – SQL in Sixty Seconds #073
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…
Read MoreSQL SERVER – Live Plans for Long Running Queries
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…
Read MoreSQL SERVER – How to Know Cardinality of Executed Query?
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…
Read More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.