Tag: stored procedure

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 2012 System Stored Procedures

by

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

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 ASP.NET with SQL Server 2012

by

Tips for using ASP.NET with SQL Server 2012 Try to avoid using ADO methods to access SQL Server data in your ASP. Use SQL Server 2012 stored procedures instead of ADO methods. By doing so, you can reduce network traffic and boost overall ASP.NET performance. If you use ADO to access SQL Server data in your ASP.NET, try to avoid...

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 →