If you shut down SQL Server there is a known bug that advances the identity values. I don't know if there is a fix for that or not.

I failed to catch the follow-up post about there being an identity column involved. Sorry!

Note to all - don't answer forum posts while on a cruise!! :blink:

This is a concurrency issue, therefore I am 99.984% certain it is a CODE issue. Something somewhere is not properly handling locking and concurrency. As for why this...

Not without quite a bit of extra information or access to your system. Sorry, but you just haven't given much detail at all.

darren_ferris (3/19/2014)

---

Thanks for your reply Grant.

Once a simulation has completed the user would then typically view the results (or a subset of the results) via our application. They might also...

Cool! So it looks like the EXISTS/EXISTS is able to very quickly exit with a hit (8 reads). Oh, I forgot to ask - are your plans estimated...

vip.blade (3/18/2014)

---

Hi,

I have a question regarding the rowversion / timestamp column. I want to use it to track changes in some tables and I created a non clustered index on...

But your 3 samples are missing the important 4th sample:

IF NOT EXISTS (

SELECT *FROM Table1 c

WHERE NOT EXISTS ( SELECT 1 FROM Table2 z WHERE z.CNST_CONSENT_ID = c.CNST_CONSENT_ID)

)

PRINT...

patrickmcginnis59 10839 (3/18/2014)

---

studySQL (3/17/2014)

---

What do you do as a dba to eliminate sql injection? application code can not be changed or altered. Or if it happens, what kind of logs...

If truly boggles my mind why an EXISTS with a COUNT(*) and HAVING is faster than a straight EXISTS check. That makes absolutely no sense whatsoever! :crazy:

mister.magoo (3/17/2014)

---

I have to say "I don't know", but it's interesting and if anyone wants to join in, this AdventureWorks query shows similar symptoms:

select count(*)

from sales.salesorderdetail

where salesorderid not in (select...

studySQL (3/17/2014)

---

Any recommendation on third party tools. I was looking into the default trace too. How about setting up a server side trace that logs all the security section of...

My recommendation in this case is probably to purchase a third party product to watch out for sql injection for you.

If it works on your sample but not when you run it on real data then you need to find out the characteristics of the rows that do NOT work...

Look around for a "how to post" article so you can learn how to help us help you. Can you give us a sample table(s), sample data, sample code...