PintoSandler444
Z WikiSennik
sql server performance Method Stored Procedures
Program Stored Procedures Method kept methods are usually packed with SQL Server. Several processes are used to administer SQL Machine, however, many are resources which can be profitablly employed by developers. They are international, and may end up being called from the database program with out their fully qualified title. (They are all owned by dbo.) . They all are kept in the Master data source, and possess the prefix sp_. This can be a reasons why it is considered unwise to call nearby saved methods using the sp_ prefix. They can be study by viewing their particular properties in the Problem Analyzer.
The system-stored methods are grouped in to these groups.
Group Outline
Active Listing Processes Utilized to sign-up installments of SQL Machine and also SQL Server directories in Microsof company Windows? Two thousand Active Directory?.
List Processes Accessories ODBC information book functions and also isolates ODBC applications through changes to underlying method dining tables.
Cursor Procedures Tools cursor varied functionality.
Data source Upkeep Plan Methods Accustomed to setup central upkeep tasks essential to ensure data source overall performance.
Dispersed Inquiries Methods Utilized to apply as well as manage Distributed Inquiries.
Full-Text Search Processes Utilized to put into action and also issue full-text spiders.
Log Shipping and delivery Methods Utilized to arrange as well as manage log shipping.
OLE Automation Procedures Permits normal OLE automation items to be used in just a normal Transact-SQL order.
Duplication Methods Used to manage replication.
Protection Procedures Utilized to manage security.
SQL Postal mail Processes Accustomed to carry out e-mail procedures from within SQL Host.
SQL Profiler Methods Utilized by SQL Profiler to watch performance and activity.
SQL Machine Broker Procedures Used by SQL Server Broker to handle slated and event-driven routines.
System Processes Employed for general repair off SQL Server.
Web Associate Methods Used by the Web Helper.
XML Methods Employed for Extensible Markup Language (XML) text supervision.
