To chime in on the job postings, interviews, and even the credit check stuff:

Job postings are almost never accurate. When I was job hunting last year, I had two...

GilaMonster (9/28/2011)

---

WayneS (9/28/2011)

---

Grant Fritchey (9/28/2011)

---

Jack Corbett (9/28/2011)

---

Hey can an execution plan expert (Grant?) take a look at this thread, http://www.sqlservercentral.com/Forums/Topic1181619-338-1.aspx. Interesting behavior noted in execution plan properties with SET...

I'm using 2008 R2 Dev Edition, and I get the correct settings per the script.

Try these two versions. (Dev/Test environment, of course.) What kind of performance and execution plans do you get with them?

UPDATE dbo.ParsedMessage

SET p.EventGuid =...

tfendt (9/27/2011)

---

Yes, it says it is not required, but it doesn't say that it wont help keep the memory from paging out. I am aware that the AWE allows 32...

SQL Kiwi (9/28/2011)

---

WayneS (9/27/2011)

---

• DBA Certification preferred in SQL Server versions 2000, 2005, and 2008.

• ...

GilaMonster (9/27/2011)

---

Steve Jones - SSC Editor (9/27/2011)

---

Not that I'm asking for more political debates here, but if it comes up, nothing wrong with a little (meaning short, for Gail's sake),...

Sean Lange (9/27/2011)

---

GSquared (9/27/2011)

---

Looks like The Thread may have killed the rest of the forums.

The Active Threads link is only showing 5 other discussions.

(Probably my fault for going political in...

Looks like The Thread may have killed the rest of the forums.

The Active Threads link is only showing 5 other discussions.

(Probably my fault for going political in here. I...

Sorry, I'll shut up now.

There are already strict laws in place protecting anonymous and non-anonymous safety violation reports, in the US. A worker is more likely to never need to work again if...

I seriously doubt this is doing anything useful in your query, since the Join math already enforces that rule.

AND f.EventBegin >= (SELECT MIN(MessageDateTime) FROM dbo.ParsedMessage)

Can you post the execution plan?

Nope, that's not what I'm claiming. I'm stating that this is one of the responsibilities of government, inspection of workplaces for safety.

If you ran into that kind of situation and...

Stefan Krzywicki (9/27/2011)

---

GSquared (9/27/2011)

---

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

GSquared (9/27/2011)

---

It's a pretty fair bet that some people would assume I'm a pretty rabid conservative. On the...

The problem is this part:

EXEC @Percentage2012 =

When you do that, you are setting the variable to the return value of the executed procedure. Not the output parameter, the return...