Browsing the blog archives for July, 2010

Location of SQL Server Default Trace

This is one of those posts for myself.  Sort of like a self-note. When things go wrong, especially unexpectedly, sometimes the only clue is the SQL Server default trace.  Where is it? <span class="kwrd">SELECT</span> * <span class="kwrd">FROM</span> ::fn_trace_getinfo(0) Now you know…  But do you have permissions to get to the file?  That’s another issue. For […]


Parallel Query Plans

This post is actually less about parallel query plans and more about a recap of some lessons learned from a recent project. I run an in-house T-SQL training class for new hires and other employees who either need to get up to speed with T-SQL or have a personal desire to learn.  In the very […]