In case it can help you, maybe you can read straight from the ssc site here : http://www.sqlservercentral.com/NewsletterArchive

If this is a SP, then you can definitly try this.

DECLARE @LocalWeek INT

SET @LocalWeek = @ParamValue

The use @LocalWeek in the query that will help the optimiser.

Also add the with recompile...

Have you tried something along those lines?

Select identity(int,1,1) as DeleteID, WeekNo, Id into #tmp FROM DeletingTbl where WeekNo <= @Whatever

set rowcount 50000

set @Loop = 0

while @@Rowcount <> 0

begin

SET @Loop =...

Steve Jones - Editor (5/27/2010)

---

Why not? Just curious. If it really...

Well even if you only delete 1 week of data that equates to roughly 2% of the data in the table. With that much data, a scan will always...

nik27184 (5/25/2010)

---

No you get me wrong... let me tell you more clearly.

I have one db in sql 2008 but we need to send same to db to client as sql...

Open the application you are afraid to break and look up the source code or odbc connection.

Or if you are afraid to offend someone, change the password and tell them...

I've forwarded everything to the local admin. We're waiting on a test window to keep going. So far everything seems ok (we've moved backups earlier in the night...

Awesome guys. I'll let you know the outcome.

Trey Staker (5/13/2010)

---

So the backup log part finishes and it starts the file move? Turn on perfmon and watch and make sure there is disk i/o, network i/o. ...

Glad to see I'm not insane :w00t:.

Here's the...

Steve Jones - Editor (5/13/2010)

---

If the backup completed, I don't think it's SQL Server. How is the file moved? Could there be something in there waiting on a response somehow?...

That was the only job that hang.

Also in all logs, there's no notice that the agent was ever stopped / started other than the forced reboots we did on the...

I still need you guys... thread is almost 1 day old and no help so far (no offense to Bhuvnesh who gave it a shot).

Backup log succesful in 28 secs,...

Ok let's approach from this angle :

If it happens again what the heck can I do to figure out the problem?

Right now I'm thinking MS support. But is...