Other News

Community

Transforming XML with XSL in .NET

In my years of software development, I’ve found that there are a few topics that seem to elude many programmers. Some of the topics are pretty complex (compiler design comes to mind); others are just plain foreign compared to traditional programming (Regular Expressions comes to mind). Others just s

Community

A surfeit of caches

(Rex Baldazo) A cache is useful in theory. By storing a temporary copy of some page or image, the servers can deliver it faster to the client computer. But if you’ve ever been stuck trying to debug a problem related to caches, you quickly realize that computer science types have gone overboard and p

Community

Oracle 11g: Extended Statistics

(Greg Rahn) In the Real-World Performance Roundtable, Part 2: The Optimizer, Schema Statistics, SQL Tuning at Oracle OpenWorld 2006, I worked an example of how the optimizer can have difficulty estimating the correct cardinality when there is data correlation. (The Zodiac example can be found on pag

Community

Understanding State Management

You need to maintain state-level and page-level information of an ASP.NET Web application because Web pages and ASP.NET Framework use HTTP protocol to communicate between a Web browser and a Web server. HTTP is a stateless protocol. Therefore it can not automatically indicate whether the sequential

Community

Error message when you create a snapshot backup of many databases at the same time in SQL Server 2005: ‘ERROR Selected writer ‘Microsoft Writer (Service State)’ is in failed state’

Consider the following scenario. In Microsoft SQL Server 2005, you create a snapshot backup of many databases at the same time. To do this, you use the Volume Shadow Copy Service (VSS), or you use the Virtual Backup Device Interface (VDI). In this scenario, the snapshot backup operation fails. Addit