Ok, so you basically need to prevent the processing job from running while the transfer job is active. Right?

You could use this stored procedure and add a "semaphore" step at...

Use partition by:

SELECT 'HANSEN8',

'2010-07-01 00:00:00.000',

A.ADDRKEY,

'...

Could be something like this:

JOB x ON SERVER1:

STEP 1: Process data

STEP 2: Start job y on SERVER2

JOB y ON SERVER2:

STEP 1: Process data

STEP 2: Start job z on SERVER1

JOB z...

I don't know if this is exactly what you're after, but should do the trick:

DECLARE @pivotSource TABLE (

SourceID char(3),

VisitID int,

Query varchar(10),

Response nvarchar(255)

)

INSERT INTO @pivotSource

...

Behind the scenes, the table gets dropped and re-created.

If it holds lots of data, timeout expires from SSMS.

Do it manually or, even better, add a new column with identity attribute,...

I'm facing the exact same problem in my DB (SQL2005 sp3).

In my scenario, often it's due to bad parallelism. The serial query runs 10 times faster, but the optimizer seems...

If the parameter is dynamic (no need to restart server), it's listed here:

select *

from sys.configurations

where is_dynamic = 1

This should do:

SELECT DBName = DB_NAME(),

Owner = USER_NAME(so.UID),

TableName = so.Name,

...

Paul White NZ (10/12/2010)

---

I started off with good intentions, but it kinda got away from me...

Agreed.

Ok, I give up.

Everything I used to know (or thought that I knew) falls apart.

:hehe::hehe::-D:-D:hehe::hehe:

Oh, come on! (S)He's got a wonderful...

OK, it might be wrong, but the myth has spread a lot:

http://www.dotnet4all.com/snippets/2008/04/performance-tip-1-avoid-non-sargable.html

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbugen9/00000463.htm

http://www.zimbio.com/member/VijayaKrishnaBirju/articles/YBba8bxGDyt/sargable+vs+non+sargable+queries

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.11.0.1/dbusage_en11/predicate-queryoptimization.html

http://www.devarticles.com/c/a/SQL-Server/How-to-Perform-a-SQL-Server-Performance-Audit/8/

http://www.truthsolutions.com/midlandspass/presentations/20070301_MidlandsPASS_Bkelley.pdf

... and many others.

I find hard to believe that this myth can survive in many technologies (SQL Server, Sybase,...

Paul White NZ (10/12/2010)

---

Gianluca Sartori (10/12/2010)

---

You will see that both IS NULL and IS NOT NULL are implemented with an index seek. I can be in doubt about IS...

Thanks for chiming in, Brandie.

What I find surprising, is the predicate "IS NOT NULL" using an index seek.

WTF???!??!