I have a procedure during which I begin a new transaction and update a particular property of a fairly large number of objects of the same class. When I used SQL profiler to see the generated SQLs, I see that the Update statements are updating each and every column of the table, rather than just the one whose property I had changed. Is this expected?
The table is a big one, and 2 of the columns are actually 'Text' columns, which have large amounts of data, so the SQLs being generated are huge.
Please help
|