FAQs Help and Tutorials Archives

HOW TO: Trace Statements Without SQL Profiler

October 29, 2017February 28, 2012 by Thomas LaRock

I came across an interesting scenario last week, someone needed to trace statements and they didn’t have SQL Profiler installed. Turns out they don’t actually need SQL Profiler in order to trace the statements hitting the instance. There is a trace flag (4032) that can be used to trace statements. When used with 3605, you … Read more

Do You Have Corrupt Databases?

October 29, 2017February 14, 2012 by Thomas LaRock

You never see the termites, you only see the damage they have done. And by then it is often too late. Same with corruption inside of your database. Often time most folks have no idea there is any issue until it is too late. Wouldn’t it be nice if there was a quick and easy … Read more