To add as I just found where I put the link. Here is an article on how
to implement a sliding window.
http://technet.microsoft.com/en-us/library/aa964122.aspx
PAYCHEX
Christopher Bellizzi
Information Technology * Database Administration
675 Basket Road * Webster, New York 14580
(585) 216-0670 * [Email address protected]
-----Original Message-----
From: Richard Baumet
[mailto:mssqldba-ezmlmshield-x86656781.[Email address protected]
Sent: Friday, December 28, 2007 10:31 AM
To: LazyDBA Discussion
Subject: Re: paritioning
I don't think you can do that, but you could either have a job the does
a merge split every week (which includes dropping files and filegroups
and creating new ones. Or create a column that has 2 values (eg 1 or 0)
and frequently do updates on the table to change the value so the record
gets moved IF you partition on that column.
Rich
--------------------------
Sent from my BlackBerry Wireless Handheld
-----Original Message-----
From: Mahmood Jaffer (SoftLanding)
<mssqldba-ezmlmshield-x76354249.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Fri Dec 28 00:03:44 2007
Subject: paritioning
Hello,
Is it possible to use a dynamic function in the partition function
statement? I'd like to partition a sql 2005 table into two partitions
containing active data (data < than one week old) and > 1 week. Is this
even possible?
Thanks
Mahmood
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message is for the
exclusive and confidential use of the addressee. Any other distribution,
use, reproduction or alteration of the information contained in this
electronic message, by the addressee or by any other recipient, without
the prior written consent of the sender is strictly prohibited. If you
have received this electronic message in error, please notify the
sender.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
The information contained in this message may be privileged,
confidential, and protected from disclosure. If the reader of this
message is not the intended recipient, or any employee or agent
responsible for delivering this message to the intended recipient,
you are hereby notified that any dissemination, distribution, or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately
by replying to the message and deleting it from your computer.
Thank you. Paychex, Inc.
MS Sql Server LazyDBA home page