You might not need a full day's, but I'd roll one of those full's each day (first/last) to another disk.

Grumpy DBA (2/11/2016)

---

Thanks Steve, just read some...

Always, always, always keep two fulls and the logs from the earliest one forward.

You never know when you will lose a file or have disk corruption on that file.

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