Performance tuning in sql server step by stepdela

Avto tuning gasfafsaf ffasadsa

- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark

Potrebujemo programerja za občasne dodelave v okolju Microsoft dynamics CRM, office 365 z bazo Microsoft SQL. Plačamo po urnih postavkah.

Izdelava aplikacija (za začetek working verzija - brez avtomatskih in EndToEnd testov) za prikaz: -Drevesnih struktur iz sql tabel -Logiranje -Shranjevanje aktivnosti na drevesnih strukturah -Poročila -Komunikacija med uporabniki Več v priloženem PDFju. Gre za osebni projekt - ne predstavljam podjetja.

I need an experienced website developer l who can help me with a few tasks relating to my newly migrated website. Key Requirements: - Optimizing the speed of my website. - Optimising SEO for local market (Australia) - Implementing 301 Permane...Requirements: - Optimizing the speed of my website. - Optimising SEO for local market (Australia) - Implementing 301 Permanent Redirects where necessary, to maintain SEO and direct users to the correct pages - Provide suggestions on any other enhancements to my website performance Ideal Skills: - Proficient in website optimization techniques and tools. - Experienced in implementing 301 Permanent Redirects. - Knowledgeable about SEO and website analytics. - Able to communicate effectively and work collaboratively. Must be c...

I'm in need of an experienced Linux programmer to update my current SMTP server code and add new routines. Key requirements: - Revise and improve the sending efficiency of the server - Add new functionalities to the existing code The ideal freelancer for this project should be well-versed in Linux programming and have a solid understanding of SMTP server architecture. Your proposal should include a detailed plan on how you aim to achieve the project requirements.

...an "Internal Server Error" on my Apache server and urgently require professional assistance to resolve it. Unfortunately, I do not have specific fixes in mind but it could potentially involve tasks such as updating the .htaccess file, modifying the Apache configuration file or adjusting permissions for my web directory. This job demands expertise in Apache server maintenance and problem-solving skills as it needs to be completed as soon as possible. Familiarity with best practices for handling server errors would also be ideal. This is the error: In the error log it states that the PHP script did not return a valid set of HTTP headers before the script finished execution. Upon checking the fpm logs I noticed the error, "[1...

I'm looking for an experienced QA Automation Engineer for solving some issues we have in a complex Jmeter script which we are using in our performance/load tests. This is a 1 week job at most and payment will be fixed at $500. Our JMeter script is not a simple one, so if you are not a real expert in JMeter please do not apply. You will fail to do the project. If you are an expert using JMeter for really complex projects, please apply by simply answering the below questions: 1- Tell us why you consider yourself a JMeter expert. 2- What were the most complex 2 projects that you did JMeter tests for and what made them complex. Please type "I can do it" at top of your reply so that I know you actually read the description.

I am seeking an SEO expert with a proven track record in improving search engine rankings, specifically for businesses within the construction industry. Key responsibilities: - Research, identify, and implement proven SEO strategies - Analyze performance metrics and adjust strategies as necessary - Provide reports on a monthly basis to show progress made Ideal Skills & Experience: - Proven experience in SEO and digital marketing - Expertise in keyword research and SEO optimization for construction services - Track record of improving search engine rankings

I'm in need of a mechanical engineer with experience in calculating load capacities for scissor lifts. The primary material of the lift is steel and the analysis requires consideration of both static and dynamic loads. Key responsibilities: - Conduct load capacity calculations for a steel-based scissor lift - Analyze and consider both static and dynamic loads - Ensure the lift meets safety and performance standards Ideal skills and experience: - Proficiency in mechanical engineering and load capacity calculations - Experience working with scissor lift or similar heavy machinery - Solid knowledge of steel properties and how it affects load capacity - Ability to analyze both static and dynamic loads for safety and performance compliance. Please pr...

I am searching for ...my LED lights. The primary goal of this task is to increase sales. With a budget of less than $100, creativity and efficiency will be key. Ideal Candidate Skills: - Proven experience in B2B marketing, ideally in the LED lighting or related sector. - Demonstrable track record in optimizing marketing campaigns to boost sales. - Ability to be resourceful and innovative on a lean budget. Your responsibilities will include: - Creating and implementing a compelling marketing strategy aimed at businesses. - Utilizing efficient marketing methods to sustain the budget. - Regular reporting on campaign performance, sales increase, and cost-effectiveness. Please provide examples of your previous work, particularly any similar B2B marketing campaig...

