Timeline for How to optimize this dynamic stored procedure
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 21, 2011 at 22:39 | comment | added | Mark Storey-Smith | I still disagree with your opinion of EXEC. Erland's article (your updated link) highlights dynamic search conditions as one of the situations where dynamic SQL and EXEC/sp_execute are the most appropriate solution. On UDF, I've never encountered a situation were performance was improved through their use. I would welcome an example case. | |
| Nov 21, 2011 at 22:24 | comment | added | Rui Marques | I've pasted the wrong link. Fixed. UDF's may have impact on performance based on the way we use them. The goal is to use more simplified queries in particular on stored procedures and avoid dynamic queries as most as possible. Each usage scenario requires may require a particular solution and UDF don't need to be ruled out from the start. | |
| Nov 21, 2011 at 22:20 | history | edited | Rui Marques | CC BY-SA 3.0 |
Fixed url for A1. Wrong url.
|
| Nov 21, 2011 at 20:10 | comment | added | Mark Storey-Smith | Also, what's the basis for using UDFs in A3/A4/A5? The majority of us avoid UDFs as they can have a negative impact on performance. | |
| Nov 21, 2011 at 19:41 | comment | added | Mark Storey-Smith | What's your basis for A1/A4? There is nothing about usage of EXEC in the article you've linked. | |
| Nov 21, 2011 at 18:06 | history | answered | Rui Marques | CC BY-SA 3.0 |