Query Timeout Expired

If you ever use linked servers to run queries on a remote database server, you may run into this issue if your queries take longer than 10 minutes:  OLE DB provider “SQLNCLI11” for linked server xxxxx returned message “Query timeout expired” [SQLSTATE 01000] (Message 7412)

Continue reading Query Timeout Expired

Maintenance Cleanup Task

You have been diligently backing up your database and transaction logs, but now you have a directory that is full of files that have been backed up to disk/tape already or are no longer needed since they are old.  Within SSMS, you are able to create a job that can delete out the files that are no longer needed. Continue reading Maintenance Cleanup Task

My favorite SSMS add-in….SSMSBoost

Sql Server Management Studio is very robust and can do many things, but like any other product cannot do everything.  Luckily there are add-ins available that fill in some of the gaps.  My favorite and one I use every single day is SSMSBoost, (I no longer use it due to the change in the community license and the useful functions being taken away.)

http://www.ssmsboost.com

Continue reading My favorite SSMS add-in….SSMSBoost