so user in this role can also create and drop tables using scripts ?

actualy i have a question about partitions, if have database with parition for every month, say if i load data for july 2010 in dev environment,can i just backup this...

my table does not have CI but it has NON-CI, so as to move the table I am creating a clustered index on my table and i will delete later...

does it mean all of these steps can be done without taking the database offline, could you please point me to any scripts which does this.

OK i have the partitions made based on year and if i delete paritions older than 10 years from it, does it have only that data i need after 10...

I am doing the steps as mentioned above using a t-sql and is working good but if i have to constantly update my dev databases with production, do you think...

Actullay i have backup from redgate software and they do provide extraction utility to get the back up in native mode and so i can restore all db's from prod...

could you please explain how you will create seperate data file fro each processor, i know how to create multiple data files but how would i allocate them for each...

shark, i agree with you but its turns out to bev ery diffucult to make them understand.

any comments on this topic ?

Paul

The definition very simple which consists of 53 columns with varchar(16) and 4 datetime fields and the row count is 345039256

Paul

HEre is the DDL you have asked and there are no reference keys. Please let me know if there is any fastest way to delete records.

CREATE DATABASE [RevBud] ON ...

Ok if i am doing a "select into " from a partition table and i think it will not create the same paritioned table and os i have to...

thank you guys i am going to try bulk insert now.

As asid above how do i do a BULK INSERT from table to table very fast, that sounds like a good approach.