Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

partition_id VS. hobt_id Expand / Collapse
Author
Message
Posted Friday, March 8, 2013 9:35 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 3:44 PM
Points: 20,792, Visits: 32,703
GilaMonster (3/8/2013)
Lynn Pettis (3/8/2013)
GilaMonster (3/8/2013)
opc.three (3/8/2013)
GilaMonster (3/3/2013)
They were added as separate columns to support a feature that was planned, partially added to SQL 2005 and later scrapped.

You know I am curious about these kinds of things...remember which feature?


Yes.


Please, can you enlighten us?


No.

Feature that was never discussed or released publicly.


Oh, one of those NDA features. Okay, got it.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1428654
Posted Friday, March 8, 2013 9:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:02 AM
Points: 7,135, Visits: 12,744
bummer

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1428659
Posted Friday, March 8, 2013 9:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:20 AM
Points: 2,057, Visits: 3,575
Definitely DBCC TIMEWARP.
Post #1428662
Posted Friday, March 8, 2013 9:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:02 AM
Points: 7,135, Visits: 12,744
Ha, I still do not know the backstory on that one but it sounds funny. Building on that, maybe DBCC MIDDLE_EARTH since it involves a hobt_id?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1428666
Posted Friday, March 8, 2013 9:56 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:20 AM
Points: 2,057, Visits: 3,575
opc.three (3/8/2013)
Ha, I still do not know the backstory on that one but it sounds funny. Building on that, maybe DBCC MIDDLE_EARTH since it involves a hobt_id?


Ah yes, know that command, it replaces all your little rubber feet with big hairy ones.
Post #1428667
Posted Friday, March 8, 2013 9:58 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 3, 2014 8:05 AM
Points: 1,191, Visits: 9,892
hobt=Heap or B-Tree, so I'm guessing some kind of sub-partitioning? Oracle has a composite partitioning feature...
Post #1428669
Posted Friday, March 8, 2013 10:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:02 AM
Points: 7,135, Visits: 12,744
HowardW (3/8/2013)
hobt=Heap or B-Tree,

a.k.a. a "Hobbit"


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1428699
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse