That's great information. Thanks, Jeff!

So to address the IFI question, yes I do have IFI enabled.

The 1 GB auto growth on the data file doesn't concern me as much since IFI should mean this...

Thanks, Jeff!

I completely understand your rationale for shrinking the log file to 0 for the reasons you mentioned, but let me ask—in your experience, how resource intensive is...

Ouch! Ok, sounds good. Thank you!

Thanks, Jeff!

I completely understand your rationale for shrinking the log file to 0 for the reasons you mentioned, but let me ask—in your experience, how resource intensive is the growth...

Thank you so much for your response! Your query gave me some good ideas. I'll need to test it a bit more, but I think this will do it!

            
September 7, 2019 at 1:52 pm
            
#3678192

            
            
                                                
        

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 5 years, 6 months ago by  Mike Scalise.
• This reply was modified 5 years, 6 months ago by  Mike Scalise.