Other News

Community

Web Services and DataSets

(Aaron Skonnard) Programmers using Visual Basic 6.0 have long bowed to the altar of the ADO recordset. It’s probably the most commonly used data structure in Windows-based applications today. The ADO.NET DataSet is poised to play a similar role in the realm of managed Windows-based applications.

Community

Joins Clarified

(Sanket Naik) Normalization is an art; it is the best thing that can happen to databases .But it modularizes the data which means that we are not having all the data in the same table. This indirectly means that, suppose I want a receipt and for constructing that receipt I need data that is scattere

Community

FIX: The performance of a computer that is running SQL Server 2000 degrades when query execution plans against temporary tables remain in the procedure cache

If many unused query execution plans that are generated for queries against temporary tables remain in the SQL Server procedure cache, the computer that is running Microsoft SQL Server 2000 may experience performance degredation. The query execution plans may remain in the SQL Server procedure c