Click here to Skip to main content
15,882,209 members
Home / Discussions / Database
   

Database

 
AnswerRe: is it possible restore file( which back up in ms-sql2008) to ms-sql 2005? Pin
Shameel6-Jul-11 21:48
professionalShameel6-Jul-11 21:48 
QuestionDeadlock problem Pin
Y_Kaushik5-Jul-11 19:18
Y_Kaushik5-Jul-11 19:18 
SuggestionRe: detecting and ending Deadlocks Pin
David Mujica6-Jul-11 3:08
David Mujica6-Jul-11 3:08 
AnswerRe: Deadlock problem Pin
MecAlex10-Jul-11 22:40
MecAlex10-Jul-11 22:40 
QuestionMySQL in-memory table vs. SQLite in-memory DB Pin
GregStevens5-Jul-11 17:32
GregStevens5-Jul-11 17:32 
AnswerRe: MySQL in-memory table vs. SQLite in-memory DB Pin
Eddy Vluggen8-Jul-11 13:02
professionalEddy Vluggen8-Jul-11 13:02 
QuestionRID|Key lookup vs Index Seek? [modified] Pin
devvvy5-Jul-11 17:23
devvvy5-Jul-11 17:23 
AnswerRe: RID|Key lookup vs Index Seek? Pin
dasblinkenlight6-Jul-11 6:13
dasblinkenlight6-Jul-11 6:13 
I think that you've been thrown off by the meaning of the word "heap". Although it usually means what you think (i.e. an in-memory data structure[^]), in the context of the discussions that you quoted it means a heap-based table[^].

Anyway, Key Lookup is logically identical to RID Lookup. Physically, there are significant differences, but nine times out of ten you can count them with the rest of unimportant implementation details.
GeneralRe: RID|Key lookup vs Index Seek? Pin
devvvy10-Jul-11 0:11
devvvy10-Jul-11 0:11 
QuestionFeeding parameters from a C# app into an SSIS package that converts query results to CSV and FTP [modified] Pin
Alaric_5-Jul-11 12:34
professionalAlaric_5-Jul-11 12:34 
AnswerRe: Feeding parameters from a C# app into an SSIS package that converts query results to CSV and FTP Pin
Alaric_7-Jul-11 6:44
professionalAlaric_7-Jul-11 6:44 
QuestionLow-level filtering of IsDeleted bit field Pin
army_man716554-Jul-11 11:39
army_man716554-Jul-11 11:39 
AnswerRe: Low-level filtering of IsDeleted bit field Pin
Johan Hakkesteegt5-Jul-11 1:48
Johan Hakkesteegt5-Jul-11 1:48 
GeneralHistory table Pin
David Mujica5-Jul-11 3:25
David Mujica5-Jul-11 3:25 
GeneralRe: History table Pin
Eddy Vluggen5-Jul-11 13:19
professionalEddy Vluggen5-Jul-11 13:19 
AnswerRe: Low-level filtering of IsDeleted bit field Pin
jschell5-Jul-11 6:20
jschell5-Jul-11 6:20 
AnswerRe: Low-level filtering of IsDeleted bit field Pin
Mycroft Holmes5-Jul-11 14:21
professionalMycroft Holmes5-Jul-11 14:21 
AnswerRe: Low-level filtering of IsDeleted bit field Pin
Shameel7-Jul-11 3:20
professionalShameel7-Jul-11 3:20 
QuestionUnQuote a nvarchar() string and use it as a table name Pin
reza assar4-Jul-11 1:57
reza assar4-Jul-11 1:57 
AnswerRe: UnQuote a nvarchar() string and use it as a table name Pin
Shameel4-Jul-11 4:46
professionalShameel4-Jul-11 4:46 
AnswerRe: UnQuote a nvarchar() string and use it as a table name Pin
PIEBALDconsult4-Jul-11 6:01
mvePIEBALDconsult4-Jul-11 6:01 
AnswerRe: UnQuote a nvarchar() string and use it as a table name Pin
Niladri_Biswas4-Jul-11 17:03
Niladri_Biswas4-Jul-11 17:03 
GeneralRe: UnQuote a nvarchar() string and use it as a table name Pin
reza assar6-Jul-11 1:04
reza assar6-Jul-11 1:04 
QuestionGetDate Pin
berba4-Jul-11 0:10
berba4-Jul-11 0:10 
AnswerRe: GetDate Pin
thatraja4-Jul-11 0:25
professionalthatraja4-Jul-11 0:25 

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.