SQL Tips and Tricks Archives - Page 164 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Beginning In-Memory OLTP with Sample Example

September 15, 2014

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

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…

Google Drive Trick – Google Spreadsheet Formatting Dates to String

September 14, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, Software Development

I have been using google drive and google spreadsheet for a while. I work with experts around the world and we all use different date format. The biggest confusion which often happens when we are sharing data is a timestamp. For some people it is natural to have dates time…

SQL SERVER – Flushing Transaction Log to Disk for Current Database

September 13, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I have written quite a while on Delayed Durability and every blog post when I think it will be the last post on this subject, I always get some question in an email and I end up writing a new blog post. Here are a few blog posts which I…

SQL Authority News – Discount Code for for SQL Live! 360 in November

September 12, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I thought you might be interested to know that I’ll be speaking at Live! 360, November 17 – 21 in Orlando, FL. Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current ones. More info: As a speaker,…

Hey DBA – Go Make a Proactive Investment Today! – Notes from the Field #045

September 11, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field

[Note from Pinal]: This is a 45th episode of Notes from the Field series. If you know Mike Walsh, he is an amazing person to meet and know. I am fortunate to be his friend. Every single time I meet him, I learn something as a human. Last time when…

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 – Delayed Durability Database Level and Transaction Level

September 9, 2014

Pinal Dave

SQL Tips and Tricks

Earlier I have written three articles on the concept of Delayed Durability. You can read them over here. SQL SERVER – Basics of Delayed Durability in SQL Server 2014 SQL SERVER – How to Setup Delayed Durability for SQL Server 2014? SQL SERVER – Simple Example of Delayed Durability After…