Viewing 15 posts - 16 through 30 (of 367 total)
October 13, 2017 at 4:52 pm
April 27, 2017 at 8:38 am
April 27, 2017 at 8:36 am
They won't switch back into the partitioned table, I haven't moved anything yet, I was just testing and preparing to make sure I had everything correct. I thought I will...
April 26, 2017 at 9:25 am
Once you're sure everything's correct, drop the table that you switched out in step 1 (the one with 2.4 billion rows in it)
Step one is the inventory file...
April 25, 2017 at 8:28 am
Gail,
I am starting this process today, I will post my step and results when I am done. I really hope this will help someone else in my...
April 24, 2017 at 8:43 am
yes April 2017.
Here's what I have done so far;
Create new ndf files and filegroups for 05 2016 to 12 2016.
Created tables for 05 2016 to 12...
April 19, 2017 at 12:43 pm
I mean, you can do that, but you're looking at a couple of days for...
April 19, 2017 at 9:22 am
April 19, 2017 at 9:13 am
yes, I realized my stmt after I put it out here. My apologies. then steps are correct. Add new file and filegroup, run alter schema and alter function with date...
April 19, 2017 at 8:03 am
I haven't added the filegroup or ndf file to the database yet, that's why it's not showing in the listing. I restored it from backup late last night for a...
April 19, 2017 at 7:38 am
CREATE PARTITION SCHEME [psch_Inventory]...
April 19, 2017 at 7:34 am
April 19, 2017 at 7:31 am
Viewing 15 posts - 16 through 30 (of 367 total)