The only real "success" is for the 3rd party hack cashing the checks. Anyone trying to implement or maintain this system is, as "The Big Bang Theory" put it,...

Jeff Moden (1/28/2013)

---

My personal opinion is that if you're not going to persist a calculated column, write a derived table or view, instead. That way, no one can screw...

Just curious:

How did you determine that the deadlocking was due to FK lookups?

Legitimate FKs should be used when possible. FK definitions in SQL itself are vastly more efficient...

ScottPletcher (1/25/2013)

---

MyDoggieJessie (1/25/2013)

---

And Yes, changing the job name itself would still cause an issue, however hopefully changes like that would be made by a DBA or otherwise communicated that a...

MyDoggieJessie (1/25/2013)

---

And Yes, changing the job name itself would still cause an issue, however hopefully changes like that would be made by a DBA or otherwise communicated that a change...

MyDoggieJessie (1/25/2013)

---

newdba_sql (1/25/2013)

---

Yeah... For somereason I was putting job name but not the job id......:w00t:

So this script will check if the job's last run status is successful, then it will...

Sean Pearce (1/25/2013)

PLEASE NOTE: You have not aliased all your columns so I have no idea which tables they come from. You must edit the following queries to remove any...

Of course if you just code your dates as 'YYYYMMDD', conversion always works, and you don't have to waste a second on any of that other garbage.

The two big advantages of computed columns are:

1) a consistent definition;

2) defined in...

Lowell (1/24/2013)

---

i thought it was clear: i read it as howard saying there is no need to mark an calculated column as persisted in order to index it...it's not a...

An extraordinarily large table (which I'll abbreviate "xlt" for convenience) can indeed cause unusual issues.

If you use tempdb, it needs (lots of) extra disk space, which basically can't be freed...

ISDATE() is reliable for what it claims to...

Then you've got a second issue that needs addressed! 🙂

Increase the size of tempdb until you have "slack" except...

HowardW (1/24/2013)

---

ScottPletcher (1/24/2013)

---

HowardW (1/24/2013)

---

ScottPletcher (1/24/2013)

---

That's not necessarily always true. You might persist a column if its...

HowardW (1/24/2013)

---

ScottPletcher (1/24/2013)

---

That's not necessarily always true. You might persist a column if its requires significant...