SamaraDamato129

Izvor: KiWi

sql server performance Method Kept Procedures

Program Stored Methods System stored processes are grouped together with SQL Host. Several processes are utilized to give SQL Server, but some tend to be tools which can be profitablly utilized by builders. They're global, and may be referred to as from the database application without having their own fully qualified title. (They all are of dbo.) . They are all saved in the Master data source, and have the prefix sp_. This is a reasons why it's considered unwise to mention nearby kept procedures using the sp_ prefix. They may be study by viewing their own attributes inside the Query Analyzer.

The system-stored procedures are categorized into these classes.

Class Description

Lively Listing Procedures Utilized to register cases of SQL Server and SQL Machine directories inside Microsoft Windows? The year 2000 Active Directory?.

Directory Procedures Tools ODBC info book capabilities and also isolates ODBC applications from adjustments to be able to underlying program tables.

Cursor Methods Tools cursor varied functionality.

Database Maintenance Strategy Processes Accustomed to set up core maintenance tasks necessary to ensure databases efficiency.

Dispersed Queries Procedures Used to implement and also handle Dispersed Questions.

Full-Text Search Processes Accustomed to implement and problem full-text indexes.

Sign Shipping and delivery Procedures Accustomed to arrange and control record shipping and delivery.

OLE Hands free operation Methods Permits regular OLE automatic items to use within a standard Transact-SQL batch.

Replication Methods Used to handle reproduction.

Protection Methods Used to manage safety.

SQL Postal mail Methods Utilized to perform e-mail operations from within SQL Host.

SQL Profiler Procedures Used by SQL Profiler to observe overall performance as well as exercise.

SQL Host Agent Methods Utilized by SQL Server Broker to handle scheduled and event-driven routines.

Method Processes Employed for basic maintenance of SQL Host.

Web Assistant Processes Utilized by the internet Assistant.

XML Methods Employed for Extensible Markup Vocabulary (XML) textual content management.