Pages

▼
Tuesday, 20 March 2018

Configuring Read-Only Routing and load-balancing across Read-Only replicas

›
With the arrival of AlwaysOn Availability Group in SQL Server 2012, implementing HA+DR solutions have been an easier and not expensive task ...
Saturday, 17 February 2018

Quickly Checking for Stale Statistics in SQL Server

›
Monitoring the state of database statistics is crucial because they significantly influence overall performance. When statistics become outd...
2 comments:
Tuesday, 13 February 2018

Avoid changing default ANSI database options

›
Not having another way of fixing some specific errors, at times some people may consider turning off any ANSI database options as a final s...
Sunday, 21 January 2018

How to make uniform all the collations of table columns for all databases

›
Clearly, it is of paramount importance to standardise the collations for all databases in a SQL Server instance in order to avoid dealing wi...
Friday, 12 January 2018

MSSQL_ENG003165: An error was encountered while replication was being restored/removed. The database has been left offline

›
While restoring a replicated database without KEEP_REPLICATION  option, SQL Server will remove replication settings by executing  sp_restore...
Thursday, 4 January 2018

Table-valued user-defined functions and the database collation

›
When it comes to altering database collations we may face some problems that tend to slow us down at the beginning. Nevertheless, digging in...
Saturday, 30 December 2017

Memory + CPU support for all Windows Server versions and editions

›
Some weeks ago I outlined my Memory + CPU support compact brief for SQL Server , and now it is time for Windows Server. Undoubtedly, when we...
1 comment: