-
Notifications
You must be signed in to change notification settings - Fork 1.1k
Description
Is your feature request related to a problem? Please describe.
sp_BlitzCache strips CR and LF from the query text, this can make things difficult since some people didn't get the memo on line comments being a PITA to deal with in query text pulled from the plan cache.
Describe the solution you'd like
Add a new parameter @KeepCRLF BIT, default 0, but when set to 1 it will stop sp_BlitzCache from stripping CR and LF from query text.
The way sp_BlitzCache treats tabs and multiple consecutive spaces will not be changed by this new parameter.
Describe alternatives you've considered
Guessing where commented out code ends and valid code begins, but, seeing as I haven't yet won the lottery, it's safe to assume that I'm bad at guessing.
Are you ready to build the code for the feature?
Oui.