Viewing 8 posts - 1 through 8 (of 8 total)
It's been a few years, but I seem to recall that I used PoSH because I had trouble getting T-SQL to handle some of the filesystem checks (eg, check for...
April 2, 2014 at 11:08 am
Del Lee (3/7/2014)
The first paragraph seems to imply that partitioning will improve the performance of deletes (while purging data). How does partitioning help with that?
Instead of deleting the data...
March 7, 2014 at 7:51 am
Yikes! This was a looooong time ago.
For what it's worth, we used this process in more or less the format presented (in this article and the next two articles)...
March 7, 2014 at 6:49 am
bpportman 52825 (12/14/2010)
Is there any performance gain when partitions are on the same set of spindles (can be same file group or different)?
There's probably something to be gained from parallel...
December 14, 2010 at 3:00 pm
amenjonathan (12/14/2010)
Anybody have any idea what happens when you do not add the partitioned...
December 14, 2010 at 2:55 pm
In reviewing the other two parts, I don't think I specifically address the idea of avoiding data movement (data moving from one file or file group to another...
December 14, 2010 at 12:42 pm
This article is actually in three parts. The next two parts describe automation of partition maintenance (adding partitions at the "top" and removing partitions from the "bottom").
My understanding is...
December 14, 2010 at 5:02 am
Many thanks to all for your posts. Some thoughts to add (in no particular order):
I have written an additional article based on my experiences designing storage on our array. It...
June 23, 2005 at 6:44 am
Viewing 8 posts - 1 through 8 (of 8 total)