Pages

▼
Thursday, 21 December 2017

Always On: Trying out Read-Only intent connections to secondary replicas

›
SQL Server Always On Availability Group enables us to connect Read-Only workloads to secondary replicas automatically by using differents wa...
Saturday, 16 December 2017

Implementing dynamic PIVOT in SQL Server

›
It is well known that PIVOT is one of the new features included in SQL Server 2005 which allows to convert rows into columns. But what happ...
Saturday, 2 December 2017

Memory + CPU support for all SQL Server versions and editions

›
It is by no means uncommon to think that every DBA should have a list like this following one in order to have clear some aspects before ins...
Friday, 1 December 2017

SQLServer Buffer Manager Buffer cache hit ratio, Page Life,Lazy Write/sec, Checkpoint Pages/sec

›
Without any shadow of a doubt, one of the procedures to follow in order to monitor and diagnose performance issues of a database server is t...
Thursday, 23 November 2017

Dropping columns statistics after migrating to SQL Server 2014/2016/2017

›
While migrating databases to new versions of SQL Server, there are some tasks that need to be carried out in order to warrant strong consist...
Saturday, 11 November 2017

How to migrate SQL Server aliases easily

›
Definitely, in my daily DBA life many times I had to complete the migration of hundreds of SQL Server aliases without wasting much time. The...
Friday, 3 November 2017

AUTO_CLOSE database option and its impact on the performance

›
The AUTO_CLOSE database option is only one of the many options related to performance and availability of the database in SQL Server.  When ...
Monday, 16 October 2017

Getting information about referenced and referencing tables

›
At times we do need to carry out some tasks related to figure out certain information about references among some database objects. Today...