THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Internals   (RSS)
Showing page 16 of 16 (160 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.  http://www.sqlmag.com/Article/ArticleID/92774/Trace_Flag_Changes_in_SQL_Server_2005.html 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
  • The Beatles versus the Stones - the explanation

    On December 31 of last year, I posted this brain teaser, promising to post the answer “in a few days”. Apparently, 15 is a few J.   In case you have forgotten what the puzzle was about and are too lazy to click the link above, the bottom line is that I created and populated two tables, with the same schema but different content. One held ...
  • The Beatles versus the Stones

    Here’s a nice brain teaser, just before the end of the year. Despite the title, it is related to SQL Server, not to music!   A common misconception amongst SQL Server users is that a clustered index on a table will ensure that data is returned in the order implied by that index. I have lost count of the number of times I had to disprove ...
  • The table scan from hell

    Greg Linwood, a fellow SQL Server MVP, has started a series of articles in which he attempts to prove that having a clustered index on each table is not a good practice. However, he has failed to include the effects of fragmentation into account, so I decided to run some tests for myself. One of those test had rather upsetting ...
Privacy Statement