phegedusich (1/24/2014)

---

"While we considered changing to a bigint, this was a third party product and they did not want to allow us to alter the schema."

There's your problem. Perhaps testing...

Jeff Moden (1/28/2014)

---

Thank you both. That's more inline of what I thought CMS should be for. What I've found is that a lot of people have written PoSH...

I believe you can export the CMS settings and save them. However, as Roy mentioned, not a big deal. It's just a place you connect that sends your queries to...

If you want service packs, let Microsoft know. I think they're on the fence right now, but it takes some voices voting to get them to continue with SPs.

Vote on...

I try to run daily (We do at SSC), but weekly at the latest. Once you automate it, it's not bad.

There are people that run monthly, or less frequently (including...

The Yankees used to do better, build better farm systems, and grow players, but they've gotten out of the habit and are too afraid of not having big names.

I hate...

Never had SQL run for 18 years, but I have had it run for 2. The problem I've most often seen with long running SQL stuff is Windows. Too many...

Hugo Kornelis (1/24/2014)

---

My guess is that the information on that page you used is incorrect. But I have...

djackson 22568 (1/27/2014)

---

Steve, which came first, the chicken or the egg?

I recognize that...

paul.knibbs (1/27/2014)

---

What does "provide more value than they cost" mean? Sounds like you want workers to do more work for the same money, but I'm sure that's not what you...

I'm with you, Dale. Convention has "who" listed as more likely, but both apply:

http://english.stackexchange.com/questions/11204/how-to-use-who-vs-that

Not an outer join, right? You just want something returned?

Can you give a result set example of what you'd want here? Is it just the first 2 columns with null...

Read that article, and then give us some DDL For your result set and some sample data as insert statements. We can help.

I'm with Gail. If it's too resource intensive for your workload, run the physical only on the servers. However, make sure you restore a backup and run the full DBCC...

The pros:

You can easily repeatably execute queries against all servers (except the CMS, though there's a workaround). This is very handy for administrators that try to standardize and manage servers...