ASP.NET 2.0 & SQL Server 2005 details

As .NET Beta 2 rolls out as I write, there are more and more public details available on this new version of the framework.

MSDN has an excellent article about ASP.NET 2.0 internals, and to me, especially the following features are interesting:

• The improved code-behind model
• Additional compilation options
• The new events
• Cross-page posting

Naturally, there are many more new and enhanced features, but the above sound the most interesting ones to me.

Details emerge on SQL Server 2005 as well. For web applications, I find the new "query governor cost limit" option useful.

With this option, it is possible to limit how much time an SQL query can take. So, if you write a foolish query with inner SELECT statements and many joins, the query won't be executed.

The MSDN article that talks about this query cost limiting is available here.