Fix SQL Table problem

£10-20 GBP

I përfunduar

Postuar

over 2 years ago

£10-20 GBP

Paguhet në dorëzim

I have an MSSQL database on Azure. I am unable to change a table due to the following error. Warning: The table "matter" has been created, but its maximum row size exceeds the allowed maximum of 8060 bytes. INSERT or UPDATE to this table will fail if the resulting row exceeds the size limit. Msg 511, Level 16, State 1, Line 1 Cannot create a row of size 8069 which is greater than the allowable maximum row size of 8060. The statement has been terminated. I have tries to reduce the size of the row by reducing fixed field sizes but it will not run any of the alter table commands. There are many fields I can reduce the size of if I can get past this error. Happy to provide connection details. Please let me know that you understand the issue and the fix when bidding.

Microsoft SQL Server

SQL

Database Administration

ID e Projektit: 31429037

Rreth projektit

9 propozime

Projekt në distancë

Aktive 3 yrs ago

Po kërkoni të fitoni para?

Adresa e email-it

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj

Paguhuni për punën tuaj

Përshkruani propozimin tuaj

Është falas të regjistrohesh dhe të bësh oferta për punë

I dhënë për:

@ShafirR

£0 GBP në 1 ditë

5,0

(82 përshtypje)

6,4

9 freelancers are bidding on average £28 GBP for this job

@AliSafder

Hi, I can work with SQL Server to Fix Table size issue. I have over 14 years of expertise in SQL Server and DotNet. Let me know when I can connect to the system. Regards, Muhammad Ali Safder

£15 GBP në 7 ditë

5,0

(44 përshtypje)

5,2

@micrologixsl

Greetings, Will fix the lock and table index restrictions, kindly provide mea clone of the same dB, will replicate it to production after the fix, do there your test cases for validation criteria. Best, Dawood

£29 GBP në 7 ditë

5,0

(3 përshtypje)

3,9

@SPARKtechBD

Since 2010 I am working on SQL database systems on MSSQL, Azure SQL or MySQL and ER diagram to design and build database systems. So more than 10(ten) years of experience in SQL. If you want a good delivery of work, then message me, please.

£50 GBP në 1 ditë

4,9

(8 përshtypje)

3,4

@Nittin

Hi, My Name is Nittin. I have near around 14 years of experience as developer. I worked on the multiple technology Asp.net, MVC, Sql Server. Currently I am working in Angular 9 along with .Net core Web API. I am very interested in this job and Please check my profile and let me know if you need more information. I have near around 5+ Years of experience. Please let me know if we can do the more discussion on this. Regards Nittin

£15 GBP në 1 ditë

5,0

(2 përshtypje)

1,0

@ramtech005

Hi there! This is Aniket Hope you are doing well. I’ve read your brief carefully . So i can do this as you want. As i have 10+ years of experience in this field .So contact me if you really want to make this best. I have worked on several similar projects compiling presentation slides and lecture notes into a single set of notes, and can deliver quality notes to tight deadlines. I have not attached my work due to copy paste issues. I have all the skills you have mentioned in the project. My portfolio is here: https://www.freelancer.com/u/ramtech005 I'm interested to hear more about the project and about the subject matter of the lectures. I am expert on: Php | asp dot net | node js | angular js | iconic | react native | shopify | open cart | wordpress | Laravel | Share point | API integration | HTML5 | Website Design | Graphic Design | Advance Photoshop | Logo Designs | UX/UI Design | E-commerce | Woo commerce | Game Development | Utility Development. I am also work on Content Writing| Digital marketing (seo). » Ready to Start as Immediate: Unlimited Revisions & Proper Testing » Keep your Data & Website Secure: Daily Progress Updates We have thousands of satisfied clients in worldwide; I hope you will be next. We give you 6 month maintenance free also. If you award me the project I'd be very happy to discuss this further and get started for you as soon as possible. Thanks! Aniket

£15 GBP në 7 ditë