#sp_executesql

[seniordba]

Best Practice: Stored Procedure Optimization Tips

Best Practice: Stored Procedure Optimization Tips

SQL Server performance isn’t a simple checkbox you check that improves database performance. You have to look at many different factors to gain incremental improvements. Each change might give you a 5-10% improvement, but 10 changes might lead to a 50-80% improvement to the speed of your stored procedure. In this article by Pinal Dave, we see some of the most common tweaks to your stored…

View On WordPress

[essentialsql]

Build Dynamic SQL in a Stored Procedure

After reading this article you will understand the basics of dynamic SQL; how to build statements based on variable values, and how to execute those constructed statements using sp_executesql and EXECUTE() from within a stored procedure.

All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases AdventureWorks and WideWorldImporters.  You can get…

View On WordPress

[seniordba]

Best Practice: Stored Procedure Optimization Tips

Best Practice: Stored Procedure Optimization Tips

SQL Server performance isn’t a simple checkbox you check that improves database performance. You have to look at many different factors to gain incremental improvements. Each change might give you a 5-10% improvement, but 10 changes might lead to a 50-80% improvement to the speed of your stored procedure.

In this articleby Pinal Dave, we see some of the most common tweaks to your stored…

View On WordPress

[indiandotnet]

How easy or difficult to write dynamic SQL ? TIP#110

How easy or difficult to write dynamic SQL ? TIP#110

This is one of the challenge for most of the developer to write dynamic SQL. Generally we follow the approach of string concatenation.

This seems very easy but we need to cast the  parameters in VARCHAR and sometimes we stuck in single code.

I am sure this happened with all of us. 

Let’s understand first a straight forward way which we (most of  us) are  using.

In example I am using person…

View On WordPress