Pages

▼
Sunday, 25 June 2017

Getting the full name of SQL Jobs including the steps in execution

›
While monitoring a database server, we may need to know some details about the sessions, connections and requests that migh be causing perf...
Monday, 19 June 2017

Error: could not obtain information about Windows NT group/user

›
Without any doubt, at times there is a need to use extended stored procedures in SQL Server, for instance, the following error may be raised...
Friday, 2 June 2017

sys.dm_exec_requests: total_elapsed_time column might return inconsistent data

›
Developing useful scripts for administration purposes, I have found a bug with respect to data recollected by 'sys.dm_exec_requests'...
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 ...