Ideally each service should have its own account. That account absolutely should NOT be local admin, they should be limited-permission accounts.

While that's the ideal, in many cases multiple services will...

Wrong country.

The instance is throwing a lot of user errors (that could be just about anything). You'll need to investigate the instance, see what errors it's throwing and fix the errors.

Indexes aren't going to help much when you're doing select * from view. Indexes are useful when filtering data.

You have scalar functions, they're slow

You have unions, which are forcing SQL...

Unlikely. Corruption causes high-severity error messages.

You may have an incorrect page space usage. Run DBCC updateusage

Also check the columns in those indexes. If they have lots and lots of columns,...

To allow for piecemeal restores?

Because some consultant told them to...

No spare time this week, but given the cost...

If you don't use the Order By, you will get a non-deterministic order for the concatenated string values. If you need the values concatenated in a specific order, you need...

CREATE TABLE TableName (

GroupName VARCHAR(50),

variationname VARCHAR(50),

Size VARCHAR(50),

SizeOrder INT,

Colour VARCHAR(50)

);

INSERT INTO dbo.TableName

(GroupName,

variationname,

...

Hi and welcome to the forums

It's easier for people to help you if the sample data is in an easily usable state. I'm sitting in a presentation at the moment,...

Try Azure SQL Database rather than an Azure VM.

To be honest, I'd probably use an instead of trigger rather than an after trigger. I can't think of any method to interfere with an insert/update other than a trigger.

Fragmentation can increase the space an index uses. It's more likely though that the table just has lots and lots and lots of indexes each with lots of columns.

There's no value for small. I means small enough that you...

I *strongly* recommend you don't try using SQL this way.

Technically the data and log files could be created in a dropbox synced folder, however SQL Server takes exclusive locks on...