Question : I have a set of order items placed in my table. These order items are generated from 2 […]
DbaFix
How a prostgres restore is made consistent
Question : When restored files will be consistent? At the beginning, when the backup starts or at the end when […]
How do I change the config path for mysqld?
Question : I want to change configuration file path from C: to E:, but I can’t find the way to […]
Why would SQL Server stop excluding partitions appropriately?
Question : I have a Fact Table that will run with an appropriate plan during our morning processing. Occasionally, later […]
Difference between fetched and returned tuples in postgresql
Question : I’m facing a hard time trying to figure it out some performance problems in my database. I’m using […]
I want to know about the IOPS (I/O Per Second) and How it influences the DB CRUD operation
Question : I want to get a dedicated server for my Database (MySQL) which runs InnoDB Engine. There is this […]
Stored procedure for adding cascade
Question : I have a DB with 180 tables, and I was doing a logical deletion, now I need to […]
MySQL database dump bombs out Error 1064 when using LOCK TABLES
Question : This specific machine is running MySQL version 5.0.27. I have tried to get a full dump of this […]
Changed DB_RECOVERY_FILE_DEST path, but RMAN still backs up to the old path?
Question : I just recently changed the DB_RECOVERY_FILE_DEST parameter to point to a new directory path. However, I noticed only […]
sp_help with different object types with the same name
Question : I have a table with the same name as a user-defined data type (UDDT), and when I use […]