Rich Mechaber (2/11/2016)

---

And here I thought SETUSER was...

below86 (2/11/2016)

---

Ok, maybe I'll understand better when we get further into it. But using the failure happens at 3 AM and I need to look at why Stored_Proc_XX failed,...

MDS keeps the data, but it centralizes what you might do with reference tables.

It's a product in the category of MDM, master data management.

If you enjoy the 80s, I might recommend Ready Player One as a read. Lots of memories in there.

http://www.amazon.com/Ready-Player-One-A-Novel/dp/0307887448

More fulls can be better, but I like simple over complex. I would think about the issues with administratively managing full/diff/logs and performing restores.

That being said, I might do fulls...

Ian_McCann (2/11/2016)

---

krypto69 (2/11/2016)

---

did you try changing the compatibility level to check for cardinality issues?

We have had many and some times the quick way to tell for sure is to switch...

This really depends on your application and control of the database. If you can move historical data to another database, that's what I'd recommend there. Then you can have separate...

I was just thinking about re-watching Wargames. Just went through Spaceballs while on the treadmill and it brought back memories.

I leave things at Consolas, but make the font bigger. 12 or 14 😉

I haven't heard from Lori.

I'd like something here on the topic, more along the lines of what's in your comments. IF you'd like to write something up, I'd appreciate it.

Take it

SQL Prompt is working on a personal license. I'm not sure how it would work if you use lots of machines, but you certainly could have it on a single...

I side with Hugo here, you shouldn't need the log file. In fact, you probably can shrink this down as low as possible for your database. I'd guess 1MB would...

SQL Prompt and Search for me. Of course, I work for Redgate, so I get the former.

I change fonts usually to make it easier to read.

That may be the biggest...

Apologies, the hex value wasn't well formed.

I've changed this to return 000 now