sql stored procedure to drop indexes and rebuild them on differnet filegroup

$30-250 USD

Completed

Posted

about 10 years ago

$30-250 USD

Paid on delivery

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

SQL

Project ID: 5764035

About the project

3 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@expertcoder1vw

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 in 0 day

5.0

(19 reviews)

5.2

3 freelancers are bidding on average $178 USD for this job

@kchg

Hi i am interesting with your project. i am very skillful with your project. i can do it well. thank you.

$257 USD in 3 days

4.7

(5 reviews)

3.3

@manohartvs

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!

$111 USD in 3 days

4.9

(2 reviews)

2.5

@nksundaram

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.

$166 USD in 1 day