I'm looking for an expert with a strong PHP background to perform an extensive redesign of all pages of my existing website. The project involves: 1. Layout Redesign: The task requires a full redesign of both the homepage and c...Modification: Some content sections need adjustments. Changes will range from removal, addition, or rearrangement. Details will be provided during the project's commencement. Ideal candidates should have strong UX/UI design skills, experience in PHP web development, and a keen eye for detail. Strong communication skills are essential, as I expect regular updates on project progression. Show me your previous redesign projects to showcase your capability. A successful outcome will potentially lead to further work on adding new features and improvi...

I'm in need of a skilled developer who is proficient in a variety of programming languages and can work on two key areas of my website. - Basket Feature Integration: The first task involves adding a basket feature to the site. The feature should incorporate the ability to both add and subtract items, and should clearly display the total cost of the items in the basket. Additionally, the basket should be designed to support Stripe payment integration so when when paying total cost will be on stripe showing the products. - Registration Redirection Fix: The second task is addressing a critical issue with the registration process. Currently, upon successful registration, the user remains on the registration page. This is not the intended behavior, and I need a solu...

I'm currently experiencing a peculiar issue on my CentOS server. The process /usr/sbin/mariadbd is showing 109% CPU usage in the WHM task manager, although the server load is stable and I haven't made any recent changes. Your primary task would be to diagnose and resolve this problem. No error messages or warning signs have appeared, making the source of the issue somewhat inscrutable. Access will be provided via AnyDesk or a remote desktop connection for swift and efficient troubleshooting. Your expertise in the following areas would be invaluable: - Proficiency in CentOS server administration - Expertise in WHM and server task management - Experience in identifying and resolving high CPU usage issues - Strong ...

I am currently facing an issue with my website - when a user registers on the site, instead of being redirected to their profile page ...redirected to their profile page or login page, the system keeps them on the same page. Furthermore, upon this failure to redirect, it shows it is successful when registering but doesn't take to another page. I need someone with strong proficiency in HTML, CSS, JavaScript, PHP, and SQL to diagnose the problem and implement a solution so that after successful registration, users are seamlessly taken to their profile page. The ideal candidate should have: - Significant experience in PHP, HTML, CSS, JavaScript, and SQL. - Proven track record in troubleshooting and rectifying website issues. - Firm understanding of ...

I am looking to get a complete SEO overhaul for my website. Currently, the site is experiencing low traffic and poor performance. I believe my website can benefit from a broad spectrum approach to SEO, encompassing the following skills: - Keyword Optimization: The ideal candidate will have a proven track record of identifying highly effective keywords tailored to my website's content. - On-page Optimization: This includes, but is not limited to, proper title tags, meta descriptions, and URL structure. Experience in improving these aspects to boost website visibility is a must. - Link Building: I am looking for someone who can effectively create a strong inbound link profile for my website which can influence and boost its visibility on search engine result pages. The...

...are best understood by those well-versed in Simulink. Leveraging your knowledge, I need assistance in modeling simulation, establishing an effective control system design, and performing signal processing. Key responsibilities: - Build a model simulation - Design a stringent control system - Perform signal processing Although the specific task was not clarified, I value a freelancer who can dynamically adjust to the task at hand. Hence, your application should highlight your past work, experience, and a detailed project proposal–these are essential components to your success in this project. The ideal freelancer should display: - Excellent knowledge of Simulink - Previous experience in model simulation, control system design, and signal p...

I'm seeking a capable Shopify expert to address issues with slow page loading t...slow page loading times and a high bounce rate on my web store. Despite prior attempts to improve performance, the issue remains unabated, particularly on the homepage. The ideal consultant for this project will: - Have a strong understanding and experience in Shopify speed optimization - Be able to identify and resolve issues causing slow page load times - Recommend and implement ways to improve bounce rate - Conduct necessary adjustments and interventions specifically on the homepage The ultimate aim of this project is to significantly enhance user experience and consequently increase my site’s conversion rates. I am specifically interested in professionals who have had...

I'm seeking a proficient WordPress developer for my upcoming project. Here's a brief of the project: - I need a WordPress website that's user-friendly and functional. - The website should be optimized for performance and SEO. - You're expected to deliver a clean, well-commented code. Ideal skills and experience for this project: - Previous experience in WordPress development. - Familiarity with e-commerce and blogging functionality. - Proficiency in custom design is a plus. - Knowledge of SEO optimization. - Strong attention to detail and ability to deliver on time.

I need a professional with extensive experience in Fuzzy Logic and Matlab. Since I haven't defined the exact task or domain, I anticipate your ability to tackle various applications ranging from control system design, pattern recognition, forecasting, robotics, financial analysis, to traffic control. The final output, yet to be specified, could be anything from improved system performance, enhanced decision-making, or better data analysis. Since the assignment specifics are yet to determined, I require someone who is flexible, creative, and solutions-oriented. Matlab proficiency is a must.

