Subscribe RSS FeedDue to a recent agreement between Google and some book publishers, they are going to publish a large number of books online (limited content depending on each publishers agreement).
So you can now read Pro ASP.NET 2.0 C# for free online (a large chunk of it)! Click the link for more. This book is jam packed (1000 pages+) with well-written details on everything under the sun in .NET 2.0. I was in particular looking for SQL Cache Dependency information which I found in there.
Apparently in SQL Server 2000, Cache Dependency is done on a table basis, you cannot have it dependent on a certain condition (for example select * from CONTACTS where location=’canada’). If any data at all changes inside CONTACTS then the cache is considered invalidated and you will need fresh data. Lots of improvements in SQL Server 2005 boys….
