sql stored procedure to drop indexes and rebuild them on differnet filegroup
$30-250 USD
Ukończony
Opublikowano około 10 lat temu
$30-250 USD
Płatne przy odbiorze
I have database with a 2 tables and about 25 indexes. I need a stored procedure that will drop all the indexes and re-create them in a different filegroup within the same database. I will provide the schema for the tables and the names of indexes that need to be re-created.
the stored procedure should take databasename, tablename and new filegroup as parameters. The list of indexes can be hard-coded in the stored procedure itself.
I would like this to be complete tomorrow no Saturday 9AM GMT if possible
I'm an expert T-SQL developer and can do this job for you professionally and can deliver in 12 hrs or less.
Thanks for considering my bid.
Bests,
Larry
$147 USD w 0 dzień
5,0 (19 opinii)
5,2
5,2
3 freelancerzy składają oferty o średniej wysokości $178 USD dla tej pracy
Hi There,
I am very experienced in SQL Server and can create a stored proc for you without any trouble.
Please contact me via messages if you wish to discuss any specifics. Your timeline works just fine for me as it is daytime for me here in Sydney!
Experienced software developer with 20 years in design, development and maintenance of applications. From your description I understand that you are using SQL Server. Which version of SQL Server are you using? It is possible to get create the indexes without hard-coding in the SP.