If you ever need to know what is database name based on a data or transaction log file location, run the following T-SQL code.
The following command effectively gives the user permission to execute ALL stored procedures in the database:
Display estimated time for backup and restore operations.
List of currently active sessions for each database on your servers.
The query generates a DROP statement for all auto-created statistics to all databases.
An estimated execution plan is a SQL Server query plan that is generated without actually running the query. An actual execution plan is the SQL Server query plan that is generated after a query was executed.
How to grant execute permissions to xp_cmdshell without sysadmin privileges? Error: The EXECUTE permission was denied on the object ‘xp_cmdshell’, database ‘mssqlsystemresource’, schema ‘sys’.
One of the important things that we look at to improve performance in database environments that have performance problems is the ones to find out queries that use the most CPU and Disk.