How to identify slow running queries in sql server 2008 työt

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). -------...

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Eminent Minds Technologies Pvt Ltd,( ISO 9001-2008 Certified Company)

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

server optimisation

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

The objective of this project is to address issues related to Facebook login functionality within our iOS mobile application. Currently, users are experiencing difficulties logging in via Facebook authentication. The project involves diagnosing the root cause of the problem and implementing necessary fixes to ensure seamless and reliable Facebook login experience for users. Key Tasks: Diagnosis of Existing Issues: Conduct thorough testing and analysis to identify the specific issues causing the Facebook login failure on the iOS app. Review Facebook SDK Integration: Evaluate the integration of Facebook SDK within the iOS app to ensure compliance with the latest SDK version and best practices. Address Authentication Errors: Implement nec...

I'm looking for a Java developer who's experienced with Spring framework to help me with a critical issue. The role-based security for the endpoints in my web application needs to be fixed. Key tasks: - Review the current role-based security implementation. - Identify any vulnerabilities or misconfigurations. - Fix any issues, and enhance the security measures. Ideal skills and experience for the job: - Strong Java programming skills. - Proficient in Spring framework. - Expertise in web application security. Your main goal will be to ensure the endpoints in the application are properly secured and only accessible to users with the correct roles.

Project Description: We are seeking a talented web developer to create a captivating landing page for our website. The landing page will serve as the entry point for our visitors and should effectively communicate our brand message while encouraging user engagement and conversions. Develop a visually appealing and user-friendly landing page that aligns with our brand identity and values. The design should be modern, clean, and responsive across all devices. Integrate compelling content, including text, images, and multimedia elements, to effectively communicate our products/services, features, and unique selling points. Implement clear and prominent calls-to-action (CTAs) strategically placed throughout the landing page to guide visitors towards desired acti...

**Project Overview:** We are seeking a professional video editor to create a dynamic and engaging 30-second video for social media. The video will feature the opening of a box of trading cards and will highlight the value of each card pulled to demonstrate the potential profit or loss from the initial purchase price of $140. **Objectives:** - Create an engaging 30-second video suitable for social media platforms. - Visually represent the starting cost of $140 on screen. - Highlight and count the value of each significant card pulled from the box. - Display the cumulative value towards the initial purchase price. - Conclude the video with the final profit or loss from the box. **Video Requirements:** 1. **Introduction:** - Start with a clear display of the initial purchas...

...specialist focusing on B2C audiences to enhance my product sales. Though I have an existing website, I don't need any website creation services from you. Key requirements and responsibilities for this project include: - Developing and implementing a robust digital marketing strategy tailored to a B2C audience - Conducting in-depth market research to identify and engage potential customers - Creating engaging and persuasive email campaigns to drive product purchases - Monitoring campaign performance and making data-driven adjustments to optimize results - Demonstrating a proven track record of successfully boosting product sales through digital and email marketing Ideal candidates will have: - Extensive experience in B2C digi...

I am in need of a highly skilled developer who can create a chatbot integrated with Zoho Desk for my employees. This chatbot will fulfill the major role of answering common FAQs. Given the type and nature of questions expected, an ideal candidate should: - Have experience in creating chatbots - Show familiarity with Zoho Desk API - Demonstrate ability to create bots that can answer technical support-related questions Understanding of the common issues faced in a technical support environment is a big plus, as the chatbot is intended to be primarily query-based. A well-defined and intelligent bot will not only improve our workflow but also help us resolve employee queries faster. That being said, I'm looking for someone who can deliver a ...

I am in need of a skilled WHMCS expert who can help me customize, develop modules, and troubleshoot on my WordPress website. Key Tasks: - WHMCS Customization: My website requires unique customization specific to my business needs. I need a professional who can tailor the WHMCS platform to meet these requirements. - WHMCS Module Development: I am looking to integrate certain functionalities into my WHMCS system via custom modules. The candidate should have a strong background in module development and understanding of WordPress. - WHMCS Troubleshooting: As with any system, there may be occasional issues that arise. A proactive and experienced troubleshooter will be needed to identify and rectify these quickly and effectively. Additional In...

I need a freelancer with an advanced research level of mathematics to assist in my project. The task involves understanding the relationship between Liouville theorems and universal estimates, and then applying scaling methods and Liouville results to identify blow-up rates in model parabolic problems. Key requirements and details include: - A deep understanding of advanced mathematical concepts, particularly in Liouville theorems and universal estimates - Proficiency in applying scaling methods and Liouville results for identifying blow-up rates in parabolic problems - Ability to work independently and efficiently on this task - Excellent communication skills to discuss and explain complex mathematical concepts in...

