physical-design Archives

Enforce uniqueness across a one-to-many-to-many bridged relationship when constraining to one-to-many

By adminPosted on July 27, 2022

Question : We have defined a series of configurations, where, driven by a RESTful API, end-users can build up new […]

By adminPosted on January 27, 2022

Question : I have a 1 TB string of digits. Given a 12-character sequence of digits I want to get […]

By adminPosted on January 26, 2022

Question : If an index has more than one attribute in it, is there any speed gained in a select […]

By adminPosted on January 21, 2022

Question : I have recently taken a job as a Senior Database Administrator at a small but rapidly growing company. […]

By adminPosted on January 7, 2022

Question : I’m going to build a Microsoft SQL server database which could end up being more than 40 TB […]

By adminPosted on July 12, 2021

Question : My budget for a data center (hardware,OS licences, SQL Licences WithOut CALS ) is around $50K~$60K. I have […]

By adminPosted on June 22, 2021

Question : I need help with my database table design. I have group which contains a list of players. In […]

By adminPosted on June 15, 2021

Question : I have a table in my MySQL 5.7 database, which has 9 columns. One column is an AUTO […]

By adminPosted on May 4, 2021

Question : We’re working with a vendor who is insisting we use MAXDOP = 1 (I know…). They are also […]

By adminPosted on March 11, 2021

Question : I have a PostgreSQL table, Prices, with the columns: price (Decimal) product_id (Int) There are also created_at and […]