Archive:
Search site:
Tags:
Compilation (1) Concurrency (3) docker (1) Execution Plans (4) internals (10) linux (3) Name Resolution (1) Optimization (4) Performance (7) Performance Tuning (2) pgadmin (1) postgres (3) RCSI (2) Schemas (1) Security (1) SQL Server (17) Statistics (1) Transactions (1) tsql2sday (1) Version Store (2)
Categories:
Tag: Name Resolution
-
Cross Database Deferred Name Resolution
I have been aware of temporary stored procedures in Microsoft SQL Server for a long time but never really had cause to use them, however, recently a need arose. I was testing what effect some index changes would have on a particular stored procedure. The testing was on a non-production server, and when I went…