Click here to Skip to main content
15,851,453 members
Home / Discussions / Database
   

Database

 
RantRe: how to use FBExport Command tool Pin
Ashfield24-Jun-08 4:42
Ashfield24-Jun-08 4:42 
QuestionSql Server Registration Pin
harish.k1223-Jun-08 23:46
harish.k1223-Jun-08 23:46 
AnswerRe: Sql Server Registration Pin
Ashfield24-Jun-08 2:12
Ashfield24-Jun-08 2:12 
QuestionHow to use FBExport tool. Pin
avvaru.murali23-Jun-08 21:45
avvaru.murali23-Jun-08 21:45 
AnswerRe: How to use FBExport tool. Pin
Ashfield23-Jun-08 22:38
Ashfield23-Jun-08 22:38 
QuestionAnother DB design question: Pin
alex3_1423-Jun-08 4:50
alex3_1423-Jun-08 4:50 
AnswerRe: Another DB design question: Pin
Ennis Ray Lynch, Jr.23-Jun-08 4:53
Ennis Ray Lynch, Jr.23-Jun-08 4:53 
AnswerRe: Another DB design question: Pin
Michael Potter23-Jun-08 10:02
Michael Potter23-Jun-08 10:02 
If this is the main aspect for the design of the database, I would create the 3T primary keys the same way I would if it was an accounting system. A character key with the first 3 digits designating building, next 3 floor and the last three room (altered to your specs of course). This way you could include ranges of any size for your shutdowns without having to create multiple records for each structure.

It would come in very handy when developing a calandar of building projects. I usually try to avoid having any real meaning (besides row identifier) in my primary keys but, in this case it may make sense.

Building 5: 005000000
Second Floor, blg 5: 005002000
Room 234, 2nd Fr, blg 5: 005002234


Inactive Table
--------------
PrimaryKey
StartStructureId
EndStructureId
StartDate
EndDate
Reason
AnswerRe: Another DB design question: Pin
Mycroft Holmes27-Jun-08 4:59
professionalMycroft Holmes27-Jun-08 4:59 
QuestionPerformance question Pin
Ennis Ray Lynch, Jr.23-Jun-08 4:27
Ennis Ray Lynch, Jr.23-Jun-08 4:27 
AnswerRe: Performance question Pin
Mike Dimmick23-Jun-08 5:24
Mike Dimmick23-Jun-08 5:24 
GeneralRe: Performance question Pin
Ennis Ray Lynch, Jr.23-Jun-08 5:35
Ennis Ray Lynch, Jr.23-Jun-08 5:35 
GeneralRe: Performance question Pin
Andy Brummer26-Jun-08 12:03
sitebuilderAndy Brummer26-Jun-08 12:03 
GeneralRe: Performance question Pin
Ennis Ray Lynch, Jr.26-Jun-08 12:18
Ennis Ray Lynch, Jr.26-Jun-08 12:18 
GeneralRe: Performance question Pin
Andy Brummer26-Jun-08 12:34
sitebuilderAndy Brummer26-Jun-08 12:34 
GeneralRe: Performance question Pin
Ennis Ray Lynch, Jr.26-Jun-08 12:40
Ennis Ray Lynch, Jr.26-Jun-08 12:40 
GeneralRe: Performance question Pin
Andy Brummer26-Jun-08 13:11
sitebuilderAndy Brummer26-Jun-08 13:11 
GeneralRe: Performance question Pin
Ennis Ray Lynch, Jr.26-Jun-08 13:21
Ennis Ray Lynch, Jr.26-Jun-08 13:21 
GeneralRe: Performance question Pin
Andy Brummer27-Jun-08 3:44
sitebuilderAndy Brummer27-Jun-08 3:44 
Questiondatetime query in SQL server Pin
laziale23-Jun-08 0:27
laziale23-Jun-08 0:27 
AnswerRe: datetime query in SQL server Pin
r aa j23-Jun-08 1:01
r aa j23-Jun-08 1:01 
AnswerRe: datetime query in SQL server Pin
Ashfield23-Jun-08 1:08
Ashfield23-Jun-08 1:08 
GeneralRe: datetime query in SQL server Pin
laziale23-Jun-08 1:19
laziale23-Jun-08 1:19 
GeneralRe: datetime query in SQL server Pin
Ashfield23-Jun-08 2:16
Ashfield23-Jun-08 2:16 
GeneralRe: datetime query in SQL server Pin
laziale23-Jun-08 2:39
laziale23-Jun-08 2:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.