THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Internals   (RSS)
Showing page 14 of 14 (137 total posts)
  • Which DMV Shows Plan Handles?

    Sometimes, knowing which Dynamic Management View (DMV) to use is your biggest challenge when attempting to figure out SQL Server 2005 behavior.  For example, what if you want the cached execution plans in XML format, similar to the output of SET SHOWPLAN_XML?  As it turns out, Gert Draper pointed out that there are a couple of DMVs ...
    Posted to Kevin Kline (Weblog) by KKline on July 25, 2007
  • Geek City: My New Favorite Tool - SQL Internals Viewer

    At least, I think it might become my new favorite tool.  J One of my readers created a tool to graphically display database storage internals, like allocation information, actual page contents, etc. This is just the tool I would have wanted to write if I ever got back to doing any programming. Here's what the author, Danny ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on July 19, 2007
  • Geek City: Maximum Number of Row-overflow columns

      I received a question from one of my readers that concerned this paragraph in Inside SQL Server 2005: The Storage Engine. The number of large variable-length columns that a table can have is not unlimited, although it is quite large. There is a limit of 1,024 columns in any table, so that is definitely a limit there. But another limit ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on July 16, 2007
  • Did You Know? I'm independent again

    I thought I would be able to post this as a special Independence Day announcement, but it wasn't final until July 6th. Then I was teaching for 5 solid days the following week, so now on Monday I am making my announcement. I am no longer working with Solid Quality Learning (or Solid Quality Mentors, as they have changed their name ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on July 16, 2007
  • Corrections on Trace Flag Entry

    Kalen Delaney and I were chatting via email about a past blog entry I'd written about trace flags. The blog entry was based on some discussions I'd listened in on between a few other SQL Server MVPs.  In it, I said:  Oh, and there is ...
    Posted to Kevin Kline (Weblog) by KKline on July 4, 2007
  • Read Index Structure

    I recently listened in on a conversation between SQL Server MVPs Cristian Lefter and our very own Itzik Ben-Gan.Cristian asked, ''Hi, I want to display an index structure from an AdventureWorks index an indexing chapter of a book.  I mean by that the content of the leaf level pages and the page numbers and some data for ...
    Posted to Kevin Kline (Weblog) by KKline on January 25, 2007
  • Spatial Indexing

    I spent many years working for NASA on Oracle databases. At that time, in the late 1980's and early 1990's, spatial indexing was a novel and difficult idea. We worked heavily on the notion and, with significant help from Oracle, enabled our databases to store specially designed datatypes for spatial data. Microsoft is researching similar or even ...
    Posted to Kevin Kline (Weblog) by KKline on January 22, 2007
Privacy Statement