Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Performance Issue on SQL Cluster RE: Performance Issue on SQL Cluster
John Mitchell-245523
SSC Guru
Points: 148809
More actions
December 9, 2014 at 9:23 am
#1763582
Werner
In order to eliminate the NIC as the cause of the reduced performance, select your query results into a temp table instead of having them returned to the caller. That way, you take out the cost of sending the results across the network.
John