I'm going to have to...

I'm beginning to wondor if the OP has even checked this thread. I haven't seen anything since the original post.

And another thought, you may need to use advanced math (calculus) if you are trying to maximize the number of bottles per box. With that, these calculations should probably...

Okay, that one looked like a nitrogen frozen, napalm soaked porkchop to me...

Given the proper information it should be possible to create a function/procedure to complete the necessary computations. Is there only one size box or do you have multiple sizes...

Build it now! They will...

First, i think the first query should benefit from the partioned table. Not sure about the second one.

Second, I took the time to rewrite your queries. I think...

What do your typical queries look like, not the one you alread showed me by the way.

You might want to look at SQL Server 2008 with the varbinary data type and the filestream filegroup (?).

What you are trying to accomplish may not benefit from a partitioned table. What is your objective? How much data do you have? What are the normal...

But are...

Insanity is hereditary, you get it from your kids

-- reference unknown

Edit: And for those without kids, I have no explanation.

we can't go where we already are

I don't know. You did not provide the actual code for the partition scheme, partition function, or the partition table.

lily1706 (5/20/2009)

---

I did a basic one like:

select * from [table_name] where date > '2009-03-01 00:00:00.000'

i tired on my production DB where the table is not partitioned yet and I...