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

He and his wife are okay as they were not on the beach in the morning.

http://weblogs.asp.net/pleloup/archive/2004/12/27/332577.aspx

Has anyone been in contact with Anand? He lives in Chennai. There are so many .NET folks in Chennai.

update: Anand was fortunately visiting his parents and not in Chennai on Sunday morning. His home, quite near the beach, was spared from water damage.

Posted from BLInk!

http://www.ndtv.com/homepage/default.asp

http://www.chennaionline.com/

I now have friends all over the world through our INETA and blogging communities. Friends in places like Chennai, India which was hit hard by this mornings' earthquake and subsequent tidal waves.

From CNN - Comair cancelled all of it's flights over Christmas. Why?

Comair's computer system that manages flight assignments crashed Friday night after it was overwhelmed by cancellations and delays caused by the winter storm that socked the Ohio Valley. The computer shutdown forced the airline to cancel all of its Saturday flights.

Ouch!

Neil recieved his first copy a few weeks ago and shows us the flyer for the book here.

Someday, I am going to own one of Daryl's phenomenal pastels. Until then, at least I can share them with others via my blog. Here is her website. For now I have some postcards and a pin!

Got Speech? Developing Applications using Microsoft Speech Server and .NET

Registration is open!

Thom Robbins announced the winners of the Will Code for Device contest and then posted individual blog posts describing each of the winning applications and screen shots of them.

If you browse to his list of blog posts for December you can see each of the winning apps.

Poor Robert has taken such a beating this week, but this really is funny!

This story was on NPR (MarketPlace) last night.