You can find what procs and triggers are calling it with a search such as:

SELECT s.name AS schema_name, o.name AS object_name, o.type_desc
  FROM sys.objects o
 ...

No, new features would not be available if the entire database is in compatibility mode.  If you are able to examine the execution plans and figure out which queries are...

When running on the SQL Server 2016 database, you are using the new cardinality estimator, and there may be a query as part of the SAP dataflow that performs differently,...

The problem could be related to this note in documentation:

https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-transact-sql?view=sql-server-2017#with-grant-option

since you gave "GRANT EXECUTE" permission to a role, you may have needed "AS dbo" clause.  Since you granted CONTROL...

Since the 2 errors involved, 297, 300 are just normal severity errors (16 and 14 respectively) they will not be put in the error log.  Since this is just a...

You would probably want to use OUTER APPLY instead of the CROSS TAB approach then:

SELECT LEFT(d.name,20) AS DBname, LEFT(d.state_desc,10) AS StateDesc, LEFT(d.recovery_model_desc,10) AS RecoveryModel,
   ...

You should check out the DMV sys.dm_db_partition_stats:

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-partition-stats-transact-sql?view=sql-server-2017

This has columns lob_used_page_count, lob_reserved_page_count, and can be queried like this:

SELECT object_id, index_id, SUM(used_page_count) / 128 AS size_MB, SUM(used_page_count) AS...

Depending on what you are looking for, you can probably find at least some information on one or the other of your requests, but probably not both.

If the object in...

It seems fitting that Entity Framework would be described as modifying databases that way 🙂

What are you expecting needs the RAM that SQL Server is holding on to?  Freeing buffer or proc cache won't necessarily reduce how much RAM SQL Server is using, it...

If you want to analyze something that has already run, the quickest way to look at it is through the internally stored query stats:

SELECT TOP 25
 ...

Grant's advice is great, and he really is a top expert on the subjects at hand, but for someone new to SQL Server going through all that is like drinking...

I've seen this behavior if the already open SSMS program has a modal window or dialog box outstanding, then it can't respond to the operating system's request to open the...

I tend to set the database to the RESTRICTED_USER mode, I think it avoids the problem with SINGLE_USER mode since there are far fewer people who have SYSADMIN, DB_OWNER, or DB_CREATOR...

SentryOne Plan Explorer is a free tool that can help you better understand what is happening in an execution plan.  It also has the ability to "anonymize" the plan so...