Can you do a test changing the isolation level ?

I would change it to read uncommitted , in your case is read committed.

Kr,

R

There are some examples here http://www.sqlusa.com/bestpractices2005/collatedatabasedefault/ ..

Cheers,

R

.. and don't forget another join with sys.dm_exec_sessions on session_id as well ..

Just make a join with sys.sysprocesses on spid / session_id, 🙂

Cheers,

R

Division by zero is not handled here 🙂

You have it on 2008 as well .

You can find it in 2008 as well.

Hi there ,

you can try something like this :

select

d.name,

percent_complete, dateadd(second,estimated_completion_time/1000, getdate()), Getdate() as now,

datediff(minute, start_time, getdate()) as running, estimated_completion_time/1000/60 as togo,

start_time, command

from...

Hi there ...

What if you have a few hundred stored procedures in your db ? Do you change all of them ? I would rather take a look into...

Well , in this case it sounds like new tables are needed, lots of work 🙂 .

and here is another example:

create table bubu (fcol1 int)

create table tutu (fcol1 int)

create table #tmptables (fid int identity (1,1), tblname varchar(50))

insert into #tmptables (tblname)

select 'bubu'

union

select 'tutu'

declare @cnt int,@sqlst...

alter table bubu

add fid int identity (1,1) primary key not null

kr,

R

Then change the datatype from datetime to nvarchar for example ..

From the server.

kr,

R

alter table myta[font="Tahoma"][/font]ble alter column mycolumn int not null;

cheers,

R