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

Partition Functions Expand / Collapse
Author
Message
Posted Thursday, August 7, 2008 10:48 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item Partition Functions
Post #548855
Posted Thursday, August 7, 2008 11:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 20, 2008 1:31 AM
Points: 11, Visits: 31
Hi,

When in real life the partition function is used?

Thanks & regards,
SS
Post #548863
Posted Friday, August 8, 2008 12:27 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, June 30, 2010 3:05 AM
Points: 363, Visits: 17
Hi all,

What exactly is the Partition Function.

Regards,
Fazal.
Post #548874
Posted Friday, August 8, 2008 12:58 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:52 PM
Points: 1,229, Visits: 1,193
It's used in setting up table & index partitioning.

A nice article on this topic:
http://technet.microsoft.com/en-us/library/ms345146.aspx
Post #548894
Posted Friday, August 8, 2008 7:21 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:54 PM
Points: 3,869, Visits: 3,620

Thanks for the link, that was helpful.
Post #549141
Posted Friday, August 8, 2008 9:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:08 PM
Points: 2,607, Visits: 17,906
Hmmm... I got the error below, which wasn't one of the options, so I couldn't select it:

Msg 7736, Level 16, State 1, Line 2
Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition of SQL Server supports partitioning.
Msg 208, Level 16, State 80, Line 1
Invalid object name '$partition.PartitionFunction1'.

:P got it right anyway. :P

Chad

(yes, yes, I know.... adding this as an option would have destroyed the point of the question.)
Post #549320
Posted Friday, August 8, 2008 2:52 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
Actually, Chad, knowing that, I would have worded the question to include that data. Minor nitpick, but legit. Not my question, but would have worded it with that in mind if it were mine.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #549600
Posted Monday, August 11, 2008 2:14 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:36 PM
Points: 5,300, Visits: 1,378
New thing to learn. Thanks.....:)


Post #550077
Posted Monday, August 11, 2008 9:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 18, 2014 8:44 AM
Points: 166, Visits: 199
There are two facts needed to answer this question correctly:

1) RANGE LEFT is the default.
2) Partitions start numbering at one, not zero.

I was only half-way there.



Post #550384
Posted Tuesday, December 11, 2012 3:06 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:20 AM
Points: 1,888, Visits: 2,323
good one.. new thing to knw abt partioning


_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1394985
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse