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 Wednesday, June 4, 2014 12:01 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:59 PM
Points: 31,082, Visits: 15,529
Comments posted to this topic are about the item Files for memory-optimized tables






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1577212
Posted Wednesday, June 4, 2014 12:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:05 AM
Points: 13,045, Visits: 10,809
Easy one (as I watched a session on Hekaton last week), thanks!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1577213
Posted Wednesday, June 4, 2014 12:52 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Easy one, thanks Steve.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1577221
Posted Wednesday, June 4, 2014 1:33 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:41 AM
Points: 973, Visits: 2,213
Thank you for the post, Steve, nice one.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1577230
Posted Wednesday, June 4, 2014 1:44 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 11:45 PM
Points: 562, Visits: 887
Thanks for question Steve.

--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1577232
Posted Wednesday, June 4, 2014 1:49 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:01 AM
Points: 1,746, Visits: 763
Nice question, thanks

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1577233
Posted Wednesday, June 4, 2014 3:35 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 3:53 AM
Points: 3,986, Visits: 5,241
Ford Fairlane (6/4/2014)
Nice question, thanks


+1


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1577249
Posted Wednesday, June 4, 2014 5:47 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 5:15 AM
Points: 4,054, Visits: 3,491
Nice question. Thanks.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1577270
Posted Wednesday, June 4, 2014 10:30 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 10:48 AM
Points: 4,126, Visits: 3,427
Nice question, wrong answer...

Thanks, Steve!
Post #1577417
Posted Thursday, June 5, 2014 1:26 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:57 PM
Points: 7,745, Visits: 9,493
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
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse