THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
Bad database practices
Bad database practices: abusing linked servers
In SQL Server, it is rather handy to retrieve data from a different SQL Server instance and use the result locally in another SQL statement for further processing. In theory and in the set purists’ fantasy land, it shouldn’t matter where you get your data or even how you get the data as long as you can use them to further compose a set-based ...
November 6, 2009
Bad database practices: moving data to procedures vs. moving procedures to data
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 ...
October 30, 2009
Brought to you by