Click here to Skip to main content
15,914,943 members
Home / Discussions / Database
   

Database

 
GeneralRe: Data Binding, Combo Boxes, and Related tables. Pin
Mycroft Holmes30-Sep-10 12:03
professionalMycroft Holmes30-Sep-10 12:03 
GeneralRe: Data Binding, Combo Boxes, and Related tables. Pin
MSBassSinger30-Sep-10 12:24
professionalMSBassSinger30-Sep-10 12:24 
GeneralRe: Data Binding, Combo Boxes, and Related tables. Pin
patzerFish30-Sep-10 4:20
patzerFish30-Sep-10 4:20 
GeneralRe: Data Binding, Combo Boxes, and Related tables. Pin
Mycroft Holmes30-Sep-10 11:53
professionalMycroft Holmes30-Sep-10 11:53 
AnswerRe: Data Binding, Combo Boxes, and Related tables. Pin
underclocker30-Sep-10 6:00
underclocker30-Sep-10 6:00 
Questionnew line Pin
scottichrosaviakosmos25-Sep-10 23:00
scottichrosaviakosmos25-Sep-10 23:00 
AnswerRe: new line Pin
Mycroft Holmes25-Sep-10 23:40
professionalMycroft Holmes25-Sep-10 23:40 
AnswerRe: new line Pin
Corporal Agarn28-Sep-10 6:44
professionalCorporal Agarn28-Sep-10 6:44 
AnswerRe: new line Pin
bigbadben30-Sep-10 2:55
bigbadben30-Sep-10 2:55 
Question(INSERT EXEC statement cannot be nested.) and (Cannot use the ROLLBACK statement within an INSERT-EXEC statement.) how to solve this??!! Pin
Yajjoj25-Sep-10 9:43
Yajjoj25-Sep-10 9:43 
QuestionCreate Database in Oracle 9i Pin
MohanMbnr25-Sep-10 3:01
MohanMbnr25-Sep-10 3:01 
AnswerRe: Create Database in Oracle 9i Pin
Eddy Vluggen25-Sep-10 12:01
professionalEddy Vluggen25-Sep-10 12:01 
QuestionCreate database to share folder Pin
ndkit24-Sep-10 15:50
ndkit24-Sep-10 15:50 
AnswerRe: Create database to share folder Pin
Eddy Vluggen25-Sep-10 0:56
professionalEddy Vluggen25-Sep-10 0:56 
QuestionQuery Improvement Related to Lounge Post Pin
programmervb.netc++24-Sep-10 11:07
programmervb.netc++24-Sep-10 11:07 
AnswerRe: Query Improvement Related to Lounge Post Pin
Luc Pattyn24-Sep-10 11:29
sitebuilderLuc Pattyn24-Sep-10 11:29 
GeneralRe: Query Improvement Related to Lounge Post Pin
programmervb.netc++24-Sep-10 11:35
programmervb.netc++24-Sep-10 11:35 
AnswerRe: Query Improvement Related to Lounge Post Pin
Mycroft Holmes24-Sep-10 15:32
professionalMycroft Holmes24-Sep-10 15:32 
GeneralRe: Query Improvement Related to Lounge Post Pin
programmervb.netc++24-Sep-10 19:09
programmervb.netc++24-Sep-10 19:09 
GeneralRe: Query Improvement Related to Lounge Post Pin
programmervb.netc++27-Sep-10 13:50
programmervb.netc++27-Sep-10 13:50 
GeneralRe: Query Improvement Related to Lounge Post Pin
Mycroft Holmes27-Sep-10 15:45
professionalMycroft Holmes27-Sep-10 15:45 
GeneralRe: Query Improvement Related to Lounge Post Pin
programmervb.netc++29-Sep-10 18:35
programmervb.netc++29-Sep-10 18:35 
Why would the number of clients really matter if your indexes are correct?
I understand that the record set has an affect on total time but I don't see how that really relates to a CONCAT for example.
If you are going to have to CONCAT last and first name on 1000 clients what benefit would you have from doing it locally instead of the server?
Also in either case the concatenation I think the concatenation would be happening in memory so in theory the server should have more...
and I would think that the CONCAT statement written in my case mySQL is probably more efficient than the equivalent code in .NET.
Thanks for your thoughts I do appreciate your input just want to have a full understanding of your reasoning.

Humble Programmer
AnswerRe: Query Improvement Related to Lounge Post Pin
Richard MacCutchan24-Sep-10 23:34
mveRichard MacCutchan24-Sep-10 23:34 
GeneralRe: Query Improvement Related to Lounge Post Pin
programmervb.netc++27-Sep-10 13:47
programmervb.netc++27-Sep-10 13:47 
QuestionDBBackup Error Pin
MWRivera24-Sep-10 5:53
MWRivera24-Sep-10 5:53 

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.