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

Database

 
AnswerRe: left join and outer join Pin
thatraja11-Dec-13 3:02
professionalthatraja11-Dec-13 3:02 
QuestionUpdate database from DataGridView and handle exception Pin
amannini11-Dec-13 1:03
Memberamannini11-Dec-13 1:03 
AnswerRe: Update database from DataGridView and handle exception Pin
Eddy Vluggen11-Dec-13 8:06
professionalEddy Vluggen11-Dec-13 8:06 
QuestionPerformance question Pin
Johnny J.9-Dec-13 21:12
professionalJohnny J.9-Dec-13 21:12 
AnswerRe: Performance question Pin
tsunamigang9-Dec-13 21:42
Membertsunamigang9-Dec-13 21:42 
AnswerRe: Performance question Pin
Jörgen Andersson10-Dec-13 2:26
professionalJörgen Andersson10-Dec-13 2:26 
AnswerRe: Performance question Pin
thatraja10-Dec-13 3:01
professionalthatraja10-Dec-13 3:01 
AnswerRe: Performance question Pin
David Mujica10-Dec-13 3:44
MemberDavid Mujica10-Dec-13 3:44 
If you are using SQL Server, you could use "Show Execution Plan" and see if there is a difference.

If you are using Oracle, I believe there is a 1000 element limit to the "IN" clause. At a previous company I worked for we got bit by this. (This was a while ago, maybe Oracle 9, it may not be an issue now)
GeneralRe: Performance question Pin
Jörgen Andersson10-Dec-13 3:51
professionalJörgen Andersson10-Dec-13 3:51 
Questionsearch based on free text(multiple words entered by user) Pin
rakeshjena9-Dec-13 19:16
Memberrakeshjena9-Dec-13 19:16 
AnswerRe: search based on free text(multiple words entered by user) Pin
Mycroft Holmes9-Dec-13 19:38
professionalMycroft Holmes9-Dec-13 19:38 
AnswerRe: search based on free text(multiple words entered by user) Pin
Eddy Vluggen10-Dec-13 9:10
professionalEddy Vluggen10-Dec-13 9:10 
Questionsearch based on free text(multiple words entered by user Pin
rakeshjena9-Dec-13 19:09
Memberrakeshjena9-Dec-13 19:09 
QuestionTempTables Pin
tsunamigang8-Dec-13 19:23
Membertsunamigang8-Dec-13 19:23 
AnswerRe: TempTables Pin
Abhinav S8-Dec-13 20:19
MemberAbhinav S8-Dec-13 20:19 
GeneralRe: TempTables Pin
tsunamigang9-Dec-13 19:02
Membertsunamigang9-Dec-13 19:02 
QuestionVariable column SQL statments Pin
Wombaticus8-Dec-13 7:13
MemberWombaticus8-Dec-13 7:13 
AnswerRe: Variable column SQL statments Pin
Mycroft Holmes8-Dec-13 12:47
professionalMycroft Holmes8-Dec-13 12:47 
GeneralRe: Variable column SQL statments Pin
Wombaticus8-Dec-13 13:39
MemberWombaticus8-Dec-13 13:39 
Questionms access select query? Pin
murali_utr8-Dec-13 5:17
Membermurali_utr8-Dec-13 5:17 
AnswerRe: ms access select query? Pin
PIEBALDconsult8-Dec-13 5:38
professionalPIEBALDconsult8-Dec-13 5:38 
QuestionRe: ms access select query? Pin
murali_utr8-Dec-13 5:47
Membermurali_utr8-Dec-13 5:47 
AnswerRe: ms access select query? Pin
PIEBALDconsult8-Dec-13 6:04
professionalPIEBALDconsult8-Dec-13 6:04 
QuestionBackup & restore of data Like organization chart in sqlserver Pin
mehdin698-Dec-13 2:46
Membermehdin698-Dec-13 2:46 
AnswerRe: Backup & restore of data Like organization chart in sqlserver Pin
Mycroft Holmes8-Dec-13 12:50
professionalMycroft Holmes8-Dec-13 12:50 

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.