Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Files for memory-optimized tables Expand / Collapse
Author
Message
Posted Thursday, June 5, 2014 1:26 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 11:58 AM
Points: 8,688, Visits: 9,221
Te trouble with this question is that 2 3 things store the data for these tables: data, delta, and log. If I destroy the log when the data is not up to date, there is no way you can recover the date - it's lost. Equally if I destroy the data file when the log doesn't go back to the beginning of history, it's unlikely that I can recover the data (unless of course I have backup). So at least those two table are needed. The data and delta files are updated by a backrground process so that at any time (other than at a checkpoint) they do not represemt the state of teh table.

Or to put it in simple terms, the question and annswer is wrong. Amd this is confirmed in the page referenced in the application!


Tom
Post #1578037
Posted Monday, June 9, 2014 3:11 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:07 AM
Points: 1,192, Visits: 553
Revenant (6/4/2014)
Nice question, wrong answer...

Thanks, Steve!

+ 1
Post #1578735
Posted Monday, June 9, 2014 3:11 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:07 AM
Points: 1,192, Visits: 553
TomThomson (6/5/2014)
Te trouble with this question is that 2 3 things store the data for these tables: data, delta, and log. If I destroy the log when the data is not up to date, there is no way you can recover the date - it's lost. Equally if I destroy the data file when the log doesn't go back to the beginning of history, it's unlikely that I can recover the data (unless of course I have backup). So at least those two table are needed. The data and delta files are updated by a backrground process so that at any time (other than at a checkpoint) they do not represemt the state of teh table.

Or to put it in simple terms, the question and annswer is wrong. Amd this is confirmed in the page referenced in the application!

+ 1
Post #1578736
Posted Monday, June 9, 2014 10:07 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 4, 2014 12:29 PM
Points: 1,812, Visits: 584
easy one.
thanks Steve.
Post #1578899
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse