If you're moving the entire data set every time, I don't think a relational database is the thing for you. It's adding all sorts of overhead that just doesn't seem...

You want to look at Extended Events. sp_cache_remove is the key to understanding what's going on. Here's an example session for detailing cache behaviors:

CREATE EVENT SESSION...

>>>>Eirikur Eiriksson wrote: >>>Grant Fritchey wrote:

>>Sean Lange wrote:

>And in other news....I have taken the plunge. After almost 25 years as a developer I have just accepted a new...

And in other news....I have taken the plunge. After almost 25 years as a developer I have just accepted a new position as a full time DBA. Even more...

Yep. It was down, but now it's working.

A spreadsheet into the database is pretty much any of the standard stuff. You can link to the database from Excel and insert from there. You can script stuff out...

I see Id & fbocode, the PK from the table, in the other table. Aren't those the correct columns?

HA!

WHAT?!?!

No, surely a purely manual process across lots of servers will be perfectly...

How about if we can have an article for multi subnet AlwaysOn (without stretched VLAN) involving one node in Azure as well.

I think that will cover 2 major topics

-...

He's got a backlog, but I'll...

Carriage return and line feed acts as a secondary terminator. The one most people use most of the time.

Oh, absolutely not worth an argument over. It's long been a bit of an issue the lack of support for Azure through SSMS. It's there... mostly, sort of, as long...

We had a directive from corporate to upgrade all our server OSes to 2019. I was informed by IT that they were going to in-place upgrade the SQL Server...

PostgreSQL also sort of, but sort of doesn't, require semi-colon's.

Logins are not really a thing in Azure. I mean, they are, but they're not. It's down to users at the database level. It's key to always think of the...