Sentences with phrase «stored procedures»
Stored procedures are like ready-to-use blocks of code that perform specific tasks within a database. They help improve efficiency and organization by allowing users to store commonly used actions and execute them whenever needed, without rewriting the entire code again. Full definition
Worked as a SQL Developer responsible for creating SQL stored procedures, functions and triggers.
jobhero.com
All reports used stored procedures to access the data needed to develop the reports.
Performance tuning; reducing execution time stored procedures for primarily 3 - tier applications.
The latter contained complex multi - table / view queries spanning several databases, packaged as SQL Server store procedures.
Created data layer class modules that passed parameters to and executed stored procedures in SQL Server.
Designed and implemented stored procedures views and other application database code objects.
Created PL / SQL scripts to analyze data, modify data, import / export scripts, and execute stored procedures.
Performed index and stored procedure tuning scaling for over one (1) million products from initial full vendor data import and continuing data feed.
Writing new stored procedures and modifying existing ones and tune them such as they perform well.
Successfully improved the performance on our application through index analysis, removing unused indexes and analyzing stored procedures, functions and SQL scripts.
Performed all updates to SQL stored procedures, functions, tables, views and jobs in support of weekly and monthly commission payouts for all customers.
Developed new SQL Server stored procedures to streamline the data collection and validation processes.
Design, maintain and optimize Database, write stored procedures, triggers, index, and functions in SQL Server database environment.
Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
Developed extensive library of Crystal Reports as well as stored procedures based on the SQL database developed for metrics and performance reporting.
Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins and other T - SQL code to implement business rules
Create stored procedures for Incremental extract based on time stamp, version date and record flag.
Maintained and developed stored procedures and functions with the use of Microsoft SQL Server Management Studio.
Determined data relationships by reviewing existing stored procedures, views, and report queries.
* Used SQL Server 2016 to create and to maintain stored procedures making u...
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL / SQL.
Performed Open and Close Store procedures including store floor review, cash drawer reconciliation, and sales reports
Programmed stored procedures, user defined functions, database triggers and packages and all the database objects needed in Oracle environment to implement business logic.
Conducted performance tuning of complex SQL queries and stored procedures by using SQL Profiler and index tuning wizard.
They also manage storing procedures of deli items in order to ensure that no food items are spoiled and check expiry dates as well.
Created automate processes through stored procedures utilizing T - SQL to facilitate additional production capacity and not overburden the main data server
Scripted and modified stored procedures, user - defined functions and report objects within Microsoft SQL server
Developed the Crystal Enterprise reporting system for report distribution and management of scheduled and ad hoc reporting for approximately 65 Crystal Reports v9 / 10 and the associated stored procedure data sources.
Designed, developed, and implemented many Oracle stored procedures / packages / triggers / complex SQL, and UNIX Shell Scripts to improve the performance of existing systems and to troubleshoot and implement the changed requirements.
Careful attention is required to ensure that hygienic practices, as well as logging, labelling and correct storing procedures are followed by everyone who is handling the milk.
Central sterilization processing (disassembled, decontaminated, assembled, sterilized and stored procedure trays, instruments, equipment and supplies according to regulatory requirements).
Implemented oracle Stored Procedures, triggers and DB design.
Implemented the elements of T - SQL like dynamic stored procedure to store and update the information regarding residential, business and large business customers into one centralized SQL database called hub.
Implemented proactive database monitoring like locking, deadlock analysis, long running query, clustering failover using DMVs and stored procedure which reduced database outage and improved performance
Written Stored Procedures against the Oracle Server Database for efficient process of table data.
Migrate stored procedures and reports between environments.
• Wrote and documented stored procedures and triggers at the back end.
This includes working with TSQL to build stored procedures, building and maintaining SSIS processes, performing data analysis and ad - hoc reporting.
Created and troubleshot stored procedures and queries performances using SQL Server Profiler, Performance Monitor and DBCC Commands.
Optimized stored procedures in to extract, transform and load (ETL) data to ensure reporting infrastructure was maintained according to current service level agreements.
Later, managing 2 SQL Developers and leading the development of the complex TSQL stored procedures and SSIS ETL processes utilizing XSLT and FOR XML queries to consume and translate the vendor XML and Excel data files into the supporting database feeding the enterprises sales advisor mobile application.
Excellent experience in creating complex queries Stored Procedures, View, Triggers, Union and Join Functions.
Developed and implemented custom data validation stored procedures for metadata summarization for the data warehouse tables, for aggregating telephone subscribers switching data, for identifying winning and losing carriers, and for identifying value subscribers