Remote DBA experts: knowledge base
SQL Server 2014: parallel execution of SELECT INTO statements
In Microsoft SQL Server 2014 new in-memory options are presented. One of them is online transaction processing (OLTP) that complementing the existing business analytics and data storage options to cre...
Buffer Pool Extension in SQL Server 2014 part 4: benchmark testing for update operations
One of my previous articles was devoted to carrying out a range of tests to compare speed of data read operations using BPE. But in real life we need not only read but also update data, that’s why I...
SQL Server 2014 Buffer Pool Extension part 3: system monitoring
In this article I’d like to tell about monitoring tools available in SQL Server 2014 to evaluate the performance of Buffer Pool Extension.
First of all there is a system view sys.dm_os_buffer_pool_...
Monitoring of free space in database files
Monitoring of the size of database files is one of the important DBA tasks and this process should be automated. This article will show you how you can achieve this. Why is it important? Most likely y...
CONTEXT_INFO and efficient mass update on a large table with a trigger
Let`s assume we have following task – make changes to the data in a large table that has consistency checker in a trigger. Let`s look at the ways to do it in a most efficient way.
Use test database...