Skip to content

sp_BlitzCache - new parameter to retain CRLF in query text #3611

@VladDBA

Description

@VladDBA

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.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions