Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was stuck on “encryption in progress” for quite a while. Using the following query I confirmed the following: (source: https://msdn.microsoft.com/en-us/library/bb677274.aspx) My … Continue reading
Tags: SQL Server
Related Articles
SQL Server vNext: sys.dm_db_stats_histogram
Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram for a specific stat which actually is also available with the latest Cumulative Update for ...
Session Cursor Caching – Part One
Introduction When a SQL statement is issued, the server process, after checking its syntax and semantics, searches the library cache for an existing cursor for the SQL statement. If a cursor does not ...
Comparing Toad to Toad Data Point
Hi, This article hopes to compare Toad v13.0 and Toad Data Point v4.3. The versions of each product are not most important, as I cover the major features that both products have in common then will h...
