Once a file size is allocated within SQL Server, it stays allocated. You can delete every bit of data from a 5tb data file, and the data file will still...

Done!

Fixed the accidental spam.

Maybe. It depends on the demands of the app and if it can use the newer version. In some instances, yes, you'll be able to just uninstall 17 and everything...

An execution plan is your best friend when it comes to understanding what's happening on a query like this, especially after you change it.

GRANT WITH GRANT

What?

Might want to listen to what @Ant-Green is saying on this one.

The broader the key, the more likely an index is to fragment. More keys, more fragmentation. Overall though, I'd only worry about fragmentation if you can prove, and I mean...

The broader the key, the more likely an index is to fragment. More keys, more fragmentation. Overall though, I'd only worry about fragmentation if you can prove, and I mean...

Yeah, a lot more data is needed here. What command were you running? Which version of SQL Server? I do not recognize this message, so I'm unsure what to do.

Based...

Or, have the job query a table for the parameter values and then give yourself permission to edit those. Not ideal, certainly, and a lot more work, but it does...

You might be able to do this programmatically through GitHub actions or workflows. I haven't done this, so I'm a little unsure what would be best.

Generally, even when branching...

Generally, we would create a group within Windows security, give that group access to the database, then add or remove users from the group. That way, we didn't have to...

The SQL Server service is what manages the databases, so yes, if that is appropriately in place, you should be able to connect to the database.

I do radio as a hobby (yeah, I know, I'm worse than a cross-fitter, I won't shut up about it). The fun thing about the hobby is that you can...