can you add tablealiasses ? That eases reading and interpreting the query ?

e.g select t1.Uname

      from mytable t1

       , myview x2

      where t1.idno = x2.colxyz

         and t1.Ubirthdate = '2007-01-01'

or

select t1.Uname

     ...

I totaly agree !

And sometimes "time" also plays a roll in a situation.

I'm sorry to mention it can be handy to learn some basics regarding Structured Query Language. Invest some time reading about the "select" statement in books online.

- Actualy the only way of creating dbo objects by default is making that user databaseowner !! sp_changedbowner @loginame = 'PRG' ,@map = 'true'

groupmembership is not enough ! (you'll have to...

Thanks for posting the workaround.

It also works with SQL2005 Std SP1 

be very carefull if you want to disable triggers and/ or constraints because that goes for _every_ user of the database for the time you've desabled them !!

basicaly meaning, if...

If you are still considering a cluster implementation, also consider to implement SQL2005 !!! because it has enhancements like mirrored databases which is  also a high availability solution with failover possibillities,...

just to add to Michael Earl's reply :

The guideline for any RDBMS is that by default one should provide exact foreign-key...

the downside of the proposed proc is that it will start the job, even if it has been disabled !!!

Maybe it's better to implement an alert to start the job,...

Do you have an index for DateInserted and/or ErrorID ?

otherwize i guess your deletequery performs a tablescan ! this way (dead)locking may occur more frequent !

- If you have no baseline or reference, how would you define "performant" ?

Start with defining your expectations (or references to the "old" server ) regarding the time your planned...

1. what is the default lock level of sql server? row level.

2. will sql server auto escalate the lock level in some case? YES

is there any chance to a table...

update : the dev-team did put on the wrong track .... _not_ mentioning some tiny little bits ...

I went back to them and talked a bit regarding their process.

Now they...

If you have a clustered index on you account-table and that index is composed of UserId, AccountId , then pagesplits may occur when another account is created.

If you clustering index...

select

S.*

from student S

INNER join stcourse C

ON S.sid