Tagged Questions
0
votes
1answer
240 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
103 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, ...
4
votes
1answer
229 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 ...
3
votes
1answer
407 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 ...
