Pages

▼
Monday, 26 December 2016

How to delete large quantity of data with no growth of the Transaction Log and no blocking issue

›
Without a shadow of a doubt, at times while working on optimising not only database performance but also hard disk usage, we have to face wi...
Sunday, 11 December 2016

SQL2016: DROP IF EXISTS and CREATE OR ALTER statements

›
Beyond all doubt, using old-fashioned ways of manipulating database objects is not only a wasting of time but also boring. Therefore, it is ...
Wednesday, 7 December 2016

New per-operator level performance stats included in SQL2016 SP1 and SQL2014 SP2

›
Traditionally, we were used to getting only basic runtime performance stats per operator regarding to CPU, I/O and Memory, which were not go...
Monday, 14 November 2016

How to create new Logins and Users for an AlwaysOn Availability Group

›
(This tip also applies for Log Shipping and Database Mirroring) Surely, after setting up an AlwaysOn Availability Group (AG) we are going ...
3 comments:
Friday, 28 October 2016

How to monitor database file space usage in SQL Server

›
Undoubtedly, when it comes to monitoring database file space usage we need a simple way to do it. Fortunately, SQL Server has considerable q...
Friday, 30 September 2016

Creating alerts for monitoring proactively SQL Server AlwaysOn Availability Groups

›
When it comes to monitoring databases we have to do it proactively by using alerts implemented natively or via T-SQL code inside SQL Jobs ru...
Thursday, 29 September 2016

Using ‘sp_browsereplcmds’ to Diagnose SQL Replication Issues

›
When diagnosing transactional replication issues in SQL Server, we may need to examine pending commands within the distribution database. In...
3 comments:
Friday, 19 August 2016

Why is the .txt history detail file of SQL Backup Job not created?

›
Clearly, we always need to have some kind of history for SQL Backup jobs in order to check whether or not they were executed correctly. I pe...