Thank your for the corroboration. I was feeling very alone 😉

Indeed, you cannot do a thing about it, but open a case at MS (because it actualy IS a flaw)...

If volume is increasing, desing flaws may escalate !

is this select * executed from Query analyser or are they using a cursor to walk throug it ?? :ermm:

- You may...

how about this one

-- jobi dd 08/12/2003

-- verplaatsen backupdevices

use master

Declare @DevNameSuffix varchar(10)

Declare @OldPath varchar(500)

Declare @NewPath varchar(500)

select @DevNameSuffix = 'Log'

, @OldPath = 'T:\MSSQL\BACKUP\'

, @NewPath = 'T:\MSSQL\BACKUP\IncLogBackup\'

-- select ...

- how often do you rebuild indexes on your db ?

bad indexes result in IO overhead resulting in longer need for locks.

IO is the slowest part...

Balmukund Lakhani (3/27/2008)

---

for those who don't want to write query, go to management studio, right click on Server, Go to Reports > Standard Reports > "Schema Change History"

This report picks...

I assume someone dropped the database using Management Studio.

It has a default do delete all backup info as well.

AFAIK, you still need to delete the backup files manualy.

So have a...

If your date columns are defined datetime you're OK with this proc.

create proc usp_thedeletes

as

begin

set nocount on

delete

from yourtable

where datediff(d, From_Date, To_Date) > 30

end

Else, don't come complaining that the...

You are performing a RESTORE operation, meaning you put back a copy of the database.

If that copy has been produced when the database was in autoclose mode, that's the reason...

Yep, Johan is my name, ALZDBA the SSC username.

And IMO for me it is way to late to alter it to Johan because of the many "name"...

balbirsinghsodhi (3/25/2008)

---

I am trying to delete records in a batch and it's taking forever. there are 65 million rows in one table and I am deleting based on some condition...

Good old BOL did it again, thanks for the rectification.

Here's a little test script I've found back from my test (sql7)

Just to demonstrate simple working of it.

/****** 🙂 best regards...

did you check this ad-clr forum thread ?

http://www.sqlservercentral.com/Forums/Topic452981-386-1.aspx

Did you check common table expressions (CTE) ?

This has recursive capacities.

There are some nice examples at SSC, as well as performance articles regarding CTE and the alternatives.

AFAIK: No.

Locking is also dependant on the type of connection isolation level or command isolation level you are using. Hence, no info regarding execution plan.

However, you can launch sql profiler...

did you check Jeff's concatenation article ?

http://www.sqlservercentral.com/articles/Test+Data/61572/

If not, you realy should 😉