0
votes
1answer
457 views

SQL Server 2008 - How would I create a dynamic query for finding relationships and references to the primary key?

Since I'm new and I've never shared, and yet there are a few useful scripts that I need on a daily basis, I thought I should. As a new DBA, some data fix DML operations and simple business logical ...
4
votes
1answer
171 views

How should I model a worflow of status/activities ? (rules like “if is 3 go to 4, if is 4 go to 5” etc)

I'm trying to model a workflow (status and activities) to create "rules". Let me give you an example. The main "object" let's say are "vehicle requirements", I will have this table: idRequirement, ...
5
votes
1answer
295 views

Database structure, relational or data warehouse?

Good morning, Im having some issues with how my database should be laid out and would appreciate some guidance. I have several tables (rainfall data), each containing the following columns: Date ...
4
votes
1answer
434 views

database design issue

This is my first time on this beautiful content rich site. I have a sql server 2008 database, but am not too experienced with good relational database design. My project is this: I have a school ...