Articles by Senthilkumar

Learn about CTE, a SQL Server 2005 feature replacing temp tables. Understand its efficiency over temp storage methods, essential syntax, and diverse applications in query optimization. Examples illustrate CTE's versatility in data manipulation, facilitating web application performance. Share feedback for further discussion.

This article explains the difference between functions and stored procedures used in SQL Server.

In SQL Server, cursors are database objects that allow you to iterate over a result set (query result) one row at a time, processing each row as needed. Cursors are often used when you need to perform complex row-by-row processing or when dealing with situations where set-based operations are not practical or efficient.

This article explains about the sub report in the Gridview using Ajax. It will load the subreport content dynamically at the time of view the report. The ajax have used to implement this part.

This article explains about constructors in C#.I have explained with the different scenarios through coding. It covers all the applicable area of constructors in C#

This article explains about the FileInfo and DirectoryClass in the System.IO namespace. The sample application demonstrates how it works.

This article provides some tips to improve ASP.Net application performance.