Yes, my bad, but on the other hand when one 1 person works on one DB  is not going to be able to run multiple Queries, usually you are...

Looks like you are going to need to use dynamic SQL and you are going to have a bad time with that I fear. Why? because what happens if someone...

With regards to your "what can a database owner" do, google is your friend there. But to summarize, DBO can do anything on the database level. You can access and...

Each INSTANCE of SQL Server would have it's own tempdb. I think Martin's suggestion was to have a single INSTANCE with multiple DATABASES. This would end up sharing the same...

My opinion - where I work we started with the development team being in a room on their own with low noise (little bit of chats between the 20-ish developers...

If I had to guess, whoever designed that was truncating the table then looking at the statistics for that table and seeing that the statistics indicated there were rows in...

I am 99.9999999999% sure that the problem is not on the SQL side - that is an application bug. SQL takes a query and provides results. There is literally no...

My opinion - that's pointless. Statistics tell you information about your table data. If the table is empty, the statistics are (mostly) useless. You need data in the table for...

100% agree with Drew here and in your specific scenario, JOIN may perform better or worse. My advice is to test on your system as is (ie don't add extra...

With desktop versions of windows, if you see 90%+ memory being used, (14.5/15 GB), that is a good sign stuff is being paged to disk. Windows tries to not let...

Personally, I would test. If you to to your SSRS instance, can you "export" or "download" a folder? I cannot, but I'm also not on 2016 (I'm on 2012... I...

Your reports are NOT stored inside the SQL database if I remember right. It is metadata and jobs that is in the database side. So if you don't back up...

My advice - check the docs first. ALWAYS ALWAYS ALWAYS check the official docs as things MAY change between versions. Link to 2022 - https://learn.microsoft.com/en-us/sql/integration-services/security/integration-services-roles-ssis-service?view=sql-server-ver16

As for the sysadmin, I would...

As a different approach, any chance you could spin up SharePoint? It solves most of your problems as it allows for file storage, quick searching (no need for ElasticSearch), auditing...

My understanding is upgrading from standard to enterprise is something that can be done without issue.

Now, that being said, I would STRONGLY encourage you to do the transition on a...