Question : On a production server of ours the page file has grown to 30gb+. The Sys Admin has moved […]
Author: admin
Is there a way to hide mysql innodb cluster queries from general_log?
Question : When I start my innodb cluster I get many lines of cluster related logs in the mysql general_log […]
Why does query runtime dramatically increase when made into subquery?
Question : I’m working on a query that selects counts from 2 servers and joins those together. Here is what […]
Migrate from innodb_file_per_table to off in MySQL
Question : We have a large number (2,500+) of databases and users in MySQL 5.6 on a single virtualized server […]
Modify the IO cost computation formula in MS SQL Server to reflect negligible SSD seek-times?
Question : The query optimizer of MS SQL Server seems to use a fixed formula for estimating IO costs. This […]
How to design index for faster deletes
Question : I want to speed up following piece of code delete from ssn_sdo where (art_id=@art_id and skl_id=@skl_id and @level=0 […]
Odd error when stress testing against an AG
Question : We are running into an odd error when trying to stress test our application that hits an AG. […]
MySQL permission denied for database
Question : I have a remote MySQL server running on x.x.x.x. And there is a database named abc. I can […]
Parent/Child Relationship Table Design – What’s The Best Practice?
Question : I have a single table for storing ‘Tasks’. A task can be a parent and/or a child. I […]
Step by step establish a connection between SQL Server 2014 and Oracle 12c
Question : I have two servers (both servers are on Windows OS): Server_A running Oracle 12c Server_B running SQL Server […]