To fetch an execution plan from SQL Server's buffer cache (i.e., the in-memory cache of execution plans), you can query the dynamic management views (DMVs) that SQL Server exposes.
2025-04-30
22 reads
Explanation: sys.databases contains information about all databases on the SQL Server instance. • HAS_DBACCESS(name) = 1 filters out the databases you dont have access to. •ORDER BY name sorts the result alphabetically.
2025-03-04
168 reads
By Steve Jones
lookaback– n. the chock of meeting back up with someone and learning that your...
Regarding managing databases in the cloud, security should never be an afterthought. That’s where...
By Steve Jones
In a couple of weeks, I’ll be in New York City for the Redgate...
Comments posted to this topic are about the item Deleting a Database
Comments posted to this topic are about the item Data Analyst AI tool
Comments posted to this topic are about the item Removing Log Shipping
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers