THE SQL Server Blog Spot on the Web

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

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and provides consulting and training courses around the world in SQL Server and BI topics.

Table? No such thing…

Hi! - Great that you've found this page, but it's no longer here! You can find the content over at: http://blogs.lobsterpot.com.au/2010/09/14/table-no-such-thing/

Published Tuesday, September 14, 2010 11:48 AM by Rob Farley

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

mjswart said:

That's awesome! Spoofing the Matrix:

"Don't try to look up information in the table. That's impossible. Only try to realize the truth."

"What's that?"

"There is no table."

September 14, 2010 8:48 AM
 

Rob Farley said:

Yes - exactly. :)

September 15, 2010 12:27 AM
 

mjswart said:

While heaps don't have indexes, I think your points can stand after we stop calling them "heaps" and start calling them "piles" or "messes" (and not tables).

September 16, 2010 8:51 PM
 

Rob Farley said:

No - heaps aren't all bad. They're just indexes ordered by the rowid.

September 16, 2010 9:08 PM
 

Mike S said:

I am in favor of "piles" or "messes" over the word "Heap".

When I first started learning database internals, the word "heap" reminded me of my analysis of algorithms days, where the word "heap" refers to a tree-based data structure used for heapsort...

Why they SQL Server would store unordered data as those types of "heaps" was very confusing to me.

"Messes" is better. If you want to start a campaign, I'll be the first one to sign the petition

September 20, 2010 10:39 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

News

News? Haven't you read my blog?

My Company


Can't find something?

Contact Me

IM: rob_farley@hotmail.com
Twitter: @rob_farley
Skype: rob_farley
E: rob_farley@hotmail.com

MVP (SQL Server)




Certifications








Adelaide SQL UG

Privacy Statement