Introduction to LINQ

Most programming environment required to integrate some sort of data into their applications. Often, we are taking from the multiple sources such as memory collections, relational databases, XML files etc. All data sources have different means of querying the data like SQL for databases, XQuery for XML, LDAP queries for Active Directory etc. Here comeup [...]

Using NAnt to Build .NET Projects

With Visual Studio .NET, you can easily build and compile .NET projects that contain any number of subprojects — collections of interdependent web pages, executables, DLL assemblies, and so forth – with a single menu command. But relying on a single programmer hitting the “compile” button doesn’t always work for large and complicated projects. What if [...]

Webservices – WebMethod Attributes…..

The WebMethod Attribute
Unlike the WebServiceAttribute, the WebMethodAttribute is not optional; any method that is to be exposed as a method of an XML Web Service MUSThave the WebMethodAttribute applied to it, and it MUST be declared using the public keyword. The WebMethodAttribute indicates to the .NET Framework that the specified method should be made accessible via standard Internet protocols.
Since the Web Service method, (a.k.a. Web method), is intended to [...]

Performance and Load Testing

General Testing best practises:
When performing tests on your web site it is good practice to thoroughly test one page at a time and make sure each page is reliable before proceeding to the next page. Carefully document all details on how to reproduce bugs and the methods used to resolve the bugs. This documentation will [...]

Understanding and Tuning Update Statistics

 

The UPDATE STATISTICS command has three major functions:

Compiling stored procedures.
Dropping data distributions.
Collecting information for the optimizer.

 
This article focuses on the task of collecting information for the optimizer, including:

Information collected by UPDATE STATISTICS
Performance and usability improvements in UPDATE STATISTICS
Tuning UPDATE STATISTICS to run more efficiently.

 

There are two types of data the optimizer will make use of [...]

SQl Server Query Execution Plan

When it comes time to analyze the performance of a specific query, one of the best methods is to view the query execution plan. A query execution plan outlines how the SQL Server query optimizer actually ran (or will run) a specific query. This information if very valuable when it comes time to find out [...]