T-SQL (Transact Structures Query Language) is an arrangement of programming extensions from Sybase and Microsoft that build on SQL.
Hi I need help with a small piece of code. I got a Stored procedure that is creating a staging table with a DIM and then inserts to a DIM table. The code drops tables and creates/inserts records. I need this to be incremental instead of drop/insert. I need an expert, this can be done in 2 hours. Thanks
I want to improve my English skills, especially listening and speaking skills, so I want to find a native person who is fluent in English to talk with me about many topics in the life, I believe that can help me improve myself in English and make more relation around the world.
In short: I need an expert to take a look at my database, to optimize its speed. He needs to a look at indexing/columnstore indexing and maybe converting scalar functions to Tabular functions. In particular I have a Store procedure that takes 1:30 (1 min 30 sec) to run. I need it to run in under 10 seconds. It returns Products/Accounts/QTY/Value etc... It may require better indexing of tables, the use of columnstore index converting functions etc... The main table has 225 000 rows, with 6 [url removed, login to view] main slowing part is the looking up the price of product at certain time period, as well as exchange rate. These are functions that take long to run, because they are Scalar functions. I general the person to apply for this project is required to be an expert in TSQL and sql server. the database is running in SQL 2016. I need this to finish with in 7 days.
Hi, I want someone with 7-8 years with MS SQL Server administration. Person should have really good experience with SSMS/SSIS/SSRS . he should be able to assist me with daily SQL DBA duties like Performance monitoring, troubleshooting issues related to SQL server, working on incident tickets, patching, upgrading etc. Person should have proficiency in TSQL. should know how to do scripting and create Stored procedures as well
This project is the conversion of Great Plains data into a format that can be imported into Workday. This project is about database changes related moving existing integrations from pointing from/to GP and out/into of Workday.