Partition Functions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Unknown Unknown » Partition Functions

Partition Functions

Rate Topic

Display Mode

Topic Options

Author

Message

Site Owners

Posted Thursday, August 07, 2008 10:48 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

Comments posted to this topic are about the item Partition Functions

Post #548855

sheetalsh

Posted Thursday, August 07, 2008 11:46 PM

Grasshopper

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

fazal.shaikh

Posted Friday, August 08, 2008 12:27 AM

Old 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

Lian Pretorius

Posted Friday, August 08, 2008 12:58 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:49 AM
Points: 1,139, Visits: 1,107

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

Cliff Jones

Posted Friday, August 08, 2008 7:21 AM

Hall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 12:39 PM
Points: 3,397, Visits: 3,405

Thanks for the link, that was helpful.

Post #549141

Chad Crawford

Posted Friday, August 08, 2008 9:20 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:52 PM
Points: 2,549, Visits: 17,363

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

GSquared

Posted Friday, August 08, 2008 2:52 PM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:55 PM
Points: 15,442, Visits: 9,571

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

Anipaul

Posted Monday, August 11, 2008 2:14 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 1:35 AM
Points: 4,788, Visits: 1,336

New thing to learn. Thanks.....:)

Post #550077

Festeron

Posted Monday, August 11, 2008 9:49 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 12, 2013 9:43 AM
Points: 142, Visits: 171

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

kapil_kk

Posted Tuesday, December 11, 2012 3:06 AM

Ten Centuries

Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:16 PM
Points: 1,061, Visits: 1,151

good one.. new thing to knw abt partioning

Post #1394985

« Prev Topic | Next Topic »

Permissions