Browsing the blog archives for July, 2010
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? SELECT * FROM ::fn_trace_getinfo(0) Now you know… But do you have permissions to get to the file? That’s another issue. For a [...]
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 [...]