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 | 83 Comments Filed under: internals, metadata, transaction log, DBCC LOGINFO

• 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 | 13 Comments Filed under: T-SQL Tuesday, datetime

• 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 | 57 Comments Filed under: metadata, Transactions, rowcount