According to Paul White (and what I heard early on when they first started meta-caching of Temp Tables), dropping the tables does NOT prevent caching of Temp Table meta-data.

https://sqlperformance.com/2017/05/sql-performance/sql-server-temporary-object-caching...

Shifting gears a bit, I'm hoping this year that work will be happy to pay (or at least contribute) to me getting out and going to some SQL based...

Heh... if I were really smart, I'd just up and...

Heh... if I were really smart, I'd just up and retire.  That...

Hi, It is possible to do in place upgrade. What is the error you are receiving in DEV environment. You need to run upgrade advisor to get which components...

1. Can you post the table schema and sample data for the tables INGREDIENTS_NAME, Recipes_Name, INGREDIENTS?  See the link in my signature.
2. This post originally started about multiple values in...

ALTER PROCEDURE INSERT_INGREDIENTS
    @Recipes_Name varchar (255)
   ,@INGREDIENTS_NAME varchar (255)
   ,@QUANTITY varchar (255)
   ,@UOM varchar (20)
AS
BEGIN

   ...

Is this a parameter in a stored procedure?

If so, then use a table valued parameter and then it's very simple.

If these are physical machines, and they started out as SQL 2008 boxes, then it's time to upgrade not just the software but also the hardware.  There's no way a...

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

There's nothing that should prevent a CNAME from working.

Also, it's not that difficult to rename a server.  You would need to remove the existing server from AD, rename it and...

What have you considered?  Have you tried anything yet? Do you have a time frame that this needs to be completed within? Is your on-prem SQL 2017?

The possible methods are...

Both the I/O latency and the I/O frozen issues are caused by Volume Shadow Copy service, which is being called by Veeam.

I am not that familiar with Veeam, aside from...

A related problem I see is that they know where the data is, but the same data is in so many different places there is no understanding of what source...

Are you also seeing "i/o is frozen..." messages in the logs?  If so, Veeam uses Volume Shadow Copy service to backup the individual database files.  Even though these last a...

If the user is connecting using a SQL login, then the service accounts running SQL and SQL Agent need to be granted access.

If they are connecting using Windows Authentication, then...