238 reputation
110
bio website
location
age
visits member for 1 year, 5 months
seen Mar 23 at 11:20

Nov
26
suggested suggested edit on I have to update all the rows of a Column in a table. Here is my query
Nov
26
asked Does the Query cost in Sql Server account for buffering?
Nov
15
awarded  Scholar
Nov
15
accepted How much work actually happens on SSMS and how much on the server itself?
Nov
12
awarded  Supporter
Nov
12
awarded  Student
Nov
12
comment How much work actually happens on SSMS and how much on the server itself?
So,just so I understand correctly, in a query such as the one I mentioned in the question, the loop is also running on the server, and 2 million insert calls are not being made over the network?
Nov
12
asked How much work actually happens on SSMS and how much on the server itself?