Debug MS SQL Server partitioning implementation

$30-250 USD

In Progress

Posted

over 9 years ago

$30-250 USD

Paid on delivery

I have a table partitioning and switching pattern I think to be solid, but I get this exception at a point: ALTER TABLE SWITCH statement failed. index 'NVR.dbo.StagingImages_201409101920FGLR.StagingImages_201409101920FGLR_PK_ImagesLongRunning' is in filegroup '201409101920FGLR' and partition 156 of index 'NVR.dbo.ImagesLongRunning.PK_ImagesLongRunning' is in filegroup '201409101930FGLR'. I need help debugging my implementation. You must have a solid, experienced understanding of partition switching! Do not bid this job and then decide you will research how this works and get it to work after the fact unless you are a genius!

Microsoft SQL Server

SQL

Project ID: 6586586

About the project

5 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

5 freelancers are bidding on average $239 USD for this job

@sikandermandal

Dear Sir, This is Sikander. I am having 12+ years of experience in software development and I am ready to start this job. I will provide you best services in development. Please have a look at my Profile, Ratings and feedback. I am working in Microsoft technologies and you can find the details below. My Skills includes: 1) .Net (Web/Windows) asp.net 2) MVC 3) Entity Framework 4) WPF/WinForms 5) MSSQL Server 6) SQL Server Reporting Services 7) Javascript/JQuery 8) WebServices/WCF Services 9) MySQL 10) Hosting Sites 11) Mailchimp 12) Recently Worked on Vending Machine solution with Monetary apparatus and Shipping Goods motor also worked on Kisok applicaiton. many more...... I have no fancy talks, no false promises and nothing to hide but honesty and a great will to expand our work experience. I am willing to expand my work experience to different clients and in this order I apply for this job in the hope to hear some positive response from you. I hope you will take us positively and will give us a chance to work with you. Many Thanks & Regards Sikander

$250 USD in 10 days

4.7

(13 reviews)

5.2

@ranjithjms

Hi, I'm a certified SQL Server Database architect[MCP, MCDBA, MCTS, MCITP] with 13+ Years of experience in SQL Server database administration and development, and I'm very interested in your job post involving these skills.

$250 USD in 10 days