Pages

▼
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...
Friday, 13 October 2017

Purging old backup files by using forfiles windows tool

›
It is well know that most backup strategies include a step to purge backup files to keep the most recent backups in the database server so t...
Monday, 2 October 2017

Getting useful information of data & log files for all databases

›
It is a common DBA task to check the unused space of all database files in order to make the decision of extending the file sizes and provid...
Thursday, 21 September 2017

Quickly find a cached execution plan of an Ad-Hoc query

›
It is clear that sometimes we just need to find a cached execution plan as quickly as possible so that it can be analysed and then use it to...
Thursday, 7 September 2017

Getting information about memory used by SQL Server

›
Naturally, every DBA is asked to report information about the memory used by SQL Server. Common questions are related to memory reserved and...
Tuesday, 15 August 2017

Altering SQL Jobs without granting SysAdmin privilege

›
What would you do if you were asked to grant a few users the permission for altering SQL Jobs? It is a tricky task to carry out although man...
Tuesday, 8 August 2017

Dealing with physical database corruptions

›
Beyond all doubt, not every single database in the world has a DBA dedicated to monitoring it 24x7 hours. Moreover, many database environmen...
Friday, 4 August 2017

Troubleshooting timeout expired errors

›
Having .NET Applications working with SQL Server, some unforeseen timeout errors can be raised for two possible causes: bad-written SQL code...