Also state which columns you want to select.

- Only from table1 or from both tables ?

- How can you differentiate both result sets ?

I have a slight impression...

As Elliott W stated, it will not start a second instance of the job.

It will register a message in sqlagent.out that the job was already running. 😎

Keep in mind there is more to service broker than meets the eye !

First read a bit about it, so you know what it is all about and you...

:blink: that also goes for the minor changes in the pricing model(s) ...

if you ever succeed to pull out the needed data from your sqlinstance itself .....

:sick:

-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...