THE SQL Server Blog Spot on the Web

Welcome to - 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), 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:

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



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
Anonymous comments are disabled

This Blog



No tags have been created or used yet.


News? Haven't you read my blog?

My Company

Can't find something?

Contact Me

Twitter: @rob_farley
Skype: rob_farley

MVP (SQL Server)


Adelaide SQL UG


Privacy Statement