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...

So, just saw a story that indicates Tom Clancy may have passed away.

I quite enjoyed Red Storm Rising and Hunt for Red October. Sum of All Fears was OK,...

Yeah.

I should've mentioned in my reply to Gail, I have hit the "Report as abuse" button on them...

Thanks. I initially held off on doing that, kind of felt like bringing gun to a hammer fight...