Browse by Tags

Is it better to move data to procedures or move procedures to data?
The answer is, of course, “it depends.” Let’s consider a scenario where you have two SQL Server instances: ServerA and ServerB, and you have a procedure on ServerB (call it procB), but need to access data on ServerA.
Three database solutions are ...