Question : Please take note that the example below is just an example, my scenario is way more complex and […]
Tag: physical-design
Clustered Primary Key that is never used vs. Non-Clustered Primary Key on Multiple Columns
Question : I am working on a table design for Customer Totals and trying to make a decision about the […]
In SQL Server would misc pages be pushed out when an object grows within a mixed extent?
Question : In SQL Server 2008-2012, objects (including tables) are first put in a mixed extent. An extent can accommodate […]
Can you gain the performance benefits of partition elimination without changing SQL module or table definitions?
Question : I work for a company that has a multi-tenant database model that doesn’t currently use database partitioning. The […]
Performance of using a non-clustered index as primary key
Question : Background I am designing a database for a record management system. It’s early stages as I am considering […]
ER-Model for Borrowing-Lending-Network?
Question : I plan on creating my first database so this is going to be a newbie question. My database […]
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 […]