Tej_7342 (11/5/2013)

---

There are 2.2 billion records in the table and we want to only keep 2 weeks data, as of now we are lagging behind so we want to delete...

Make habbit to include schema whenever playing with sql objects.it is good from "standard" as well as "safety" perspective

you can do SQL 2000 SP4 to 2008 R2 by SQl Server Upgrade Advisor:

See http://www.microsoft.com/downloads/en/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en

First ..fix the LEFT join as chris has asked. another thing where you are getting "NULL" results (in which column)

Nobody can help you here ..we dont know your data and table definition.

PLease post table defintion along with (sample) data to get the result.

USe below query to troubleshoot the resource crunch

--== Blocking queries in database ==--

SELECT DES.Session_ID AS [Root Blocking Session ID], DER.STATUS AS [Blocking Session Request Status],

DES.Login_Time AS [Blocking Session Login...

are you creatogn dynamically sql script through app ?

which could be missing schema name in generated script

is it a dedicated log disk ?

Use another bigger disk...

You havent mentioned in any of ur post that you are managing the logs ? for full recovery .. regular Tlog will be required .

you havent answered my question ? as it might help us to frame resolution for ur issue.

How much data you are...

As steve mentioned above.

tony28 (10/30/2013)

---

SO my point is WHAT IS BETTER FROM ANOTHER POINT OF VIEW, I PREFER LONG TIME ( because i think this is still short time ) THAN LOT...

try this

insert into #tblmain

exec usp_Main_TEST @CustID = '123'

I also read...