I'm in need of a skilled Power Apps developer to create a custom business application with the following features: - Image Capture and Upload: The primary function of the app is to allow users to take pictures using their device's camera. - Integration with OneDrive: The images taken should be uploaded directly to a specific folder in OneDrive. - 4 Different Upload Buttons: I'd like the app to have 4 distinct buttons, each triggering the camera function on the end user's phone for specific image captures. here's a complete step-by-step guide with all the necessary Power Fx code for implementing a camera feature where the camera is triggered by an "Upload" button for each document section. Step 1: Initial...

I'm looking to revamp my website to provide a better user experience and improve its overall performance. Key Changes: - **Design Update**: I want to change my website's color scheme and improve navigation. This might involve tweaking fonts, colors, and overall layout to create a more engaging and intuitive experience. - **Navigation Improvements**: I'm particularly interested in enhancing the mobile responsiveness and ensuring my bio is prominently displayed with a matching photograph. Ideal Freelancer: - Experienced web designer with a strong portfolio showcasing previous design and performance enhancements. - Proficiency in user experience and mobile responsiveness. - Familiarity with content management systems like WordPress is a plus.

...Stratum v2 protocol to ensure peak mining performance. The specific programming languages used for the current implementation are unknown as the previous question was skipped. In terms of hardware, my setup currently includes Windows and GPU. Thus, the successful freelancer should have experience working with these specifications and will consider this in the implementation process. The ideal freelancer should have an extensive background in Stratum v2 protocol, have efficient problem-solving skills, as well as have a competent understanding of mining software integration and optimization. Experience in working with Windows and GPU hardware is also a major plus. IN YOUR RESPONSE LEASE include - (1) how have you configured and set-up "...

I am looking for assistance in optimizing battery performance through Matlab simulation. Due to the project specifics not being clarified, the professional should be comfortable and experienced in working with a range of battery types such as Lithium-ion, Lead-acid battery and Nickel-metal hydride batteries. Key points to consider for this project: Skills and Experience • Understanding and experience in working with various battery types • Proficiency in Matlab for creating simulations and testing • Strong analytical modeling skills Project Objectives • Provide research and suggestions on optimizing battery life, decreasing charging time and improving power output. • Develop a comprehensive Matlab model suit...

...project that requires expertise in telecommunications, specifically in designing point to point communication systems like simplex, duplex, using radio as the communication type. To see this project to its fruition, I will need a professional who can design a communication link with various parameters. Thereafter, we'll need to carry out Link-level modeling and simulations in Matlab. The ideal candidate should: - Have a solid understanding of point to point communication systems, specifically both simplex and duplex systems. - Be proficient in using MATLAB for simulations. Following the simulation, we'll analyze the performance of our designed system using several metrics. For the simplex system, we would be interested in assessing...

I'm seeking a specialised CodeIgnitor and phpMyAdmin expert to enhance my betting website's backend. As part of a 5-hour daily commitment, the role involves: - Integrating a UPI payment gateway in the admin panel. I've chosen Google Pay as the preferred UPI platform. - Setting up data analytics and reporting, crucial for measuring and optimizing our betting system's performance. Prior experience with betting sites, UPI integrations and systems reporting is desirable. If you're a driven problem solver who enjoys developing sophisticated functionalities, I'd love to hear from you.

I a...recently conducted a performance test on my website, and the results were less than ideal; only scoring 33%. The main problems I've identified include: - Broken links - Page loading issues - Mobile responsiveness problems Additionally, I am looking for a some redesign of the website to provide a better user experience. I would like the following improvements in UX and UI: - Clear and intuitive navigation - Consistent branding and visual identity - Responsive design for mobile devices The target audience for my website is general consumers. Ideal skills and experience for this job include: - Proficiency in WordPress development - Strong background in UX and UI design - Knowledge of website performance optimization - Experience in rede...

I'm in need of a skilled Machine Learning Engineer who can develop modules to help analyze the real-time electricity consumption for a variety of devices in our system. Backend: Key Points: - Devices to be analyzed include air conditioners, lights, and simple motors and other simple devices. - The analysis should cover both the collective consumption of groups of devices and the individual consumption patterns of each device. Ideal Experience: - Strong background in Machine Learning, ideally with experience in real-time data analysis. - Previous work in energy consumption analysis or similar fields would be a huge plus. - Proven track record in developing ML models for group and individual level analysis. The ML analysis we are looking ...

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

