SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag sp_executesql Rss

Search for any content tagged sp_executesql

   Items 1 to 3 of 3   

Why sp_prepare Isn’t as “Good” as sp_executesql for Performance

Erik Darling shows how execution plan estimates suffer. 
Rating: (not yet rated)  Rate this |   Briefcase | 2,694 reads

A Quick Tour of sp_ExecuteSQL

sp_ExecuteSQL can be used to dynamically execute T-SQL code. Learn how to use it and how to add parameters to control what code is executed.  Read more...
By Jonathan Allen 2014/02/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,300 reads

Fun with sp_executeSQL

Switching from 32 BIT SQL Server to a 64 BIT edition illustrates how removing a bottleneck from a system can have a detrimental affect overall  Read more...
By David Poole 2012/01/31 | Source: SQLServerCentral.com | Category: nhibernate
Rating: |  Discuss |   Briefcase | 16,034 reads
   Items 1 to 3 of 3