Question : I plan on creating my first database so this is going to be a newbie question. My database […]
Tag: physical-design
How to design tables for players in a tournament?
Question : I need help with my database table design. I have group which contains a list of players. In […]
Data center from scratch which way to go
Question : My budget for a data center (hardware,OS licences, SQL Licences WithOut CALS ) is around $50K~$60K. I have […]
Enforce uniqueness across a one-to-many-to-many bridged relationship when constraining to one-to-many
Question : We have defined a series of configurations, where, driven by a RESTful API, end-users can build up new […]
Fastest way to split/store a long string for charindex function
Question : I have a 1 TB string of digits. Given a 12-character sequence of digits I want to get […]
Usefulness of a multi-attribute index
Question : If an index has more than one attribute in it, is there any speed gained in a select […]
Best Way To Migrate Existing Production Database To New Physical Storage Structure
Question : I have recently taken a job as a Senior Database Administrator at a small but rapidly growing company. […]
MSSQL database physical design: RAID or spreading filegroups across different physical drives?
Question : I’m going to build a Microsoft SQL server database which could end up being more than 40 TB […]
Data center from scratch which way to go
Question : My budget for a data center (hardware,OS licences, SQL Licences WithOut CALS ) is around $50K~$60K. I have […]
How to design tables for players in a tournament?
Question : I need help with my database table design. I have group which contains a list of players. In […]
- 1
- 2