Thanks for Gail sharing the experience on approaching the problem !

I find in many cases, the "problem code" for a DB server is just not individual T-SQL statement pending for...

Just come across an article from Reflector Newsletter

https://www.simple-talk.com/dotnet/.net-tools/catching-performance-issues-in-development

It describe how Ants Performance Profiler help.

However, I found such approach may differ from what I expected. The Ants' approach start...

From my DBA role, I also did ran into problem while finding problem "code" on and off

The tools I use most being from the SQL Server side, so I could...

Thanks for Paul sharing his sample code with us !

However, as the method still require executing dynamic SQL Statement, (while such method is often being accused of being victims from...

I think : for developers used to work on SQL Server, they will more likely see "Database" as one components of an application. So if there are many applications running...

Thanks Steve.

However there is a puzzle in my head as I cannot catch the point,

how subsequent log recovery by DBA will be affected if developer takes a full backup...

I have not come accross these sort of excited recovery scenario, and learn a lot from the experience shared from the article and responses.

In the past, I also come across...

Thanks Martin and Steve.

We also just depends on SQL Server's own backup/restore utility (to disk file) for backup / recovering DB while Veritas just help to recover the Server image....

Basically, I set up in similar fashion (i.e. SQL Server / Agent service is running on its own service account, and no sysadmin rights for NT AUTHORITY\Local Admin or Local...