Tag: stored procedures

Pro Members SQL Server Standard Members

Tips for using stored procedures in SQL Server 2014

by

Tips for using stored procedures in SQL Server 2014 Try to avoid using temporary tables and DDL (Data Definition Language) statements inside your stored procedure. Using temporary tables or DDL statements inside stored procedure reduces the chance to reuse the execution plan. Call stored procedure using its fully qualified name. The complete name of an object consists of four identifiers:...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2014: Stored Procedures

by

SQL Server 2014: Stored Procedures Author: Basit A. Farooq Introduction A stored procedure is a named, precompiled collection of SQL statements, variables, and control-of-flow statements. You can create stored procedures that accept input parameters and return values and status information. Typical uses for stored procedures include automating repetitive tasks, ensuring tasks are performed consistently, enhancing application and user access security...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Continue Reading →
Pro Members SQL Server Standard Members

Undocumented SQL Server 2012 Full-Text Search Stored Procedures

by

Undocumented SQL Server 2012 Full-Text Search Stored Procedures SQL Server 2012 supports the following three undocumented full-text search system stored procedures: sp_fulltext_recycle_crawl_log sp_MShelpfulltextindex sp_MShelpfulltextscript sp_fulltext_recycle_crawl_log The sp_fulltext_recycle_crawl_log system stored procedure is used to recycle crawl log for the given full-text catalog name. Syntax sp_fulltext_recycle_crawl_log [ @ftcat = ] ‘ftcat’ Arguments [ @ftcat = ] ‘ftcat’ Is the full-text catalog name...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Continue Reading →
Pro Members SQL Server Standard Members

Undocumented SQL Server 2012 Database Engine Stored Procedures

by

Undocumented SQL Server 2012 Database Engine Stored Procedures SQL Server 2012 supports the following useful undocumented database engine stored procedures: sp_bcp_dbcmptlevel sp_MSforeachdb sp_MSforeachtable sp_MSindexspace sp_MStablespace sp_objectfilegroup sp_oledb_defdb sp_oledb_deflang sp_oledb_language sp_who2 sp_bcp_dbcmptlevel The sp_bcp_dbcmptlevel database engine stored procedure is used to get the database compatibility level for the specified database. Syntax sp_bcp_dbcmptlevel [ @dbname = ] ‘dbname’ Arguments [ @dbname =...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 stored procedures

by

Tips for using SQL Server 2012 stored procedures Include the SET NOCOUNT ON statement into your stored procedures. This can reduce network traffic, because your client will not receive the message indicating the number of rows affected by a Transact-SQL statement. Try to avoid using temporary tables and DDL (Data Definition Language) statements inside your stored procedure. Using temporary tables...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Continue Reading →
1 2 3