...of my WordPress website. This is exacerbated by high server resource usage and poor caching and optimization. More worryingly, I'm dealing with an excessively large Document Object Model (DOM) that further hinders the performance of my site. However, I'm unable to pinpoint specific issues caused by this. I require a skilled professional with in-depth knowledge of WordPress performance optimization to address these problems. The right person should be able to streamline my site for faster loading speed and lower server resource usage. They should also have experience in proper site caching and optimization, and have technical know-how to handle DOM size reduction and enhancements, making the site more efficient overall. ...

I need an expert in SQL Server Report Builder 3.0 to help rejuvenate some lab reports. I require some amendments to be made to the current reports I have. Key Tasks: - Altering the way data is presented within the reports - Incorporating new fields to the current reports In the end, I need the same data results but with improved visibility and understanding. Ideal Skills: - Appropriate familiarity with SQL Server Report Builder 3.0 - Strong grasp of data visualization principles - Detail-oriented and precise to ensure report data remains accurate. Individuals that can deliver these changes precisely and quickly are highly preferred.

I am looking for a skilled freelancer who has extensive experience in managing ads on both Google and Facebook. The main goal of this project is to increase the traffic to my website, focusing on professionals aged between 35-54 years. The ideal candidate for this job should have: - Proven experience in managing Google and Facebook ad campaigns - A track record of achieving the goal of increased website traffic - A deep understanding of the professional demographic on these platforms - Excellent analytical skills to monitor and optimize the campaign's performance Please provide examples of your previous successful campaigns and details of how you plan to execute this project.

...analyst to support me in improving my business operations through a data-driven approach. The project will involve tackling tasks across data cleaning, statistical analysis, and data structuring and algorithm implementation. Ideal Skills and Experience: - Proficiency in data cleaning and preprocessing to ensure that the data is in its most usable, accurate, and complete state. - Strong statistical analysis and modeling skills to extract meaningful insights and make accurate predictions. - Excellent experience in structuring data and implementing algorithms that are tailored to business needs. Data Sources: - Social Media Data: You should be comfortable working with a variety of social media platforms to extract relevant data and insights. - Sales and Financ...

Looking for an experienced developer to create a cross-platform Juce VST3 plugin scanner. This tool should be compatible with W...be a standalone application and have a custom theme that we can discuss. Skills and Experience: - Extensive experience with C++ and Juce framework is a must. - Prior work on creating VST3 plugins or scanners is highly desired. - Familiarity with plugin detection and organizing algorithms. - Experience in creating cross-platform applications and ensuring consistent performance across Windows and macOS. Ideal candidates should have a good understanding of audio plugins in general and VST3 in particular. The ability to create an efficient and user-friendly interface is also important. Good communication skills and the ability to work w...

I'm searching for an experie...the site's content. These updates need to be made on a monthly basis. - Security monitoring: Ensuring the website is secure and protected from any potential threats. Previous experience in securing WordPress websites is a plus. - Performance optimization: Improving the site's performance and ensuring it runs smoothly. This may involve tasks such as image optimization, code cleanup, etc. Ideal Skills: - Proven experience with WordPress website maintenance - Proficiency in handling regular content updates - Strong background in security monitoring for WordPress websites - Demonstrable experience in performance optimization I'm looking for someone who can commit to this role on a monthly bas...

...seeking a skilled influencer to market music to teenagers and young adults. We want to leverage an influencers audience to introduce a new and upcoming female pop artist. We want the influencer to be present in the content as well. Key Responsibilities: * develop short performance clips and music video teasers on Facebook and Instagram to promote music to core demographic. Requirements: * Expertise in leveraging social media for marketing * Background in music/ promotion is an advantage * Strong understanding of content marketing to teenagers and young adults * Experienced in creating engaging content that will captivate our audience. Creativity and originality, along with a passion for music and a solid understanding of online promotion tac...

I am in urgent need of a resourceful and detail-oriented expert to assist me with a specific image file editing task. This project involves fine-tuning the content of the image, requiring text editing and relocation of already existing graphic elements within the image. The ideal candidate: - Should be skilled in image editing, detail-oriented, and should have a strong grasp of image editing tools. - Should have demonstrated experience with editing text within images and rearranging graphic elements. - Needs to be careful not to distort the image or misalign the graphic elements during the editing process. Please bid only if you have the required experience and skills and can deliver high-quality results in a timely manner.

I'm in need of a freelancer skilled in Windows server administration and virtualization technology, specifically VMware. Your task will be to set up a VPN server on my existing Windows virtual machine. Key tasks include: - Installing and configuring OpenVPN on the Windows server - Ensuring the VPN setup is secure and functions properly You should have deep knowledge and experience with Windows Server, VMware, and OpenVPN protocols. I'm expecting the project to be done efficiently and timeously without compromising on the server's security measures.

