Click here to Skip to main content
14,739,795 members
Home » Discussions » Database
   

Database

 
GeneralRe: CTE Sub-Sort Pin
Mycroft Holmes12-Dec-17 13:45
professionalMycroft Holmes12-Dec-17 13:45 
QuestionTable Design Suggestion Pin
Manish K. Agarwal7-Dec-17 20:42
MemberManish K. Agarwal7-Dec-17 20:42 
AnswerRe: Table Design Suggestion Pin
Nathan Minier8-Dec-17 2:33
professionalNathan Minier8-Dec-17 2:33 
GeneralRe: Table Design Suggestion Pin
Manish K. Agarwal10-Dec-17 18:46
MemberManish K. Agarwal10-Dec-17 18:46 
GeneralRe: Table Design Suggestion Pin
Nathan Minier11-Dec-17 2:38
professionalNathan Minier11-Dec-17 2:38 
AnswerRe: Table Design Suggestion Pin
Richard Deeming8-Dec-17 2:35
mveRichard Deeming8-Dec-17 2:35 
GeneralRe: Table Design Suggestion Pin
Manish K. Agarwal10-Dec-17 18:53
MemberManish K. Agarwal10-Dec-17 18:53 
AnswerRe: Table Design Suggestion Pin
Mycroft Holmes9-Dec-17 1:00
professionalMycroft Holmes9-Dec-17 1:00 
Listen to Richard, I recently got told that us old folks did not know the modern way of doing things the "architect" want to put all the lookup data into 1 table. He ended up with 5 table and a dogs breakfast of different relationships maintained in the business layer and not the database where I wanted it.

Use 1 table for each different type of lookup data, use a primary key (not a code) and foreign keys.
Never underestimate the power of human stupidity
RAH

QuestionCan the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 5:14
professionalRichard Andrew x646-Dec-17 5:14 
AnswerRe: Can the Pivot operator be used with text columns? Pin
Richard Deeming6-Dec-17 10:51
mveRichard Deeming6-Dec-17 10:51 
GeneralRe: Can the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 13:16
professionalRichard Andrew x646-Dec-17 13:16 
AnswerRe: Can the Pivot operator be used with text columns? Pin
Jörgen Andersson6-Dec-17 11:05
professionalJörgen Andersson6-Dec-17 11:05 
GeneralRe: Can the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 13:17
professionalRichard Andrew x646-Dec-17 13:17 
QuestionSQL and database tutorials Pin
MikeTheFid4-Dec-17 12:52
MemberMikeTheFid4-Dec-17 12:52 
AnswerRe: SQL and database tutorials Pin
Mycroft Holmes4-Dec-17 14:17
professionalMycroft Holmes4-Dec-17 14:17 
GeneralRe: SQL and database tutorials Pin
MikeTheFid5-Dec-17 1:33
MemberMikeTheFid5-Dec-17 1:33 
QuestionSQL SERVER script Pin
Member 135516041-Dec-17 0:08
MemberMember 135516041-Dec-17 0:08 
AnswerRe: SQL SERVER script Pin
Richard MacCutchan1-Dec-17 0:31
mveRichard MacCutchan1-Dec-17 0:31 
AnswerRe: SQL SERVER script Pin
Simon_Whale4-Dec-17 6:33
professionalSimon_Whale4-Dec-17 6:33 
QuestionSchedule a trace file in SQL Profiler Pin
VK1928-Nov-17 8:06
MemberVK1928-Nov-17 8:06 
AnswerRe: Schedule a trace file in SQL Profiler Pin
Richard Deeming28-Nov-17 8:27
mveRichard Deeming28-Nov-17 8:27 
AnswerRe: Schedule a trace file in SQL Profiler Pin
jschell1-Dec-17 9:01
Memberjschell1-Dec-17 9:01 
GeneralRe: Schedule a trace file in SQL Profiler Pin
VK194-Dec-17 3:17
MemberVK194-Dec-17 3:17 
GeneralRe: Schedule a trace file in SQL Profiler Pin
jschell5-Dec-17 11:24
Memberjschell5-Dec-17 11:24 
GeneralRe: Schedule a trace file in SQL Profiler Pin
VK196-Dec-17 4:39
MemberVK196-Dec-17 4: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.