Monthly Archives: December 2004

Money is probably the best way to help

Asia

Unless you have some special skills, the best thing we can do is send money to the organizations who know what to do and know how to do it. So that is good inspiration for me to keep working and send what $ I can. I am sending my money through the Red Cross, though there are many other aid organizations as well. It’s a crappy feeling to realize that my skills aren’t very useful when they could really count.



http://www.redcross.org

Why Batch Update was changed from earlier Whidbey bits

ADO.NET 2

I mentioned in a previous post that the Batch updating process was changed with the current (November) bits of Whidbey to overcome a limitation in SQL Server – which is that you cannot have more than 2100 parameters in one query.

In response to a discussion in the newsgroups (ADO.NET 2.0 Batch Update), below is a screenshot from SQL Profiler with the earlier bits when I had set UpdateBatchSize=3.

It bunched together 3 queries into one big query. With 15 parameters per query,  SQL Server was receiving 46 parameters.(the 45 parameters + the actual query string which was stuffed in to @P1).

In this case, I would be hitting the limit if I tried to send more than 140 rows.

In the new bits, if you watch the profiler, you will see one row being updated per query. So  ADO.NET is now sending a group of individual queries in each batch, rather than one big huge query. I have sent batches of 10,000 rows at a time.

Example from Beta 1 October CTP – no longer true for future releases of .NET 2.0

Posted from BLInk!