I have been sitting here with an upgrade to an Oracle 10 system lingering on the books for the last 2.5 years.  I am thinking of having a little party...

The problem is that charindex will return the position of the beginning of the token (files_), rather than the position of the end of the token.  If you add 6...

OK.  Found the relevant bit here: https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver15

db_securityadmin

Members of the db_securityadmin fixed database role can modify role membership for custom roles only and manage permissions. Members of this role...

You can get around this, by creating a role, and adding that new role as a user to the db_datareader group.  Then your user can add members to the new...

You probably want to have a look at the COALESCE function:

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/coalesce-transact-sql?view=sql-server-ver15

This is assuming that the query you have already has all of the required columns available in the...

I would be tempted to run perfmon alongside the event session, to see if the number of Batch Requests/sec does not also jump at the same time.  It may be...

Actually, my first thought is probably a little off.

The difference is in the predicate on the table Podrobnosti (P).  Since the (first) inner join is on the TaxonAutoID, it can...

Think of "Left Join" as a different operator from "Inner Join".  That is why SQL Server is needing to generate a different plan.  Unless you put in parentheses to force...

I think the order of operations regarding the left join is coming into play here.  The optimizer is leaving the door open to the join between P and T filtering...

Instead of setting the database to Single User mode, you may have been able to simply set that database offline, then drop.  Drops of offline databases do not include file...

For item 1, you can try the v$license view to see what the high water mark is for sessions.  The users may not be actually running anything with those sessions,...

I agree.  The uninstaller could use a bit better wording.  I have been caught trying to uninstall some feature or other, and thinking exactly that the whole installation would be...

Heh.  I think you trust me more than my boss does 😉

Hmm.  Same query plan?  Are there any external influences?  References to other databases, linked servers, or even custom CLR types/functions?

Biggest question is going to be where are the ReportServer and ReportServerTempDB databases?  If they are on the local database engine, then they would have to be moved somewhere with...