Please find the execution plan for the delete statement. Looking at the plan INDEX delete operation is taking most of the time, Please let me know if there is any...

Not on a daily basis but during weekends. We dont have any Txn log bkps or Diffnt bkps running during business hours, so performance kill with backups is ruled out?

Thanks Master for your reply.

I would alter my MP to the following Sequence. Please let me know if this is Ok to go with.

Check DB Integrity -> Rebild Index

Thanks,

Nagarjun.

I mean to say all the dates that are there in the date filed should be shifted by some number of days but should not be greater than current date.

CREATE TABLE [dbo].[faxes] (

[ID] int NOT NULL,

[Fax_Date] datetime NULL,

[Audit_ID] int NULL)

ON [PRIMARY];

GO

Insert into faxes values (1,'6/5/2012',1000)

Insert into faxes values (2,'6/25/2011',1000)

Insert into faxes values (3,'8/15/2010',1000)

Insert into faxes values (4,'9/25/2009',1000)

Insert into...

I want to update all datecolumns or shift dates to recent so that it would appear as fresh data. I want to have generic query which does this for me.

Thanks,

Nagarjun.

Thanks for the reply!

If i want to check all 6 log files (at a time) for all server restart msgs?

Thanks,

Nagarjun.

SET NOCOUNT ON

DECLARE @crdate DATETIME, @hr VARCHAR(50), @min-2 VARCHAR(5)

SELECT @crdate=create_date FROM sys.databases WHERE NAME='tempdb'

SELECT @hr=(DATEDIFF ( mi, @crdate,GETDATE()))/60

IF ((DATEDIFF ( mi, @crdate,GETDATE()))/60)=0

SELECT @min-2=(DATEDIFF ( mi, @crdate,GETDATE()))

ELSE

SELECT...

I just had got this doubt while reading an article about pages. Thanks its cleared!

Thanks for all replies!

My question was like is there any other table which has all information about the sys.xxx table names (Metadata) stored? This would be helpful if i forget...

Hey Sudeep,

The code in the red is my earlier code which was giving errors and the code...

Perfect Guru! It went like a rocket! Thanks a lot!!!

Thanks,

Nagarjun.