April 15, 2013 at 9:09 am
In my one asp.net app, I created a connection string to ServerA and then created a linked server from ServerA to ServerB. It working fine.
But, new boss said that linked server is not good practice. App should void using linked server and should create another connection string to ServerB.
Is it true?
April 15, 2013 at 9:26 am
adonetok (4/15/2013)
In my one asp.net app, I created a connection string to ServerA and then created a linked server from ServerA to ServerB. It working fine.But, new boss said that linked server is not good practice. App should void using linked server and should create another connection string to ServerB.
Is it true?
As with everything in SQL there is a time and place for everything. If you are using a linked server to avoid creating a connection to another server then I would think it would be better to connect directly to the server with the data. If however, your query needs data from both servers in a single query, a linked server is probably the best choice.
The comments you posted by your boss are entirely too vague but it sounds like he does not like linked servers because he heard somewhere they are not good practice. My question would be why are they not good practice? In what situations would they be good practice?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply