matigo's user avatar
matigo's user avatar
matigo's user avatar
matigo
  • Member for 1 year, 5 months
  • Last seen more than a week ago
5 votes

Improving sql query execution time for 3 billion rows table

5 votes
Accepted

How can I change the master password of pgAdmin 4 without resetting it?

4 votes
Accepted

Why is my database 5 times larger in size than all the individual files combined?

4 votes

How to model a course > section > lesson structure where lessons can belong to either sections or courses?

4 votes
Accepted

How do I recover data from the postgres data directory on my hard drive?

4 votes
Accepted

Complex `where` dramatically affects query performance

3 votes
Accepted

Why do I get ERROR 1824 (HY000) while importing MySQL dump from 5.7 to 8.0.x?

3 votes
Accepted

When changing the default port number from 5432 to 5332, why do I get a unix domain socket error?

3 votes
Accepted

how to disable access to mongo shell to anonymous users?

3 votes
Accepted

Run SQL Job monthly at day 16. If it's a weekend, run it in the next business day ( dont care if is a holiday)

3 votes
Accepted

Database scheme for re-testing records

2 votes

service mysql reload results 'Access denied', but service mysql start works

2 votes
Accepted

Using “OR” in SQL

2 votes

Select student data from a table and include parent email address from another table

2 votes
Accepted

Why does Casting this string as a decimal fail?

2 votes
Accepted

Why Azure site recovery may not meet RPO?

2 votes
Accepted

Do unused columns in MySQL/MariaDB notably affect performance?

2 votes

Select with fallback and default?

2 votes
Accepted

Single table of all chat conversations or separate tables?

2 votes

Export and import a table without a specific column

2 votes

Change column values but keep order in MySQL

2 votes

How to arrange documents in a collection alphabetically in mongodb?

2 votes
Accepted

Mysql Innodb Error Number 24 Means 'too Many Open Files'?

2 votes

How can I change the password used to connect to MySQL database?

2 votes

How to compact/group by the results of a query by columns' values?

2 votes

Why is MySQL InnoDB table copied despite using ALGORITHM=INPLACE for ALTER TABLE

2 votes

Commit or rollback SQLServer-SQLTransaction when no data changed

2 votes
Accepted

Microsoft SQL Server: TSQL Formatting of Results Columns

1 vote
Accepted

How to alter column to make it primary key when one already exists mysql8?

1 vote

MySQL 8.0.23: Removeing huge '#sql-ib****.idb files?