Click here to monitor SSC

Rodney

How Much Space Would An Index Take If An Index Did Take Space

Published Tuesday, June 12, 2007 8:58 PM

This would be my TechEd post. 

I was at TechEd for all of one day, on the first day. The only relationship I can make to the title of this blog and TechEd is the word space. The Orange County Convention Center is incredibly large. Even when you add several thousand IT professionals.  The free beer on Monday evening made it seem a bit smaller because I was walking askance or askew or asksomeoneelse I dont remember.  I enjoyed meeting everyone again. I met Tony again this year and treated him to some American beer, Mr Samuel Adams...Sorry, Tony that the only good bar we could find had no good ale.  And I met one of my SQL heroes, Itzik Ben-Gan.  I am sure I scared him with my inebriated homage. After all I am 6 foot 6, 260 pounds and can be a bit intimidating, but he towers above me mentally.

So..how much space does an index take if an index did take space.

Thinking of Katmai and the unrelational datastore, I have to offer this: If Microsoft does use SQL Server in the furture to store Windows file system information I put forth my idea for the name of the index scheme to use: Windex.

So with that incredibly horrible remark, I will retire to my small room which is about 1/1,000,000 the size of TechEd and ponder SQL Server 2011.

Rodney

 

by Rodney

Comments

 

WBrewer said:

Rodney,

Those of us in the UK who are reared on fine beer usually ask for Samuel Adams when in The States. Even though it is almost a Lager, it is extremely fine, particularly when served unchilled. By coincidence, I was sipping some when I read your Blog. I hope that Tony got to try some.

William
June 13, 2007 3:14 AM
You need to sign in to comment on this blog
<June 2007>
SuMoTuWeThFrSa
272829303112
3456789
10111213141516
17181920212223
24252627282930
1234567
How to Kill a Company in One Step or Save it in Three
 The majority of companies that suffer a major data loss subsequently go out of business. Wesley David... Read more...

Migrating from OCS 2007 R2 to Lync: Part 4
 Having migrated the rest of our users and legacy resources across and started getting ready to... Read more...

Automated Script-generation with Powershell and SMO
 In the first of a series of articles on automating the process of building, modifying and copying SQL... Read more...

Seth Godin: Big in the IT Business
 Seth Godin has transformed our understanding of marketing in IT. He invented the concept of 'permission... Read more...

Using SQL Test Database Unit Testing with TeamCity Continuous Integration
 With database applications, the process of test and integration can be frustratingly slow because so... Read more...