Tag: sp_

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 System Stored Procedures

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, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using stored procedures in SQL Server 2017

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, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2016 System Stored Procedures

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, Standard and Standard Member members only.
Log In Register
SQL Server

Tips for using stored procedures in SQL Server 2016

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 […]

SQL Server

Troubleshooting SQL Server 2014 System Stored Procedures

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 […]