Perhaps you're the frog in water that's being heated so slowly that you don't realize how poor your current situation is for your health.

I've been that frog. My best job...

• This reply was modified 7 months, 2 weeks ago by  alex_pixley.

In addition to EdVassie's reply, I would urge you to expel at least one of the SQL2014 nodes from the Availability Group *before* failing over to any of the SQL2017...

I actually...

Shawn,

Thanks for the reply. I was looking for something simple that could be run on demand. If SSRS can't do what I've described, I'd rather build an SSIS...

If I get rid of partitions 8-13 and then implement sliding window on a yearly basis, I will never have more than seven years worth of data. In reality,...

It's like insulating your home. There is the upfront cost of time and effort. The...

mssqlsrv (8/7/2014)

---

Pls check on below link. Might be helpful.

http://www.patrickkeisler.com/2013/01/how-to-remove-undo-table-partitioning.html%5B/quote%5D

This link doesn't show exactly what I'm looking for, but I think it might get me to where I want...

Yes, adding disk space is easy. In some environments, however, getting additional disk space approved and implemented is a painful process. Right now, I have 13 partitions and...

Igor, Gail,

Thank you both so much.