Is this advertising your product or spam?

If you could provide more details about what the tool does and why we would want to use it, without us having to go...

As Anthony Green indicated, permissions can be granted to anything in SSRS.

What I am guessing you did is had it set up with inherited permissions, then removed permissions at the...

What error are you getting?  If you don't know, check the logs.  That will tell you why it isn't starting and give you a good starting point to resolving the...

Was just reading the error message and it sounds like the installer thinks that you are trying to install the wrong CU.

I would try re-downloading CU 22 and see if...

You missed putting a checkmark in the error.jpg.  Select "MSSQLSERVER" and it should install the update for you.

My advice - contact your license vendor.  They will be able to provide you the best bang for your buck and the best advice about what licenses you actually need.

You...

This looks like an easy one to me - Z:\ is mapped for you, not mapped for all users on the server.  So the SQL Agent service account doesn't have...

I think that is a very per-use case question.

For example, the cost to host a data warehouse is going to be different than a highly OLTP workload.

And there are a...

If I am understanding you correctly, you want to know the second largest record.  If so, one way you could do this is to do a nested SELECT TOP query. ...

From my understanding both IDX1 and IDX2 would use the exact same space.  They are holding the exact same data, just in potentially a different order.

If there is any compression...

I think I can help with that one.

IDX1 would have the 3 columns with the data ordered by OrderID, then ItemID, and finally Status.  If there were more columns in...

Looks like someone asked about this on the MSDN forums and got a few answers:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/196b4586-1338-434d-ba8c-49fa3c9bdeeb/server-collation-sqllatin1generalcp1cias-versus-latin1generalcias

The important bits from the above forum post (the whole thing is a good read mind...

Alternate to triggers, but similar idea, you could implement CDC (change data capture).

If the database table is for a custom-built app, you could also implement audit history like that on...

How many rows are in the table?

I am pretty sure that your WHERE clause is the problem, not the ROW_NUMBER portion.  The query, without the WHERE doesn't need to do...

If you load up extended events or profiler, you can see what is being run against the database.

My guess (without seeing anything) is that your shared dataset doesn't have the...