I'm presuming that such a trigger would have better performance than the function (function has to work on every row where the computed column is selected, trigger catches the problem...

That was my first suggestion, but according to the Dev, the people who send...

Once more, thanks Gail!

The Dev put together a function to check for non-numeric characters, and if found, not create the computed value. In theory, the application which uses this...

Stefan Krzywicki (10/7/2013)

---

jasona.work (10/7/2013)

---

Stefan Krzywicki (10/7/2013)

---

Greg Edwards-268690 (10/7/2013)

---

Steve Jones - SSC Editor (10/7/2013)

---

Stefan Krzywicki (10/1/2013)

---

Grant Fritchey (10/1/2013)

---

Please. For purposes of employment, some of us cannot comment on politics because no...

All hail the great and powerful Gail!

With a couple suggestions, she put me on the right track to find what was breaking an update stats maintenance plan!

Which I was then...

OK, found a better way then the cursor, and already tried it.

Used this:

select

name

, STATS_DATE(object_id, stats_id) as LastUpdated

from sys.stats

where object_id = 735341684

order by LastUpdated asc;

to see which stats hadn't been updated...

That's going to be fun...

😉

56 auto-created stats to check, plus one on the primary key. Well, no one said this job would be easy!

Hmm, time to see if I...

While I do have an Agent job that runs DBCC CheckDB once a week as well (at a time that doesn't impact any other jobs,) I'll manually run it as...

Stefan Krzywicki (10/7/2013)

---

Greg Edwards-268690 (10/7/2013)

---

Steve Jones - SSC Editor (10/7/2013)

---

Stefan Krzywicki (10/1/2013)

---

Grant Fritchey (10/1/2013)

---

Please. For purposes of employment, some of us cannot comment on politics because no matter what side...

Coily

😀

(Link goes to an MST3K short)

SQLSteve (10/4/2013)

---

DaveDB (10/4/2013)

---

Hello,

This is kind of a basic question, but I'll ask anyway lest I look bad in front of my boss....

I have to upgrade a 2005 SQL box to...

If you can, and if there's room on the remote box, just copy the entire CD to a folder on the SQL box, and run setup from there.

That's essentially what...

Tesla

Ed Wagner (10/3/2013)

---

jasona.work (10/3/2013)

---

It was bad enough around here when it was just "furlough Fridays" or "furlough Mondays..."

But a furlough week? And the guy who would normally sit next...

It was bad enough around here when it was just "furlough Fridays" or "furlough Mondays..."

But a furlough week? And the guy who would normally sit next to me (Oracle...