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

Database

 
AnswerRe: Question Regarding SQL Parameter Query Pin
ZurdoDev31-Mar-20 9:49
professionalZurdoDev31-Mar-20 9:49 
AnswerRe: Question Regarding SQL Parameter Query Pin
Victor Nijegorodov1-Apr-20 1:35
Victor Nijegorodov1-Apr-20 1:35 
AnswerRe: Question Regarding SQL Parameter Query Pin
Richard Deeming1-Apr-20 2:32
mveRichard Deeming1-Apr-20 2:32 
QuestionTrigger keeps inserting duplicates Pin
greatwhite131-Mar-20 7:48
greatwhite131-Mar-20 7:48 
AnswerRe: Trigger keeps inserting duplicates Pin
ZurdoDev31-Mar-20 9:51
professionalZurdoDev31-Mar-20 9:51 
GeneralRe: Trigger keeps inserting duplicates Pin
greatwhite131-Mar-20 13:51
greatwhite131-Mar-20 13:51 
GeneralRe: Trigger keeps inserting duplicates Pin
ZurdoDev31-Mar-20 15:44
professionalZurdoDev31-Mar-20 15:44 
AnswerRe: Trigger keeps inserting duplicates Pin
Richard Deeming1-Apr-20 0:44
mveRichard Deeming1-Apr-20 0:44 
RantRe: Trigger keeps inserting duplicates Pin
Mycroft Holmes1-Apr-20 12:45
professionalMycroft Holmes1-Apr-20 12:45 
QuestionHow to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
Barath835730-Mar-20 1:57
Barath835730-Mar-20 1:57 
RantRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
ZurdoDev30-Mar-20 2:12
professionalZurdoDev30-Mar-20 2:12 
AnswerRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
ZurdoDev31-Mar-20 9:52
professionalZurdoDev31-Mar-20 9:52 
AnswerRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
Mycroft Holmes31-Mar-20 12:50
professionalMycroft Holmes31-Mar-20 12:50 
QuestionCreate a new Primary Key on survey table Pin
learning_new25-Feb-20 12:01
learning_new25-Feb-20 12:01 
AnswerRe: Create a new Primary Key on survey table Pin
Nathan Minier28-Feb-20 6:38
professionalNathan Minier28-Feb-20 6:38 
AnswerRe: Create a new Primary Key on survey table Pin
Eddy Vluggen28-Feb-20 9:48
professionalEddy Vluggen28-Feb-20 9:48 
AnswerRe: Create a new Primary Key on survey table Pin
David Mujica2-Mar-20 3:56
David Mujica2-Mar-20 3:56 
GeneralRe: Create a new Primary Key on survey table Pin
learning_new3-Mar-20 4:28
learning_new3-Mar-20 4:28 
QuestionIndexing question Pin
Super Lloyd5-Feb-20 13:35
Super Lloyd5-Feb-20 13:35 
AnswerRe: Indexing question Pin
Eddy Vluggen5-Feb-20 15:09
professionalEddy Vluggen5-Feb-20 15:09 
GeneralRe: Indexing question Pin
Super Lloyd5-Feb-20 17:38
Super Lloyd5-Feb-20 17:38 
GeneralRe: Indexing question Pin
Eddy Vluggen6-Feb-20 2:50
professionalEddy Vluggen6-Feb-20 2:50 
AnswerRe: Indexing question Pin
Jörgen Andersson5-Feb-20 22:28
professionalJörgen Andersson5-Feb-20 22:28 
AnswerRe: Indexing question Pin
Richard Deeming6-Feb-20 0:17
mveRichard Deeming6-Feb-20 0:17 
Questionintegrity constraint Pin
Tara112-Feb-20 6:23
Tara112-Feb-20 6:23 
The quote below is from An Introduction to Database Systems, 8th edition, C J Date.

Is that possible systems crash while transferring updates from the physical device to the database?
If yes, since transactions are the unit of recovery, those updates that are written to the database should be undone?
"It is quite possible, for instance, that the system might crash after the COMMIT has been honored but before the updates have been physically written to the database--they might still be waiting in a main-memory buffer and so lost at the time of the crash. Even if that happens, the system's restart procedure will still record those updates in the database: it is able to discover the values to be written by examining the relevant records in the log."


modified 2-Feb-20 13:48pm.

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.