Click here to Skip to main content
15,898,035 members
Home / Discussions / Database
   

Database

 
GeneralRe: Access to stored procs on different database servers Pin
Corporal Agarn5-Jan-11 9:10
professionalCorporal Agarn5-Jan-11 9:10 
GeneralRe: Access to stored procs on different database servers Pin
vanikanc5-Jan-11 9:19
vanikanc5-Jan-11 9:19 
QuestionBlocking Read of some rows. Pin
DeathDragon4-Jan-11 22:33
DeathDragon4-Jan-11 22:33 
AnswerRe: Blocking Read of some rows. Pin
Jörgen Andersson4-Jan-11 22:47
professionalJörgen Andersson4-Jan-11 22:47 
GeneralRe: Blocking Read of some rows. Pin
DeathDragon4-Jan-11 22:52
DeathDragon4-Jan-11 22:52 
AnswerRe: Blocking Read of some rows. Pin
Chris Meech5-Jan-11 5:05
Chris Meech5-Jan-11 5:05 
QuestionDatabase table design Pin
scorp_scorp3-Jan-11 23:05
scorp_scorp3-Jan-11 23:05 
AnswerRe: Database table design Pin
Hiren solanki3-Jan-11 23:31
Hiren solanki3-Jan-11 23:31 
scorp_scorp wrote:
My question is, when designing the table X, should i include a feild/coloumn that contains the sum of the inputs/records in Y, or not, little bit confused


There's one option available of computed column in SQL Server, That's just giving you column value by applying formula you've provided while creating that column rather then storing physical data of SUM.
Regards,
Hiren.

QuestionRe: Database table design Pin
scorp_scorp3-Jan-11 23:36
scorp_scorp3-Jan-11 23:36 
GeneralRe: Database table design Pin
Hiren solanki3-Jan-11 23:40
Hiren solanki3-Jan-11 23:40 
AnswerRe: Database table design Pin
scorp_scorp3-Jan-11 23:42
scorp_scorp3-Jan-11 23:42 
GeneralRe: Database table design Pin
jschell4-Jan-11 8:25
jschell4-Jan-11 8:25 
AnswerRe: Database table design Pin
Eddy Vluggen4-Jan-11 0:31
professionalEddy Vluggen4-Jan-11 0:31 
AnswerRe: Database table design Pin
PIEBALDconsult4-Jan-11 2:23
mvePIEBALDconsult4-Jan-11 2:23 
AnswerRe: Database table design Pin
jschell4-Jan-11 8:27
jschell4-Jan-11 8:27 
GeneralRe: Database table design Pin
scorp_scorp9-Jan-11 21:06
scorp_scorp9-Jan-11 21:06 
Questionerror in sql Pin
mandarapu3-Jan-11 21:14
mandarapu3-Jan-11 21:14 
AnswerRe: error in sql Pin
Bernhard Hiller3-Jan-11 23:14
Bernhard Hiller3-Jan-11 23:14 
AnswerRe: error in sql Pin
Hiren solanki3-Jan-11 23:28
Hiren solanki3-Jan-11 23:28 
QuestionIndex with two columns of table Pin
vanikanc3-Jan-11 4:05
vanikanc3-Jan-11 4:05 
AnswerRe: Index with two columns of table Pin
Corporal Agarn3-Jan-11 5:13
professionalCorporal Agarn3-Jan-11 5:13 
Questionlack of index in mysql document Pin
followait31-Dec-10 16:50
followait31-Dec-10 16:50 
QuestionJoin and Update statement using junction table and sql Pin
jboyd11130-Dec-10 10:19
jboyd11130-Dec-10 10:19 
AnswerRe: Join and Update statement using junction table and sql Pin
Luc Pattyn30-Dec-10 10:34
sitebuilderLuc Pattyn30-Dec-10 10:34 
GeneralRe: Join and Update statement using junction table and sql Pin
jboyd11130-Dec-10 16:06
jboyd11130-Dec-10 16:06 

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.