Boss told you to come up with a question to test new programmers? Here's one: you have a linked server and an openquery statement. What is the number returned by this query? select count(*) from openquery(LINKED_SQL, 'select count(*) from database.dbo...
Last week I came across an interesting issue. If you have a FOR INSERT trigger on a table and you want to store some information on a linked server, the transaction the trigger is running within is automatically expanded to distributed mode. This creates...