I am seeking a skilled Network Administrator to convert my computer into a gaming server. My interest lies in hosting multiplayer strategy games, therefore, the professional should have a strong understanding of server setup specific to these game types. Important considerations for this project are: - Support for multiple game sessions running concurrently. - Capable of handling a maximum of 50 concurrent players. The ideal candidate will demonstrate proven experience in similar projects and possess detailed knowledge in network administration, particularly in gaming server setups. Please express your expertise in your bid proposal.

I'm looking for a skilled DevOps Engineer experienced in AWS to help design a robust architecture for my Spark and Sagemaker Machine Learning models. Key Requirements: - **AWS Services**: Your primary focus will be on utilizing Amazon S3 and Amazon Sagemaker effectively within the architecture. - **Programming Languages**: Familiarity with both Python and R is important, given that my models are built in those languages. - **Model Operations**: Your design should focus on enabling batch predictions and facilitate model training and retraining for the Machine Learning models. Ideal Skills: - Experience with Amazon S3 and Amazon Sagemaker are a must. - Proficiency in Python and R for fine-tuning or troubleshooting the models. - Familiarity with designing ar...

We are seeking a motivat...Intern to join our team. This is an excellent opportunity for someone who is passionate about digital marketing and eager to gain hands-on experience in search engine optimization. Responsibilities: Assist in keyword research and analysis to identify new opportunities for content optimization Help optimize website content, including writing meta tags, meta descriptions, and optimizing on-page elements Support link building efforts by researching and identifying potential link opportunities Monitor and report on website performance using tools such as Google Analytics and Google Search Console Stay up-to-date with the latest trends and best practices in SEO and digital marketing Collaborate with team members on various SEO init...

I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.

I'm seeking an experienced social media manager specializing in Facebook and Instagram platforms. The ideal candidate should have exemplary content creation skills to help me build a strong online presence. • Social Media Platforms: The focus will be on Facebook and Instagram. Your role involves creating rich content that resonates with our audience, increases our followers and boosts engagement levels. • Posting Frequency: Posts should be made three times a week. You will need to schedule these posts for optimal engagement. • Content Creation: I require original content created. You should be adept at crafting engaging posts that align with our brand voice and ethos. Proficiency in using various social media tools for graphics and video creation is a ...

I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.

I urgently need a C++ developer to assist in expanding my project. Your task will be to implement a unique feature which requires capturing low-level screenshots directly from the GPU. The key responsibilities include: - Developing a new, specialized feature that captures and handles GPU screenshots. - Ensuring the smooth and efficient performance of this new feature. It's beneficial if you have prior experience with similar GPU-related tasks and a solid understanding of C++ programming, API integrations, and screenshot capture techniques. Please bid now if you believe you have the skills and can deliver swiftly.

Perform an in-depth sensitivity analysis of a Pressure Swing Adsorption (PSA) process for CO2 capture using zeolite 13X. Scale up a CO2 capture system from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis ...

...customization: I need distinct color scheme, font style, and layout tweaks to give the app a unique look and feel. - Server setup: I require load balancing, security protocols, and scalability options to ensure the app's performance and security. - Feature enhancements: The app should include payment integration, transaction history, and promotions/discounts features. - UI/UX improvements: I need assistance in redesigning the user interface to ensure a seamless, intuitive user experience. Ideal candidate for this project should have: - Proven experience in mobile app development, particularly with wallet applications. - Strong design skills for UI/UX enhancements. - Expertise in server configuration and management. - Excellent understandin...

I'm in need of an experienced web developer to create an interactive multiple choice exam website. This platform is intended to be a valuable resource for both educators and students alike. Key Features: - Support for multiple choice exams: The website should allow for the easy creation and administration of multiple choice tests. - User accounts: The website will require user accounts for exam takers. These should be simple and easy to create, but also secure. - Comprehensive dashboard: Both users and admins should have access to a comprehensive dashboard for tracking user progress and other key performance metrics. Ideal Skills: - Proficiency in web development, particularly with creating interactive websites - Experience with user account management and au...

...application, I'm in need of an expert who can help me enhance its performance. While I don't currently have a specific list of tasks, I do have a few general ideas in areas where improvement is paramount. The key area for improvement I'd like to focus on at the moment is the app's performance. Particularly, I've identified that the app's loading time is significantly slow, which hampers the user's overall experience. Here's what I'm expecting: Key Responsibilities: - Assess the current performance of the application. - Identify bottlenecks contributing to slow loading time. - Propose effective strategies for speeding up the loading time. Ideal Expertise: - Extensive experience in working with Xam...