Okay, I'm confused by the bolding of my name randomly in this post:

http://www.sqlservercentral.com/Forums/FindPost1278324.aspx

Is that supposed to mean something or am I just over-sensitive due to frustration with a completely different...

This, I believe, will work better for you:

DECLARE @currentDate datetime = ' 2012-03-22'

SELECT DISTINCT

DC.DoctorID, ca.StatusCode

FROM schDIA.tblDoctor AS D

INNER JOIN schDIA.tblDoctorContact AS DC ON D.DoctorID = DC.DoctorID

INNER JOIN schDIA.tblDoctorLicenseHistory...

bullo (4/4/2012)

---

it runs VERY fast , but runs SUPER slow on sql server. I cannot understand it. i made every latency test.

Probably something to do with SQLEXpress, but I dont...

Mac1986 (4/4/2012)

---

Thanks a lot Evil: I will try to locate the that particular Update statement on Workqueue table.

But we have 17 jobs getting kicked of every 5 mins and all...

Questions:

Is '" &this_claday_starttime& "' the start time of the class in question or the start time of the day for all classes? Same question for '" &this_claday_endtime& "'

What does...

Alright, these statements are deadlocking:

UPDATE dbo.WorkQueue

and the first select that uses WorkQueue which drops to a table variable.

Since the second statement could only lock up WorkQueue, I won't have...

GilaMonster (4/4/2012)

---

No. It's a deadlock, processes 76, 85 and...

Brandie Tarvin (4/4/2012)

---

I'm stealing these name spellings for a story. @=)

You guys wanna be villains, heroes, or...

That graph looks incomplete. It's almost all SPID 25, so unless it's deadlocking itself, that won't fly well. Is that the full graph or did you edit it heavily?...

You need to google the keyword: Pivot.

After that, if you want more complete help, please see the first link on the left in my signature below to setup staging data...

sqlmaverick (4/3/2012)

---

i haven't seen something blocking in sysprocessors, but for hundred records it is executing fine but when the count increase to 10000 records. It keep on executing. So...

Have you looked at sys.sysprocesses while it's running to determine if it is being blocked? That's not a code issue, that's a concurrency issue (unless you're deadlocking yourself, which...

TeraByte, to answer your question and to try to ease future pain of concurrent attempts to insert, which is what Orlando was leading to, can I recommend you take steps...

I agree with Elliott that you're using a best practice scenario there with what's available. For more complex decisions I'll occasionally use an asynchronous script component that will simply...

Ah,...