Click here to Skip to main content
15,356,336 members
Home / Discussions / Database
   

Database

 
AnswerRe: Table comparison in sql server 2000 Pin
John Gathogo11-Oct-07 4:44
MemberJohn Gathogo11-Oct-07 4:44 
AnswerRe: Table comparison in sql server 2000 Pin
Hesham Amin12-Oct-07 8:41
MemberHesham Amin12-Oct-07 8:41 
Questionvarchar and nvarchar Pin
Brendan Vogt11-Oct-07 3:55
MemberBrendan Vogt11-Oct-07 3:55 
AnswerRe: varchar and nvarchar Pin
Rob Philpott11-Oct-07 4:35
MemberRob Philpott11-Oct-07 4:35 
GeneralRe: varchar and nvarchar Pin
Mark Churchill11-Oct-07 17:48
MemberMark Churchill11-Oct-07 17:48 
QuestionPerformance issue Pin
Albu Marius11-Oct-07 3:35
MemberAlbu Marius11-Oct-07 3:35 
AnswerRe: Performance issue Pin
Colin Angus Mackay11-Oct-07 3:43
MemberColin Angus Mackay11-Oct-07 3:43 
GeneralRe: Performance issue Pin
Albu Marius11-Oct-07 4:34
MemberAlbu Marius11-Oct-07 4:34 
I'm sorry, I should have been more specific in my post. The situation : 2 selects (not very large)each returning about 3000 records . One select is saved in a temporary table (#tmpSomething) and the other one is joined with the first and the result is outputed (duration - few miliseconds). I was advised to never use temporary tables because of the performance issues. I know this is the case of @ tables which store all the data in memory and for a large number of records (tens of thousands) the SQL Server hangs for a time before returning the result. But my problem is why can 't I use # table (which are stored on disk)? Is the impact to performance so big due to the I/O operations? As I said I was advised to always use a select contained in the bigger select instead of temporary tables. This seems to me as a bad practice because this way the SQL code if pretty hard to understand and I'm not sure this resolves the performance issues. If someone can shed some light on this dilema of mine , please do.

I am fighting against the Universe...
Reference-Rick Cook

GeneralRe: Performance issue Pin
Colin Angus Mackay11-Oct-07 5:35
MemberColin Angus Mackay11-Oct-07 5:35 
GeneralRe: Performance issue Pin
Albu Marius11-Oct-07 6:31
MemberAlbu Marius11-Oct-07 6:31 
Questionhow to block ? Pin
ahmed eldeghedy11-Oct-07 2:58
professionalahmed eldeghedy11-Oct-07 2:58 
AnswerRe: how to block ? Pin
Colin Angus Mackay11-Oct-07 3:42
MemberColin Angus Mackay11-Oct-07 3:42 
GeneralRe: how to block ? Pin
Paul Conrad12-Oct-07 12:04
professionalPaul Conrad12-Oct-07 12:04 
AnswerRe: how to block ? Pin
Colin Angus Mackay11-Oct-07 7:00
MemberColin Angus Mackay11-Oct-07 7:00 
GeneralRe: how to block ? Pin
Paul Conrad12-Oct-07 12:05
professionalPaul Conrad12-Oct-07 12:05 
QuestionCopy Information Pin
Sarfaraj Ahmed11-Oct-07 0:58
MemberSarfaraj Ahmed11-Oct-07 0:58 
AnswerRe: Copy Information Pin
pmarfleet11-Oct-07 2:00
Memberpmarfleet11-Oct-07 2:00 
GeneralRe: Copy Information Pin
Sarfaraj Ahmed11-Oct-07 3:19
MemberSarfaraj Ahmed11-Oct-07 3:19 
GeneralRe: Copy Information Pin
pmarfleet11-Oct-07 8:59
Memberpmarfleet11-Oct-07 8:59 
GeneralRe: Copy Information Pin
Sarfaraj Ahmed11-Oct-07 3:55
MemberSarfaraj Ahmed11-Oct-07 3:55 
GeneralRe: Copy Information Pin
pmarfleet11-Oct-07 9:00
Memberpmarfleet11-Oct-07 9:00 
GeneralRe: Copy Information Pin
Sarfaraj Ahmed11-Oct-07 15:09
MemberSarfaraj Ahmed11-Oct-07 15:09 
GeneralRe: Copy Information Pin
pmarfleet11-Oct-07 21:39
Memberpmarfleet11-Oct-07 21:39 
Questionupdate database(urgently) Pin
Milind Panchal10-Oct-07 22:51
MemberMilind Panchal10-Oct-07 22:51 
AnswerRe: update database(urgently) Pin
N a v a n e e t h10-Oct-07 23:09
MemberN a v a n e e t h10-Oct-07 23:09 

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.