Guys,

Please help me out in this.

I am new to this SQL Server 2005 Partitioning.

Here is the scenario, there is Log table which consists of 1 million
rows to be inserted in a day. I would like to partition this table into
a daily basis
(day1, day2 ,day3 ...) and keep for about 10 days in the Active Server.

How do I perform this using the range partition?

Thanks for your help in advance.

random select a row based a weight column.
store results over network
Variable table name in a cursor declaration
dynamic SQL versus a huge IF structure
Comparing two tables