Tags » SQL Server

AlwaysOn 2016 – Encrypted Databases in an AG

–By Ginger Keys

In the AlwaysOn 2016 release, there are several enhancements that have improved manageability, scalability, and availability. One of the enhancements is the ability to add encrypted databases to an AlwaysOn group. 1,270 more words

SQL Server

Why You May Need More Than FOR XML PATH('')

Working on a blog post and I came up against a problem that I had heard of before but did not spend much brain-CPU power against. 402 more words


How to import multiple result sets from Stored procedure?

One of my friends asked me if it is possible to load multiple resultsets returned from a stored procedure into a temporary table for some analysis purpose. 159 more words

SQL Server

Find when your SQL Server database grew

A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database file size change and who caused it. 280 more words



I recently discovered and tried using the “NOLOCK” query hint and found in some cases it reduced my query times up to 50%, though at times it seemed to have no effect or minimal effect. 327 more words

SQL Server