Question : I found this query in our web app that has been made by hired programmers. It performs like […]
DbaFix
Maintaining a production big table
Question : I have a very large table: Table1 in a production environment which I need to alter a column […]
get all posts with their associative tags without duplicates
Question : Two tables. Post and Tag. Many to Many bi-directional relationship. Post Table Tag Table Post_Tag Pivot Table ————— […]
build users availability report/Table (using sql)
Question : I got a question from our product team to build a “Table availability of customer service representatives (user)”. […]
Configuring SQL Server for SSL Encryption
Question : I’m new to the DBA role and I’ve been tasked with configuring a SQL Server install for a […]
How to partition an Oracle table with 65 million rows?
Question : The table that needs partitioning contains a list of Components and their Values. So one table is tblComponents. […]
MySQL Cluster – Got error 1601 ‘Out extents, tablespace full’ from NDB
Question : I am trying to do some tests on MySQL Cluster. I am creating my database using following commands: […]
Optimize large table design
Question : First, I am a complete novice when it comes to databases, but have been given the task to […]
SQL Server: How to add a full join to two tables but have matches line up?
Question : I am working with a system that has two databases. One for the ERP system and one for […]
Select statements during long update
Question : I’ve a table MESSAGES id (long) | attach_data (image) | ins_date | flag this table contains all messages […]