web analytics

Category: Databases

Demand Paging (Custom Paging) in ASP.NET with SQL Server 0

Demand Paging (Custom Paging) in ASP.NET with SQL Server

Many a times we need to present bulk data to the user in our day to day application development. Loading all data at one shot is okay when we have few hundreads data but...

Tracking object (Table, SP etc) changes in SQL Server 2005 0

Tracking object (Table, SP etc) changes in SQL Server 2005

DBA’s often need to track the changes being made to database objects such as tables, user defined functions and store procedures etc. Following article aims at providing the readers on how the changes being...

Debugging Stored Procedures in SQL Serrver 2005 0

Debugging Stored Procedures in SQL Serrver 2005

Pre-requisites 1. Find the .exe file under the directory, C:\Program Files\Microsoft SQL Server\90\Shared\1033\rdbgsetup.exe or similar path where the SQL Server was installed. The file rdbgsetup.exe stands for ‘RemoteDeBuGsetup’. Look for the emphasis on letters....

Delete duplicate rows from table 1

Delete duplicate rows from table

In the above line we are inserting all the distinct row of the "EmployeeTable" to another table "Emp_Temp_Table" (Emp_Temp_Table will create automatically when you use the above query.) Actuall the above query create clone...