Question : How can I group (by) two joined tables (in an Oracle database) like this: cant: id CANT_VAL COD_VAL […]
DbaFix
SQL Server Chaining Many-To-Many tables
Question : I have a scenario where we want to build an inventory description system and I am trying to […]
Help with design of sales database
Question : Disclaimer: I am a beginner in the field of database. I am trying to design a database in […]
Chat schema for PostgreSQL and MongoDB
Question : I’m designing a schema for a very large chat app. I had problems with NoSQL databases such as […]
PostgreSQL Database Migration
Question : How can I migrate data from on PostgreSQL database to another PostgreSQL database? Is there any technique to […]
MDX datetime comparison
Question : I have a MDX calculated measure for rolling 30-day totals, and I want to mask the calculation for […]
How PostgresSQL stores duplicated VARCHAR values in a column
Question : I have a VARCHAR(255) column in a table with about 50 million rows. In that column there is […]
Shrinking T-Log file every weekend basis
Question : Recently our SQL Server Log drive which has all T-Log files starting growing rapidly. Considerations We expanded drive […]
Dog slow query, needs optimizing, please help
Question : I found this query in our web app that has been made by hired programmers. It performs like […]
Maintaining a production big table
Question : I have a very large table: Table1 in a production environment which I need to alter a column […]