Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performancehttp://blogs.technet.com/b/dataplatforminsider/archive/2012/03/08/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance.aspxIn a fast evolving new world of data you need immediate answers to any question you ask about your business. Imagine the possibilities of being able to analyze 7 billion rows of data in seconds to generate an insight that moves the business forward. Companiesen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)re: Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performancehttp://blogs.technet.com/b/dataplatforminsider/archive/2012/03/08/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance.aspx#3506748Fri, 29 Jun 2012 22:32:27 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3506748Dog<p>TM1 had in-memory far before QlikView</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3506748" width="1" height="1">re: Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performancehttp://blogs.technet.com/b/dataplatforminsider/archive/2012/03/08/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance.aspx#3506482Thu, 28 Jun 2012 15:15:32 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3506482Cat<p>Nice feature stolen from Qlikview...</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3506482" width="1" height="1">re: Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performancehttp://blogs.technet.com/b/dataplatforminsider/archive/2012/03/08/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance.aspx#3500054Fri, 25 May 2012 10:55:17 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3500054Andy<p>Is there a way to capacity plan for xVelocity in-memory engine? &nbsp;I&#39;ve been looking for some calculations but haven&#39;t found anything so far. &nbsp;Based on the source data table I would like to know the expected memory requirements.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3500054" width="1" height="1">re: Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performancehttp://blogs.technet.com/b/dataplatforminsider/archive/2012/03/08/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance.aspx#3499356Tue, 22 May 2012 20:10:44 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3499356mbourgon<p>BA: here&#39;s the link from MS. &nbsp;I&#39;ve been digging through it since I have to do the same thing. &nbsp;Good luck!</p> <p><a rel="nofollow" target="_new" href="http://social.technet.microsoft.com/wiki/contents/articles/5069.add-data-to-a-table-with-a-columnstore-index-using-partition-switching.aspx">social.technet.microsoft.com/.../5069.add-data-to-a-table-with-a-columnstore-index-using-partition-switching.aspx</a></p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3499356" width="1" height="1">re: Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performancehttp://blogs.technet.com/b/dataplatforminsider/archive/2012/03/08/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance.aspx#3499345Tue, 22 May 2012 19:24:40 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3499345mbourgon<p>BA: if you can partition your fact table, then you&#39;re still good, but it&#39;ll take some work. &nbsp;If you haven&#39;t already, partition your fact table. &nbsp;Now create a columnstore on the fact table. &nbsp;Nightly, instead of loading into the fact table directly, load into a staging table, add columnstore index to the staging table, and the SWITCH into your main fact table. &nbsp;</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3499345" width="1" height="1">re: Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performancehttp://blogs.technet.com/b/dataplatforminsider/archive/2012/03/08/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance.aspx#3495389Tue, 01 May 2012 05:32:06 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3495389BA<p>With columnstore index i cant insert the data which means i have to disable and enable the columstore index what about the time it takes to on and off i have more than 200 million records in different facts tables </p> <p>how does this helps ?</p> <p>meet2bhasker@gmail.com</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3495389" width="1" height="1">re: Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performancehttp://blogs.technet.com/b/dataplatforminsider/archive/2012/03/08/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance.aspx#3489937Tue, 03 Apr 2012 05:16:06 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3489937TejasJ<p>Intresting new feature..</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3489937" width="1" height="1">re: Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performancehttp://blogs.technet.com/b/dataplatforminsider/archive/2012/03/08/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance.aspx#3488221Fri, 23 Mar 2012 04:13:43 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3488221bob mick<p>Is xVelocity also now the PowerPivot for Excel engine?</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3488221" width="1" height="1">