Categories:
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.
Categories:
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’.
Categories:
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.