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 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 @ 11:45 PM
Points: 1,280, Visits: 608
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 @ 11:45 PM
Points: 1,280, Visits: 608
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, September 15, 2014 11:49 AM
Points: 1,848, Visits: 587
easy one.
thanks Steve.
Post #1578899
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse