Click here to Skip to main content
14,695,085 members
Home » Discussions » Database
   

Database

 
RantRe: Trigger keeps inserting duplicates Pin
Mycroft Holmes1-Apr-20 13:45
professionalMycroft Holmes1-Apr-20 13:45 
QuestionHow to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
Barath835730-Mar-20 2:57
MemberBarath835730-Mar-20 2:57 
RantRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
ZurdoDev30-Mar-20 3:12
mveZurdoDev30-Mar-20 3:12 
AnswerRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
ZurdoDev31-Mar-20 10:52
mveZurdoDev31-Mar-20 10:52 
AnswerRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
Mycroft Holmes31-Mar-20 13:50
professionalMycroft Holmes31-Mar-20 13:50 
QuestionCreate a new Primary Key on survey table Pin
learning_new25-Feb-20 13:01
Memberlearning_new25-Feb-20 13:01 
AnswerRe: Create a new Primary Key on survey table Pin
Nathan Minier28-Feb-20 7:38
professionalNathan Minier28-Feb-20 7:38 
AnswerRe: Create a new Primary Key on survey table Pin
Eddy Vluggen28-Feb-20 10:48
professionalEddy Vluggen28-Feb-20 10:48 
AnswerRe: Create a new Primary Key on survey table Pin
David Mujica2-Mar-20 4:56
MemberDavid Mujica2-Mar-20 4:56 
GeneralRe: Create a new Primary Key on survey table Pin
learning_new3-Mar-20 5:28
Memberlearning_new3-Mar-20 5:28 
QuestionIndexing question Pin
Super Lloyd5-Feb-20 14:35
MemberSuper Lloyd5-Feb-20 14:35 
AnswerRe: Indexing question Pin
Eddy Vluggen5-Feb-20 16:09
professionalEddy Vluggen5-Feb-20 16:09 
GeneralRe: Indexing question Pin
Super Lloyd5-Feb-20 18:38
MemberSuper Lloyd5-Feb-20 18:38 
GeneralRe: Indexing question Pin
Eddy Vluggen6-Feb-20 3:50
professionalEddy Vluggen6-Feb-20 3:50 
AnswerRe: Indexing question Pin
Jörgen Andersson5-Feb-20 23:28
professionalJörgen Andersson5-Feb-20 23:28 
AnswerRe: Indexing question Pin
Richard Deeming6-Feb-20 1:17
mveRichard Deeming6-Feb-20 1:17 
Questionintegrity constraint Pin
Tara112-Feb-20 7:23
MemberTara112-Feb-20 7:23 
AnswerRe: integrity constraint Pin
Wendelius2-Feb-20 9:47
mveWendelius2-Feb-20 9:47 
Not sure if I understand the question correctly, but are you looking for Rollforward? . With rollforward, when the database is recovered, all the logs are reapplied and in the end, everything that is not committed is rolled back. This guarantees a consisted situation even after crash.

If the recovery is interrupted because of a new crash, the recovery is simply started from the beginning next time.
GeneralRe: integrity constraint Pin
Tara112-Feb-20 10:07
MemberTara112-Feb-20 10:07 
GeneralRe: integrity constraint Pin
markkuk3-Feb-20 0:48
Membermarkkuk3-Feb-20 0:48 
Questiontransaction recovery Pin
Tara112-Feb-20 6:46
MemberTara112-Feb-20 6:46 
AnswerRe: transaction recovery Pin
Eddy Vluggen3-Feb-20 4:00
professionalEddy Vluggen3-Feb-20 4:00 
QuestionCopy structure of all the tables of one database to another server Pin
Member 1473192331-Jan-20 5:58
MemberMember 1473192331-Jan-20 5:58 
AnswerRe: Copy structure of all the tables of one database to another server Pin
phil.o31-Jan-20 6:12
mvephil.o31-Jan-20 6:12 
AnswerRe: Copy structure of all the tables of one database to another server Pin
Eddy Vluggen3-Feb-20 4:01
professionalEddy Vluggen3-Feb-20 4:01 

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.