...looking for a seasoned WordPress expert to assist me with creating landing pages on my client's WordPress website. Background: I am a web designer with experience in several other platforms, but I have a client who has an existing Wordpress site they want me to add to. I have no experience with Wordpress and they have no phone support to answer some basic questions. I am willing to pay someone to answer those basic questions for me and get me up and running with Wordpress. That said, I have just started my own web design business and am starting to get more and more clients via word of mouth and social media advertising. At some point I will need help on many of these sites so if there is a good fit in t...

I'm currently seeking a skilled individual with extensive experience in invoice processing, vendor management and payment reconciliation to assist with our company's Accounts Payable tasks. Key Responsibilities: - Processing a high volume of invoices (over 500) monthly - Vendor management to ensure timely and accurate payments - Reconciliation of processed payments Ideal Skills and Experience: - Extensive experience in handling Accounts Payable in a high-volume setting - Proficiency in using Paragon EHR with the General Ledger software - Ability to catch up on considerable backlogs and bring our accounts current Please note, the right candidate needs to be able to hit the ground running, due to ...

...with NextAuth and Google: Integration with NextAuth to enable user login via Google. Secure OAuth2 authentication flow to ensure user data protection. User registration through Google account, streamlining the sign-up process. Account and Subscription Management: Each account can manage one school, which can have multiple locations (campuses). Admin dashboard to manage subscriptions and assign school management capabilities to each account. Ability to sell subscriptions, where each subscription corresponds to a single school with its own set of locations, teachers, and resources. Role-based access control: Admin Role: Full access to manage the school, including locations, teachers, classes, and schedules. Manager Role: Limited access ...

I'm in need of an experienced mechanical engineer with expertise in Finite Element Analysis (FEA) to perform structural analysis on frames and plates made of metals. This is specifically on 3D Models of Material Handling Attachments such as pallet forks and lifting jibs etc. Lifting Attachments must be engineered and approved before proceeding into manufacturing. Key requirements and tasks: - Conducting in-depth structural analysis on metal frames and plates to ensure durability and safety in my design. - Using FEA software to simulate stress distribution, deformation, and other relevant factors. - Providing detailed reports on the analysis results, including insights and recommendations for potential design improvements. Ideal skill...

...task will be to identify the most relevant and valuable keywords for my business, ensuring they align with my objectives and target audience. Key Responsibilities: - Conduct thorough research to identify high-traffic, low-competition keywords - Provide a detailed report of your findings, explaining your rationale and recommendations - Suggest targeted keywords for the optimization of my website content It's crucial that you have a deep understanding of SEO principles and the ability to deliver results under time pressure. Your expertise in keyword research and on-page optimization will be instrumental in enhancing my website's visibility and driving organic traffic. Skills and Experience: - Proven experience in SEO an...

I'm looking for a developer with Cordova expertise to help resolve a specific issue in my Android app. Key Responsibilities: - Troubleshoot and fix the issue of javascript making multiple server requests - Run through the build and identify other potential issues Requirements: - Strong experience with Cordova, especially with versions 10 or newer - Solid understanding of javascript and its behavior in Cordova environment - Ability to navigate and troubleshoot complex app codebases - Familiarity with identifying and resolving app build issues - Excellent communication skills and a collaborative mindset You'll be provided with: - Full access to the app's source code - Any additional information or resources you may need t...

...a professional to develop a compelling landing page designed to capture leads. We want 1 long form page and 1 short form page. The long form page will have approximately 5 sections on it. We can host on wordpress or receive HTML. This project requires: - An engaging landing page design optimized for lead capture - Creation of a contact form that collects more than just basic contact information, which includes name, email, and additional queries to gain insight into the lead - Conversion-optimized elements to entice visitors to fill out the form. Ideal candidates should have: - Proven experience in designing and building landing pages with the purpose of lead generation - Knowledge of conversion optimization techniques - Excellent ...

Project Details $30.00 – 250.00 USD I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship By Dat...

...expertise in building website as well as android and iOS apps • The scope of the work may increase as we learn more about the users of the website. • Please send your price quotations with detail of language/tools you will use and the timeframe you will need to complete this project. Functionalities to build: • Book meeting function that automatically check calendars of team members and shows available slots to external users to make booking with our experts - Admin can sync several calendars (of team member/experts) to one calendar booking form and the form will show availability for all the hours any of the linked expert calendars show available time. • Blog section - All type of Users can read, like, share on multiple so...

