You've landed at the right place. oDesk is now Upwork. Learn about the new platform.

T Sql Jobs

7 were found based on your criteria {{ paging.total | number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("hourly") | number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("fixed") | number:0}})
show all
only
only
only
show all
only
only
only
only
only
show all
only
only
only
Looking for the Team App?
Download the New Upwork Team App
Fixed-Price - Entry Level ($) - Est. Budget: $60 - Posted
We have a data process which we have transitioned to SQL Server 2012 Express, which we would like a designer/coder to update to allow for increased functionality, while producing the same output (i.e. incorporation of an additional mapping/parameter table). We will provide the current Stored Procedures and sample data, along with a background on the proposed changes.
Skills: Transact-SQL Microsoft SQL Server Programming
Fixed-Price - Expert ($$$) - Est. Budget: $20 - Posted
set @backup_Query= 'backup database ['+ @databaseName + '] to disk = N''' + @backupPath + '\' + @DatabaseName + '.bak'' WITH RETAINDAYS =7 , COMPRESSION' I have this script from the store procedure that run nightly. Only Problem is that it appends to the backup. The backup file grow so large upto 102GB, but the database size is 748MB and it compresses to 458MB. I have limited storage. If I have use INT code then it will overwrite the database and database wouldnt be that larger. My thought is that I would like to keep retaindays up to 7 days only and it should keep adding up to the database whenever the backup job runs (which is appending) only up to 7 days but the problem is that it does not delete the old retain backup and it’s just keep on adding to the backup file. How do I fix the problem? I looked into the Ola scripts. Apparently I heard so many good things about it. I want to apply this script to the entire instance. Or any other suggestion would be better? Budget that I thought of is around $20 or offer me
Skills: Transact-SQL dBase Administration SQL SQL Programming
Looking for the Team App?
Download the New Upwork Team App
Fixed Price Budget - ${{ job.amount.amount | number:0 }} to ${{ job.maxAmount.amount | number:0 }} Fixed-Price - Est. Budget: ${{ job.amount.amount | number:0 }} Open to Suggestion Hourly - Est. Time: {{ [job.duration, job.engagement].join(', ') }} - Posted
Skills: {{ skill.prettyName }}
Looking for the Team App?
Download the New Upwork Team App