The work involved with building this execution plan isn’t significant, and it won’t be the largest part of my workload. WITH RECOMPILE – I use this because I don’t want the usp_RandomQ stored procedure to show up in my execution plan stats. Here’s what mine looks like for one of my query tuning demos: ![]() Since SQLQueryStress will be calling this stored proc dozens of times at once, you’ll end up with a variety of different queries running simultaneously. (for example, if it’s divisible by 3, run sp_C,
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |