Timeline for Encrypted stored procedure is encrypting the plan cache query plan
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 10, 2023 at 16:05 | answer | added | warashi nguyen | timeline score: 1 | |
| Nov 23, 2021 at 20:27 | comment | added | Zikato | I don't think the repro is working for me. First execution I get nothing and second execution is non-deterministic. You are selecting top(1) without ORDER BY. IMHO your encrypted spQueryPlanCache is finding itself in the query plan because the same string you are searching for is embedded in the search itself. | |
| Oct 26, 2020 at 21:36 | history | edited | Hannah Vernon♦ | CC BY-SA 4.0 |
added an mcve for others to use in testing
|
| Nov 3, 2019 at 6:00 | history | tweeted | twitter.com/StackDBAs/status/1190871371766804481 | ||
| Nov 1, 2019 at 15:10 | review | First posts | |||
| Nov 1, 2019 at 16:02 | |||||
| Nov 1, 2019 at 15:08 | history | asked | FrugalShaun | CC BY-SA 4.0 |