April 2008 - Posts

• Did You Know? I'm going to Portland

  I almost titled this one with OT, but then I realized that this MY BLOG, and nothing is really off-topic, right? It's my blog and I can say whatever I want. :-) I get a real big kick out of seeing places in movies where I have actually been. I took my Read More... Posted Tuesday, April 29, 2008 8:11 PM by Kalen Delaney | 2 Comments Filed under: internals, training, Portland

• Geek City: Clustered or Nonclustered? Why not both?

  I had been thinking of this post all day, and then noticed that Denis wrote a post with almost the same name . I was worried he might have written about something similar, but it turns out not to be the case. A group of colleagues have been having a discussion Read More... Posted Thursday, April 24, 2008 3:51 PM by Kalen Delaney | 2 Comments Filed under: index hints, indexes

• Did You Know? Hot Off the Press -- Jim Gray Research Center in Wisconsin

  Jim Gray, winner of the Turing Award and author of the forward to three of my books, was the reason Microsoft opened the Bay Area Research Center . This article in Wired explains it: When Gray joined Microsoft in 1995, he convinced the software behemoth Read More... Posted Wednesday, April 23, 2008 2:49 PM by Kalen Delaney | 2 Comments Filed under: Jim Gray, Research Center

• Did You Know? Another Cumulative Update Package is Available

  Yep, CU #7 was announced yesterday... see http://support.microsoft.com/kb/949095 for details. It is interested that MS says: A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that Read More... Posted Tuesday, April 15, 2008 8:46 AM by Kalen Delaney | 4 Comments Filed under: cumulative update packages, service packs

• What Do You Think? Do Spelling and Grammar Matter?

  Ok, I'm not talking about simple typos. I can make typos like anyone else, but I don't like it. I try to reread anything I write before posting, on blogs and on newsgroups. With my blog, if I find a typo, I can go back and correct it and will always do Read More... Posted Friday, April 04, 2008 1:20 PM by Kalen Delaney | 35 Comments

• Geek City: How SQL Server Detects the Correct Versioned Rows

  Here is a question I just received from the feedback page on my web site: I have finished the book <the storage engine> and like it very much. I am now reading <query tuning and optimization> I know in the READ COMMITTED SNAPSHOT isolation, Read More... Posted Thursday, April 03, 2008 1:16 PM by Kalen Delaney | 4 Comments Filed under: internals, Transactions, Inside SQL Server, snapshot isolation

• Did You Know? My First Talk on SQL 2008

  I gave my first SQL Server 2008 presentation yesterday, and also spoke at a Launch Event for the first time. It was a terrific experience, primarily because it forced me to really start digging into SQL Server 2008. I had been doing so much 2005 training Read More... Posted Wednesday, April 02, 2008 6:13 PM by Kalen Delaney | 4 Comments Filed under: training, Management Tools, user groups, SQL Server 2008

• Did You Know? The Most Amazing Tool!

  I know, I said that about the SQL Internals Viewer , and that of course was amazing, but very limited in scope. I just found Zoomit at http://technet.microsoft.com/en-us/sysinternals/bb897434.aspx# This is the tool I have been hoping to find for years Read More... Posted Tuesday, April 01, 2008 1:00 AM by Kalen Delaney | 8 Comments