-do you experience (dead) locks during your troublesome periodes ?

- have you got deadlock reporting activated in your sqlserver errorlog ?

not everyone has sqlagent active and it lives separate from sqlserver as a service.

A startup stored procedure that sends a mail or message may be the solution for that case.

did you try using a tally table ?

Check out the articles of Jeff Moden or Lynn Pettis

set nocount on;

declare @myTest table

( person varchar(80)

...

Did you check with Gails wonderful article ?

http://www.sqlservercentral.com/articles/Corruption/65804/

Zutendaal, Belgium.

http://maps.google.com/maps?f=q&hl=en&q=Zutendaal+Zutendaal,+Limburg,+Vlaams+Gewest,+Belgi%C3%AB&layer=&ie=UTF8&sll=37.0625,-95.677068&sspn=32.885543,59.238281&z=13&ll=50.939393,5.572815&spn=0.051057,0.1157&t=k&om=0

And yes, I like good beer!

Do you mean SQLserver startup time or actual hardware startup time ?

SQLServer uptime: http://www.sqlservercentral.com/scripts/Administration/63771/

Did you notice a Missing index recomendation in your Q1 plan ?

anyway Q2 is the one that causes problems ...

It shouldn't matter .... but did you try this alternative ?

...

Another improvement I came up with is just because it always uses a fixed column combination to check for existence ..... use a checksum of those columns.

ALTER TABLE dbo.T_DBA_ConnectionTracker

ADDFastTrack_CheckSum...

Thank you for the feedback.

- Any particular techniques used in the "Attach-but-dump" database ?

- What's the db-level of that db ?

You need to figure out what is actually involved and causing the deadlock.

How To ?

This will enable deadlock info printing in your sqlserver errorlog file.

dbcc traceon(1204, 1205, 3605, -1)

This...

Yes you can:

- You can set your SSMS query properties to use ANSI implicit_transactions.

( Tools / Options / Query execution / SQLServer / ANSI )

OR

- you...

Thank you all for your replies.

Give me some time to interpret them and check them on this instance.

A little work around I 've done in the mean while, is to...

as Grant stated the intersect is meanth to compare two sets of data, based on all columns of these sets.

An inner join result set is only based on the matching...

I would prefer to wait for the rollbacks to complete, unless they take way , way to long.

GilaMonster (2/10/2010)

Don't be tempted to restart SQL. If you do that, the rollback...

What i meanth to mention is that if you have multi column DRI, you should provide a DRI matching index ( multi column, exact column sequence ) to...