Information

Steps to attach a database with different name: Detach database from local PC Copy the mdf and ldf files and rename them. Copy\Move t...

Some time this problem occurs due to compiled query plan became corrupt, or invalid. Stored procedure slow when called from web, fast fro...

First Declare a temp table DECLARE @table Table(column1 INT, Column2 INT, total int) insert duplicate data to temp table insert INTO...

DATEADD ( type , value , date ) date is the date you want to manipulate value is the integere value you want to add (or subtract if yo...

SELECT name, create_date, modify_date FROM sys.objects WHERE type = 'P' ORDER BY modify_date desc, create_date desc