Question : I have MySQL 8 in my Server with Ram of 2GB. And MySQL is always using 18-25% of […]
Tag: debugging
MySQL MyISAM index causes query to match no rows; indexes disabled, rows match
Question : I created a table and index as described in this SE post, but when I query the table […]
Identify mysqldump activity in MySQL log file?
Question : I have a database that is being regularly backed up by mysqldump by… something. It’s not a script […]
A workaround for restoring HierarchyId in SQL server 2014
Question : After installing VS 2015 CTP 4, HierarchyID stopped working in SQL Server 2014. This is the bug listed […]
Why is the “The package can not be saved to the file system since its protection level is server storage” error?
Question : When I execute dtutil /sourceserver localhost /SQL “Maintenance PlansMaintenancePlan_daily” /copy file;.MaintenancePlan_daily.dtsx from the answer to my question “Any […]
Finding the cause of a stuck “Sending Data” query in MySQL
Question : I’m running MySQL on a 1gb DigitalOcean droplet, and I have a number of scheduled tasks through the […]
High MySQL CPU usage, queries seem fine, not running ntp
Question : I’ve had about 48 hours of extremely high CPU usage on my main MySQL database for no apparent […]
Get the Messages stream in an SSRS RDL Report
Question : So I’m trying to troubleshoot a particular SSRS RDL Report that literally takes forever to run (mostly because […]
Object Reference Not Set … Debugging Stored Procedure in Visual Studio
Question : I’m working on updating a stored procedure that is called to update a user. This stored procedure needs […]
How do I find out *why* a user has certain effective permissions?
Question : I know that I can query effective permissions by using sys.fn_my_permissions: USE myDatabase; SELECT * FROM fn_my_permissions(‘dbo.myTable’, ‘OBJECT’) […]