Pages

▼
Friday, 26 May 2017

How to know which non-clustered indexes are not being used any longer

›
It is said that indexes are extremely useful to boost the performance of databases, especially indexes on huge tables. I am in agreement wit...
Thursday, 11 May 2017

ObjectExplorer error: Dedicated administrator connections are not supported

›
Dedicated Administrator Connection (DAC) is a type of privileged connection that we can establish to SQL Server database engine when it does...
Sunday, 30 April 2017

Converting Unix Timestamp into SQL Server DateTime

›
It is well known that developing and integrating applications based on different technologies may end up being a huge challenge, especially ...
Wednesday, 12 April 2017

Checking Disk Space usage and Database Files usage per partition disk

›
When it comes to monitoring and managing disk space we may have some graphic tools to help us complete these tasks rapidly, nevertheless, no...
Wednesday, 5 April 2017

Looking into Modern_Spanish and Latin1_General

›
The collations Modern_Spanish and Latin1_General are both Windows collations and support the same character set (Code Page 1252), but there ...
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...