Current Recovery model :- FULL ,

I can't access any backup file

We have taken the Backup , But I don't have a Access for that ... please advice any other than using Back up

yeah , i don't have any Backup file ...That's the problem actually ..

only one table need to be updated , How .. i don't have any Back up...

Script file :

Thanks ... sorry for troubleing you again and again ..

what is the timestamp ... can we use this ....

please execuse me , if anything wrong in question ...

But , i don't have any coulmn for Date ..

actually , the scenario is we have a tables (very large) we want to delete the records that entered before 2006...

Sorry for that ....

I have a number of tables which keeps on updating from last 20 years..

My question is

i want to delete the records which...

Hi Gila ,

Thanks ! That was great article ,but this will not slove my problem

because this article http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/ ...

Hi Sir ,

Please help me !!

I am trying to optimize one store procedure

The problem is when

I use EXEC store procedure...

I am not sure , But Can you try once with UNION ALL (combined with a GROUP BY)

: really quick and easy way to compare two tables.

Post Execution Plan

Execution plan Plz

Thanks

Hi ,

I am new to SQL SERVER .. Is there a chance to remove Bookmark look up in execution plan , without changing an Index part ...

i mean if...

Hi Sir ,

I am new to SQL server .. I am trying to optimize one store procedure

the problem is when i use EXEC store procedure , i...