partitioning in 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » partitioning in 2008

partitioning in 2008

Rate Topic

Display Mode

Topic Options

Author

Message

lakb200

Posted Thursday, December 17, 2009 8:38 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 06, 2012 9:52 AM
Points: 9, Visits: 51

can you partition on
nvarchar column with values mm/dd/yyyy. How to define the part... function, may need some conversion? and fg for part... sche...?

syntax may help.

Post #836109

Henrico Bekker

Posted Thursday, December 17, 2009 10:11 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692

http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx
http://blogs.msdn.com/menzos/archive/2008/06/25/table-partitioning-in-sql-2008.aspx
http://sqlfool.com/2008/11/102/

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #836124

GilaMonster

Posted Friday, December 18, 2009 12:59 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:35 PM
Points: 37,650, Visits: 29,901

lakb200 (12/17/2009)

can you partition on
nvarchar column with values mm/dd/yyyy.

Wait just a sec. An nvarchar column with a date in it? Why nvarchar and not datetime? If it's a date, it should be stored as datetime.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #836160

lakb200

Posted Friday, December 18, 2009 6:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 06, 2012 9:52 AM
Points: 9, Visits: 51

Appreciate your help.

Cannot define as date time.populated by othe application.noticed though defining function in sequential order, it reshuffles from 01/31/2009,02/31/2009...01/31/2010...12/31/2010...12/31/2011 01/31/2009,01/31/2010,02/2009...12/31/2010,12/31/2011 and the values are in the wrong partition

Post #836275

GilaMonster

Posted Friday, December 18, 2009 9:03 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:35 PM
Points: 37,650, Visits: 29,901

lakb200 (12/18/2009)

Cannot define as date time.

Why not?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #836412

lakb200

Posted Friday, December 18, 2009 9:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 06, 2012 9:52 AM
Points: 9, Visits: 51

Checked further , it is populated in ERP system and they have restrictions on this format. 3rd party. Also there is no dd coming
We just get MM/yyyy.

Post #836451

« Prev Topic | Next Topic »

Permissions