Archives: March 2010
Someone asked a question in the forums the other day and I realized it would make a pretty decent blog post to explain the differences in functionality between these two and provide some code for working with them.
- fn_get_sql returns the last *statement* executed, where as DBCC INPUTBUFFER returns…
If you read my last post, you may have noticed that my images now include boxes, balloon text and highlighting. This is due to a friend insisting the he couldn’t live without Snagit for blogging or documentation and that I simply must try it. I figured I’d sign up… Read more
Here are many different thoughts/facts/preferences on aliasing. Most of this applies to column aliasing. Regardless of whether or not you like aliasing tables, you should still be aliasing columns. If you do happen to be one of the people who is against table aliasing (some of you may be… Read more
Now that I have several posts on what you can do with a Tally table, I figured I'd share my favorite way to create one inline. I still prefer to have a physical tally table (usually in a Utility database that can be accessed from anywhere and doesn't need to… Read more
My trip to the meeting, short as it was, involved some of the worst driving conditions I've ever personally encountered. It was coming down in sheets and I was doing 40mph on I-95. Before you roll your eyes about how I'm one of "those guys", note that only… Read more
David will be speaking about how to troubleshoot performance issues on SQL Server 2005 and SQL Server… Read more