Question : We have SQL server and Oracle server, and have configured a linked server from SQL Server to Oracle. […]
DbaFix
MySQL Database Archive
Question : We have 300 databases in our environment mixed of MyISAM and Innodb(innodb_file_per_table has been enabled) tables.Using MySQL 5.5.19 […]
Two “Connect SQL” permissions in SQL Server 2012
Question : What is the difference between these two “Connect SQL” permissions in SQL Server 2012? Answer : While I […]
How to improve INSERT speed in large table that has unique constraint
Question : I have a simple MyISAM table: explain entities; +————+————-+——+—–+——————-+—————-+ | Field | Type | Null | Key | […]
MySQL/MariaDB data directory backup
Question : I am using a solution of backblaze B2 / duplicity / duply to create backups of my databases. […]
How to get goup concat of count value using sub query
Question : I’m trying to get group concat of count value here table below I want this structure: | y […]
Index Seeks cost of OR operator
Question : I have a query which is slow and it takes 15 seconds to execute. The query fetches data […]
Oracle SQL create view privileges
Question : This is more of a theoritical question but I need help ASAP. Here it is: With the appropriate […]
Can I get results from a Postgres query that I got disconnected from?
Question : I started an hours-long Postgres query in my psql shell. Then, I got disconnected from the network and […]
How do I return all column values for the recently inserted row/rows?
Question : I have these two tables in a PostgreSQL 12 database: CREATE TABLE public.test ( entity_id uuid PRIMARY KEY […]