Categories
Articles
Do you offer ASPState database on SQL Servers?
We looked into this thoroughly and found that its a huge security risk as the ASPState database...
Run a SQL Query on Database
By default Plesk does not give full access to run most SQL Queries on a database.2 options...
SQL Query to find highest CPU usage by database
WITH CPU_Per_DbAS(SELECT dmpa.DatabaseID , DB_Name(dmpa.DatabaseID) AS [Database] ,...
The query has been cancelled because the estimated cost of this query
The error : The query has been cancelled because the estimated cost of this query (xxxx) exceeds...