SQL server 2005 new features

Sql server 2005 brings many new features like Common Table Expression, which makes paging fast & easy, xml datatype which can be used to store relational data but not as replacment, you need to find best candidate for it, else this can be harmful to your sturcute…..writing testing post..

ViewState vs Cache

ViewState: Viewstate is a gift for .net developers, which solves lot of problem of remembering what was in that field last time user hit submit, and storing values to get after postback, but viewstate purely belongs to page postback.If used wisely then a great advantages.But if used accessively then it can heart your application badly that users may be waitng for minutes if you are putting everything in viewstate like big objects collection, datatables,dataset, it should only be used to store variables values.

Cache:yet another gife of .net, servers great if you find a suitable candiate for caching in you system by analyzing your database, the entities which dont get updated randomly are the best candidates for cache.your pages will come in fly.ASP.net provides different types of caching..will explain later…..

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!