Question : The task is to SQL a bunch of surveys in order for the researchers to have examples for […]
DbaFix
Users complain that system runs slow when mysqldump is in progress
Question : The MYSQL database (ibdata1) is of size 73 GB and is configured to run as a dedicated database […]
Replacing Postgres User
Question : I’m new to postgres. It might sound a silly question, due to some security requirement I need to […]
Getting Max for partition column in clustered columnstore index
Question : SQL 2014 Enterprise I have a datawarehouse table with ~ 800 million rows (total table size ~25 GB) […]
Data sync between two local Mysql databases in different system in same netwrok
Question : I am using mysql as database for my application and for the purpose of fail over and I […]
Is it safe to disable sync_binlogs, innodb_flush_log_at_trx_commit and innodb_doublewrite on a site-redundant galera cluster?
Question : On a site-redundant galera cluster, a commit should only return after a quorum of database nodes have accepted […]
Deny certain user from updating certain rows [duplicate]
Question : This question already has an answer here: SQL Server Row by Row Access (1 answer) Closed 2 years […]
What is the best way to add optional update in procedure in transaction?
Question : Currently I have a procedure that performs 4 operations in the Transaction: Update record in table A Update […]
Is it important to release memory back to the server?
Question : I have a SQL Server 2008 R2 instance running on a production system. I’m not a DBA; I’m […]
Why does “CREATE TABLE IF NOT EXISTS” lock a table?
Question : We recently run into “waiting for table metadata lock” issues, after “CREATE TABLE IF NOT EXISTS” has been […]