Question : I have this query: ALTER TABLE MERCHANTS ADD COLUMN merchant_image bytea, ADD COLUMN merchant_logo bytea, ADD COLUMN merchant_address […]
DbaFix
MySQL query WHERE IN + ORDER BY, which EXPLAIN is better and how to avoid filesort?
Question : This is my table definition, without any special index for now: CREATE TABLE `filter` ( `field_name` varchar(32) COLLATE […]
MongoDB – sharding an collection with data already in it
Question : I’m using Mongo (shell version 2.6.12) in a clustered configuration. Right now I have a few collections sharded, […]
How to store chess positions in a relational database (in particular, Postgres)
Question : I’m exploring the idea of building a website that involves analysis of chess positions. Chess positions themselves are […]
List all columns for a specified table
Question : I’m looking for a precise piece of information in a database which I have no knowledge about. The […]
Can I grant multiple remote LocalService accounts access to a SQL Server database?
Question : I am designing a multi-environment Windows-based software product that will extensively employ Windows services running as LocalService to […]
User-defined function returns first character only although RETURN VARCHAR(10) is defined?
Question : Everyone, I cannot figure out what is missing in the below user-defined function: CREATE OR ALTER FUNCTION ufn_GetSalaryLevel(@Salary […]
Stop PostgreSQL from logging statements on error
Question : My postgresql 9.3 logs are sprinkled with entries like these (redacted to protect the guilty): STATEMENT: INSERT INTO […]
Can a non-owner of a table be allowed to disable the table’s triggers?
Question : I would like for one user who is not a table owner, give the permissions to turn off […]
Why does the CBO not chose a lower cost skip scan without stats?
Question : In the script below, the CBO chooses an INDEX FAST FULL SCAN over an INDEX SKIP SCAN (this […]