Is there an actual error you are receiving?  There's not enough information here.

Your secondary is not configured to allow a readable secondary. 

If I understand your question,  you want to use the same SQL installation for multiple SSRS installations?  If that's true, I have a single SQL server that contains 4 different...

{Thousands of recompiles a day} vs {thousands of extra table scans a day} is an easy choice.  I'd have to see actual damage from the recompiles to recommend differently. ...

Yeah. Without duplicating some tests of this that I did quite...

Yes.  WHERE character_column LIKE ‘string%’

To elaborate, currently when a user calls the help desk, we need to identify the client they work for, as well as a few other things....

• This reply was modified 3 years, 11 months ago by Michael L John.

Actually you could be causing a performance problem by getting SQL to use the same query plan for different values, i.e., by avoiding the "overhead" of a recompile.  The...

Well, this is interesting. SQL 2022.  No more parameter sniffing?

https://www.youtube.com/watch?v=ncF-zFzBDAY

Search this site for "query performance" or sys.dm_exec_query_stats.

There are a wealth of queries that will tell you what you need.

This one is a start.

select top 20 
   ...

To expand upon this, and maybe provide some ideas that can ease your pain, here are some thoughts.  I had this same situation a while back. The difference was that...

In that case, please see...

To expand on the reason I'm not using other DDL scripting methods is because I'm looping through hundreds of tables and running tests on converting data types and changing...

One could argue that your plan is fatally flawed.

It should not be a backup plan, it should be a recovery plan.

As such, you likely would have discovered the answers to...

I'm with Phil.  Why are you doing this?

Can you explain further?  How exactly are you refreshing this? Backup and restore? Replication Snapshot? Something else?

Once the process completes, you then run a re-index process.  Why? Are the indexes...

• This reply was modified 3 years, 11 months ago by Michael L John.