-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
I’m generally not a great fan of Activity Monitor which is built in with SSMS,however today I wanted to check some processes details and opened Activity Monitor after a long…
Recently I was checking the plan cache utilization with the help of the below query which I normally use for this purpose. This is written by Glenn Berry(B/T) and is…
In theory we cannot backup the log of a database which is in Simple recovery model, however there is a small bug in SQL 2012 which allows you to do…
Have you ever observed this behavior Under SSMS > right-click SQL Server Agent > Properties> History. Enable checkbox “Remove agent History Older than 4 weeks.”. Press OK. Everything is fine (no error…
Cloud & SQLSailor 