I'm seeking a skilled photographer with professional experience to capture images of an ad campaign I have running in Times Square. The project will take place on Friday, May 24th and the hired freelancer will need to provide their own photography equipment, model of the equipment is not important as long as it is professional-grade. Key Requirements: - Ability to capture high-quality images of billboard-type advertisements in an outdoor, urban setting, even possibly in crowd situations. - Flexibility to work within a specific time window on the specified date. The exact time will be provided to the freelancer we partner with. - Knowledge and adherence to the legal requirements and permissions related to p...

I am in need of a system to automate my Instagram cold outreach process. The main task to automate is finding potential leads. The system should ideally be able to identify potential leads based on the following criteria: - User interactions with specific posts - The follower count of Instagram accounts - The presence of specific hashtags or information in bio I am primarily looking for someone with extensive experience in social media automation, Instagram algorithms, and data analysis. Excellent coding skills would be beneficial. If you possess these skills and can help streamline my cold outreach process, please apply.

I'm in need of a detailed guide that helps individuals and businesses choose the right conference table for their office needs. The guide needs to cover the materials and styles that are suitable for different environments and purposes. Key deliverables include: - A breakdown of common materials used for conference tables (wood, glass, metal, etc.) - An outline of different styles available in the market (modern, traditional, etc.) - Recommendations on the best materials and styles based on the purpose of the table - A discussion on the importance of size in relation to the number of people the table should accommodate - Insights on how budget should influence the selection process -1000 to 1200 words - Will need to reference ...

...looking for a skilled web developer to create a unique, innovative one-page website for my new law firm. The website should integrate ChatGPT to provide simple legal advice on UAE laws and contracts in both Arabic and English. The goal is to create a smart, talk-worthy website that stands out and attracts attention for its intelligence and functionality. Project Requirements: 1. Design and Layout: - Clean, professional, and modern design. - User-friendly and easy navigation. - Mobile-responsive layout. - Incorporate elements that reflect the law firm's branding (colors, logo, etc.). - Ensure the website looks unique and innovative, with a focus on simplicity and smart design. 2. ChatGPT Integration: - Integrate ChatGPT to provide basic legal adv...

...meticulous professional, experienced in the workings of Microsoft Access 2007, to resolve manifold errors plaguing my software application. Key Responsibilities: - Fix syntax errors, making sure the coding within the system is coherent and functional - Solve data type mismatch errors, ensuring seamless data integration - Add some of the small functionalities to the application. - Need the full application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back ...

Se requiere un sistema diseñado en Python que trabaje en sistema operativo Wndows, el cual a través del uso del WebCam pueda hacer reconocimiento de rostros comparando el rostro en la cámara vs el rostro almacenado en formato digital en una base de datos en SQL Server 2016+. El resultados debe ser un True o False. El sistema debe trabajar localmente (No en la nube).

I'm in search of a skilled Flutter developer to assist with my startup project. Specifically, I need help with Flutter development to add additional logic to our running Chrome extension and Flutterflow. Requirements: - Intermediate level of experience with Flutter - Ability to assist with the development of the project - Willingness to work on repetitive tasks I expect to communicate updates and provide feedback through video calls, so please be comfortable with this mode of communication. If you're interested and your rate is less than $5 per hour, I'd love to hear from you.

I have a React Native Expo app that is connected to Supabase Auth and DB. The problem is that when the app is initially launched, the loading screen shows up but the data is not fetched. However, if I close the app and open it again, the data is successfully fetched. This issue is happening on both iOS and Android platforms. MUST JUMP ON ZOOM CALL SCREEN SHARE TO FIX ISSUE - The issue is only seen during the initial app launch - Specific logic for data fetching on app launch is implemented using useEffect hooks I need a React Native expert who can identify the root cause of this issue and provide a fix. The ideal candidate should have: - Strong experience with React Native - Prior experience with Supabase or similar databases - A deep understanding of useEffect hoo...

I'm looking for an expert in web development to tackle some critical issues and expand my website's functionality. The site currently has a few defects, needs extra features, and could use a facelift in certain areas. Here's what's been identified so far: - Broken links and slow loading speed - Incorrect information present across several pages These issues impact the user experience negatively, and I need them fixed. In addition to that, I wish to incorporate more options such as: - Adding a collection of posters for informational purposes - Enabling interactive forms for enhanced user engagement - Introducing a blog section to boost content Ideal candidates will have a solid background in web development...

I'm in search of a dynamic customer service team of 6-10 representatives to provide comprehensive support for my customers via phone, live chat, and email. An ideal candidate would possess strong communication skills and proficiency in the English language. Key Duties: - Provide phone support - Address customer queries via live chat - Respond to customer emails Skills and Experience: - Excellent verbal and written English - Proven experience in customer service - Ability to multitask across various support channels

