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...

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...

CREATE PARTITION SCHEME [psch_Inventory]...

I am also cleaning out the zero quantity items which make up 90% of the inventory table.  I have about 12 - 14 million rows a day and end up with 140K...

ok, I will let you know when it finishes.

Gail,

  It ran for 10 minutes with no result. Let me restore the database again, I ran the split for a few minutes today and then canceled it....

Can anyone help me? Are my steps correct? Every time I run the split it never finishes. The next used didn't give the file a partition number so I am...

I am pretty sure this is what I need to do below, I am deleting zero items in the table to get it down from 2.982 billion to a doable...

I have been reading more and found this article;

http://stackoverflow.com/questions/37239582/switch-partition-in-sql-server/37241198#37241198

I really just want to scream and throw my laptop...lol

http://www.sqlservergeeks.com/repair-the-database-using-dbcc-checkdb/

you will need to run a repair rebuild command. see article