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 13 of 13 (125 total posts)
  • 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
« First ... < Previous 9 10 11 12 13
Privacy Statement