When code is getting stall, sometimes the execution plans are point to the wrong or out dated or old objects. You would need to recompile all the stored procedures
2016-10-14 (first published: 2016-09-26)
3,837 reads
Yet another Script To get Sql server version Info. Run From Central Management server to get all your environment servers
2015-09-29 (first published: 2015-09-10)
1,710 reads
This script will ping the linked server and see if there alive
2011-11-03 (first published: 2011-10-21)
1,726 reads
Problem: We are replaceing our exchange server with a new one all DBMAILs on all server use the old one
2009-07-27 (first published: 2009-07-08)
498 reads