Pages

▼
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...
Tuesday, 1 August 2017

Updating so-called 'column statistics' for the whole SQL Server database

›
Definitely, statistics in SQL Server are vital to ensure stable database performance as a whole. Every DBA must know the importance of keepi...
Tuesday, 25 July 2017

Testing database connectivity by using a Universal Data Link file

›
After installing a SQL instance, we may need to test the database connectivity from a client host to make sure that everything is working ve...
Thursday, 20 July 2017

Detecting excessive compilation and recompilation issues

›
Undoubtedly, recompilation is a big topic to reckon with, more importantly, in database environments processing data that is changing rapidl...
2 comments: