WhoIsActive
I thought that I would just share a little stored procedure that I've been using in my day job since becoming an accidental DBA! It's the WhoIsActive stored procedure by Adam Machanic. This stored procedure pulls together ALOT of information... Read More
Index Rebuild or Index Reorganize
You've just discovered that your indexes are fragmented, so you decid to do something about it. You know you need to do something to your indexes, but you're stuck wondering what the difference is between REBUILD and REORGANIZE.
...
PING all the Linked Servers and get a status report
As a DBA it’s handy to have a script to PING all the Link servers and get a report to examine the connectivity. Following T-SQL script will ping all the preconfigured linked servers and get the packets sent, received and...
Read MoreT-SQL Divide by Zero Error
Someone in my day job this week asked me how to deal with Msg 8134, Level 16, State 1, Line 3 Divide by zero error encountered error that they were receiving. It's second nature for me to add the below...
Read MoreHow to find the expiry date for SQL Server 2012 Evaluation
Did you install SQL Server 2012 Standard Edition for evaluation purposes on your PC and forgot to write down when your six months is up? Yep, you're right, I'm talking from experience here! So I needed some T-SQL magic to...
Read More