December 2009 - Posts

• Geek City: Exploring the Transaction Log Structure

  As I mentioned last October, my PASS preconference seminar was a whole day about the transaction log . I told the attendees all kinds of things about the structure of the log, and told them about one of the best tools for exploring the structure: the Read More... Posted Monday, December 21, 2009 5:48 PM by Kalen Delaney | 2 Comments Filed under: DBCC LOGINFO, internals, metadata, transaction log

• T-SQL Tuesday #001: My Datetime FAQ

  I am rising to Adam's challenge for his very first T-SQL Tuesday , and blogging about datetime issues. Since I just finished a 9-hour teaching day in Stockholm, and I'm incredibly jetlagged, I decided to keep this simple. I'm very much looking forward Read More... Posted Tuesday, December 8, 2009 11:49 AM by Kalen Delaney | 4 Comments Filed under: datetime, T-SQL Tuesday

• Geek City: How Many Rows?

  In my last post, I told you I'd post something technical before I left for Sweden. I almost made it. I wrote this in the Seattle airport, but wasn't able to post it until I got to Stockholm. For as long as I've been working with SQL Server, I've been Read More... Posted Monday, December 7, 2009 10:59 AM by Kalen Delaney | 7 Comments Filed under: metadata, rowcount, Transactions