Tag: sp_

Pro Members SQL Server Standard Members

Tips for using stored procedures in SQL Server 2019

by

Tips for using stored procedures in SQL Server 2019 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.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 System Stored Procedures

by

Troubleshooting SQL Server 2017 System Stored Procedures If you have problems with SQL Server 2017 system stored procedures, review this troubleshooting checklist to find potential solutions. 1. Executing the sp_add_log_shipping_database system stored procedure may cause error 14412. This error indicates that the destination database is already part of a log shipping plan. To work around this problem, check the existing...

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.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using stored procedures in SQL Server 2017

by

Tips for using stored procedures in SQL Server 2017 Consider using natively compiled stored procedures. Natively compiled stored procedures are Transact-SQL stored procedures compiled to native code. These stored procedures allow for efficient execution of the queries and business logic in the stored procedure. The difference between interpreted (disk-based) stored procedures and natively compiled stored procedures is that an interpreted...

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.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2016 System Stored Procedures

by

Troubleshooting SQL Server 2016 System Stored Procedures If you have problems with SQL Server 2016 system stored procedures, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many system stored procedures bugs were fixed in SQL Server 2016 service packs, you should install the latest SQL Server service pack. At the...

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.
Register
Already a member? Log in here
Continue Reading →
SQL Server

Tips for using stored procedures in SQL Server 2016

by

Tips for using stored procedures in SQL Server 2016 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. Consider using user-defined table type as a parameter for the stored procedures. SQL Server 2016 supports a user-defined […]

Continue Reading →
SQL Server

Troubleshooting SQL Server 2014 System Stored Procedures

by

Troubleshooting SQL Server 2014 System Stored Procedures If you have problems with SQL Server 2014 system stored procedures, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many system stored procedures bugs were fixed in SQL Server 2014 service packs, you should install the latest SQL Server service pack. At the […]

Continue Reading →