Travels with my daughter taught me the value of history. The Historic Information section of Performance Dashboard does the same for your SQL Server.
SQL SERVER – Database Taking Long Time to Create – Notes from the Field #047
Ever seen a database taking a long time to create? Tim Radney explains in simple words why it happens, based on a real question from a forum.
SQL SERVER – Location of Natively Compiled Stored Procedure and Naming Convention
Why is it called a natively compiled stored procedure when the code is T-SQL? I explain, and show a DMV query that finds where its DLL is loaded from.
SQL SERVER – Beginning In-Memory OLTP with Sample Example
Beginning In-Memory OLTP in SQL Server 2014 is easier than it looks. I explain why we need it in simple words, with a sample example to get you started.
SQL SERVER – How to Setup Delayed Durability for SQL Server 2014?
How do you setup Delayed Durability in SQL Server 2014? Here are three methods, starting at the database level with ALTER DATABASE SET DELAYED_DURABILITY.
SQL SERVER – How to Know Cardinality of Executed Query?
Which estimator did SQL Server 2014 use? There are two ways to know the cardinality of executed query, starting with the execution plan properties.
SQL SERVER – Backing Up and Recovering the Tail End of a Transaction Log – Notes from the Field #042
Tail log backup confuses many people, even with the new hints on the restore screen. Learn how to back up and recover the tail end of a transaction log.