Drew,

I feel like such an idiot. You're absolutely right about the parentheses. That solved problem #1.

I knew the text data type was deprecated but never thought to CONVERT or CAST...

Hey Mike, Thanks for getting back to me so quickly. Yeah I also looked into the session timeout setting but this  document https://blog.dbi-services.com/sql-server-alwayson-and-availability-groups-session-timeout-parameter/ states that it has no...

Mike, I think I'm having the same issue as you. It looks like VMware is kicking off a snapshot process and then it's causing a node to lose connectivity...

I came too late into this conversation and I hope I make sense. Option 2 is not bad.  However, if I had to take that route then I would...

...So if I use synonyms instead of views (and the reporting tools use those instead of the views behind-the-scenes), what would the synonyms themselves point to so that...

Thanks, Jeff. I'm not at all opposed to using synonyms, but using views (with original table names) on the target would allow me to use the queries I would have...

Hi Mike One of our solutions here uses a snapshot of a replicated database to replace a backup/restore process which used to take hours (about 12 of them). We...

Jeff,

You ask some great questions. Are you suggesting that I create a separate database with only views (that are named with the original names of the tables I would've refreshed)...

Hi,

It might be worth looking at Partition Switching as a possible option as well:

https://www.jamesserra.com/archive/2012/07/sql-server-table-partition-switching/

Thank you! I'll look into that!

• This reply was modified 6 years, 12 months ago by Mike Scalise.
• This reply was modified 6 years, 12 months ago by Mike Scalise.