Viewing 15 posts - 1 through 15 (of 62 total)
August 16, 2018 at 4:58 am
Actually, I have a question. Why not just create a unique...
August 16, 2018 at 4:35 am
Ok, I understand how I need to split the top partition:
ALTER PARTITION SCHEME <PartitionScheme>
NEXT USED [PRIMARY];
GO
ALTER PARTITION FUNCTION <PartitionFunction>
...
March 16, 2018 at 1:38 am
Thank you, that link does help.
I was after someone who had been in a similar situation & therefore wanted to draw upon their experience, a forum seemed the best place...
March 15, 2018 at 11:10 am
Sounds like
March 15, 2018 at 9:01 am
March 15, 2018 at 8:46 am
March 15, 2018 at 8:38 am
in case anyone is interested, I solved this by using a try..catch block:
(also configured the agent job to write out to a log file, so we can capture...
March 15, 2018 at 6:31 am
March 9, 2018 at 1:25 am
March 7, 2018 at 10:04 am
March 7, 2018 at 6:30 am
To add, this behaviour only appears to be happen in 2008R2, I've tested in a 2012 instance and do not get the same results; the script runs within SQL Agent...
March 6, 2018 at 2:05 pm
Viewing 15 posts - 1 through 15 (of 62 total)