Mevcutta hibrit bir uygulamamız var. Sql üzerinden veri çeken bir servis mevcut Bu projeye rapor eklenecek

I am in need of an experienced Node.js developer to assist with a critical bug within my back-end code. This is a quick, 5-minute task for the right professional. Key Responsibilities: - Identify the root cause of the bug in the back-end code - Implement a fix that ensures correct functionality post-resolution Requirements: - Strong experience in Node.js - Proven track record in bug fixing - Ability to work swiftly and independently This task is essential to the correct functionality of my application and its timely resolution is of utmost importance. Thank you for your interest.

I'm seeking an Online Business Management professional specifically skilled in inventory management and online business start-up support. Roles and Responsibilities: Help in adding our business to e-commerce websites like amazon flipkart,.... • Providing support for the setup and management of an online business. Key Requirements: • Ability to integrate the inventory with e-commerce platforms seamlessly. • Proven track record of successful online business support and set up. As a freelancer, you'll have firsthand experience in launching and running an online business, coupled with a mastery of efficient inventory management on an e-commerce platform.

I am looking for a proficient freelancer to undertake CV screening focused on technical skills. The ideal candidate will have: - The ability to verify competence in the domains of Programming, Network Management, and Data Analysis. - An excellent understanding of these areas to an intermediate level so you can correctly identify them in CVs. Your communication skills should be top-notch to allow smooth interaction. Also, your educational background in a technology-related field will be advantageous. Your role will be to screen through CVs and identify candidates that meet the required technical criteria to proceed to the next round of our hiring process. Your accuracy and precision would be greatly appr...

...knack for making informative how-to/tutorial videos or are you more interest in comparing videos? If so, we have an amazing opportunity for you to join our team and showcase your talents on our established YouTube channel. We're looking for individuals who can create engaging step-by-step tutorials for software, apps, and email marketing tools. Please note, these are not animated explainer videos; we require screen recordings. Requirements: - Proficiency in English (native speakers preferred) - Willingness to record your phone/computer screen, along with your voice - Ability to explain concepts clearly and concisely - Access to a high-quality microphone I'm looking for someone that: - That's able to work w...

I am in need of a PHP Laravel expert to address a couple of issues in my current project. - The main concern is a button in the frontend that's unresponsive when clicked. There is no error message or action, it simply doesn't function as intended. This requires a deep dive into the code to identify the cause and provide a solution. - Additionally, I've encountered some crashes that occur during specific actions within the application. These crashes are intermittent and do not happen randomly or during startup. Resolving these issues is crucial to ensure the stability and usability of the application. The ideal freelancer for this project should have: - Extensive experience with PHP Laravel and a strong understanding of back...

I'm in need of a keen researcher who can delve into a provided spreadsheet of businesses for analysis. The data is varied and comprehensive, including but not limited to customer demographics, product descriptions, and pricing information. This is exclusively a RESEARCH project, and will take some time. Because of this I WILL ONLY PAY HOURLY. If you require a fixed price/contract, do not bid, I will not give you the job. Key Responsibilities: - Thoroughly examine the provided businesses in the spreadsheet - Extract and analyze various attributes, such as customer demographics, product descriptions, and pricing information - Summarize and present the information in a clear, concise manner - Provide suggestions on the potential opportunities or challenges ba...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I'm looking for a professional who can help me generate contact information (name, email,...email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriented, with the ability to deliv...

I'm in need of an expert server administrator with extensive experience in Plesk to assist with the configuration and troubleshooting of my server. Key Responsibilities: - Server Setup and Configuration: The server is already fully configured, but I'm facing some severe issues. Your role would be to assess the current setup, make necessary adjustments and ensure that the server is running optimally. - Troubleshooting: The primary issue I'm experiencing is a DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#' (Errcode: 2), query was: DESCRIBE `sessions`. Your expertise in diagnosing and resolving such issues will be crucial. Skills and Ex...

I'm looking for a skilled professional to update my current Prestashop platform from version 1.7.7.2 to the latest version 1.7.8.11. As I have custom themes installed, it's crucial to ensure that all of them are compatible and functioning correctly post-update. Additionally, I need all existing bugs that may arise from the update to be identified and fixed to ensure a seamless user experience. Key Tasks: - Update Prestashop from 1.7.7.2 to 1.7.8.11 - Ensure compatibility of existing custom themes with the new version - Identify and fix any bugs or issues that arise post-update Expectations: - The updated platform should be fully functional and all existing custom themes should work as intended - Any bugs or issues should be reso...