All Questions
Tagged with sql-server relational-database
9 questions
-3
votes
1
answer
124
views
Where should linking tables be stored? [closed]
I have a system where properties can be stored, and linked with multiple other entities (each with their own schema). Let's say that Documents can be linked with Users and Assets. What is the best ...
- 191
-3
votes
1
answer
158
views
SQL Server: Which License? Any alternatives?
I'm working on a project which at the moment is not being used for any commercial purposes, and I'm managing the data by using a SQL Server Database.
I read here that I should pay for it if I ever ...
5
votes
5
answers
2k
views
Relational integrity without relations
I have about 15 years software engineering experience, writing business software with relational databases. Mainly SQL Server and Oracle. I've always been of the opinion that you should define ...
- 301
1
vote
1
answer
932
views
Database Design - Hierarchical Structure [closed]
1
We are trying to redesign a database that currently holds thousands of parameters for different datatypes and currently has a flat data structure.
We generate XML files from the database, which ...
- 21
0
votes
1
answer
579
views
Bridge/Join Table for a Many to Many Relationship between One Table and Multiple Others
Background
I have a relational database an I want to have a table that contains flags. I want multiple tables in my database to have a many to many relationship with the flag table.
Options
I ...
- 3
1
vote
2
answers
1k
views
How should I handle Stored Procedure parameters that need to be the same length as a column?
I'm writing a lot of stored procedures for a SQL Server database that take an id or code that is a CHAR instead of an INT. Most of these haven't changed size in a long time, but when a customer wants ...
- 721
5
votes
2
answers
3k
views
One wide table or multiple themed tables?
I'm trying to design a database for a simple text based game where the player characters have a large number of statistics that I want to track. Currently I have a few groups of related statistics, ...
- 173
1
vote
1
answer
85
views
Looking for advice for the following MS SQL Schema
We currently have the following SQL Schema:
Projects
Budgets
BudgetTabs
BudgetSections
BudgetTasks
BudgetTaskDetails
...
- 159
4
votes
1
answer
20k
views
When deciding a Primary Key, can I use Date part of a DateTime field
I'm designing a payroll system I have designed a database with several tables and this question is related to following tables
EMPLOYEE (Employee_ID [pk], Name,... etc)
LOCATION (Location_ID [pk], ...
- 345