Markus,

The issue is not around whether the various versions work as they all do but rather what the pro's and con's are of each version.

At a basic level it...

Lorrin,

I would be worried about the impact on memory and performance. I agree that it is a solution that would avoid dynamic sql. However, in reality I would expect that...

Both EXEC and sp_Executesql require data reader access. However, the downside of granting access is far outwayed by the potential performance gains.

If you are going to grant access then I...

Something that I have played with and works quite nicely is creating a temporary SP.

Define you proc in a sql variable

DECLARE @sql nvarchar(4000), @TableName nvarchar(100), @Schema nvarchar(100)

SELECT...

Sadly this is not the result of a cached execution plan but rather the way the optimiser interprets the query. The only wa to get the optimiser to build a...

Jacob,

I have read and enjoyed the article. As you state in terms of performance not all versions are the same. In particular it is worth noting that using the compiled...