Click here to Skip to main content
15,354,313 members
Home / Discussions / Database
   

Database

 
QuestionTable comparison in sql server 2000 Pin
Guru_yogi11-Oct-07 4:10
MemberGuru_yogi11-Oct-07 4:10 
AnswerRe: Table comparison in sql server 2000 Pin
Rob Philpott11-Oct-07 4:37
MemberRob Philpott11-Oct-07 4:37 
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 
What is the best way to write an SQL stored procedure: by using temporary tables (e.g #tmpSomething or @tmpSomething) or by using multiple selects? How is this affecting the speed of execution and the memory usage? Thank you in advance.

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

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 
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 

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.