THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

How Far Can You Push Tabular? Birds of a Feather at TechEd 2013–North America #msteched #ssas #tabular

I and Alberto Ferrari will moderate the following Birds of a Feather session at TechEd North America 2013:

TITLE: How Far Can You Push Tabular?
SPEAKER: A. Ferrari; M. Russo
TIMESLOT: June 5, 2013 at 1:30 pm
ROOM: 263

Abstract: Tabular is the new engine in SQL Server Analysis Services. It is an in-memory columnar database capable of unprecedented performance but… how far can we go with an in-memory database? Will you be able to load your data warehouse in-memory to obtain the best performance? What should you care about when building the DWH? What does “fast” mean? What about real-time data? Can you query many billions rows really fast? In this BOF we will show some theory and share some of our experience, but we will welcome your questions and experience, to build a round-table of experts in order to speak about this fascinating topic.

I really look forward to this event – I and Alberto have some experience using Tabular in many different scenarios, but every time we meet new people at conferences we discover that there are new challenges ahead. This session will be the place to discuss together where are the limits today. Much far than many people realize, in my opinion!

Published Monday, May 20, 2013 4:15 PM by Marco Russo (SQLBI)
Filed under: , , ,



Kasper de Jonge said:

I'll try to be there as well. Sounds interesting :)

May 22, 2013 2:38 PM

Marco Russo (SQLBI) said:

Nice Kasper! We just need someone that says "guys, be careful, your pushing it too much.. :)"

May 22, 2013 3:26 PM

Maria said:


Unfortunately, it seems this session was not recorded... Have you discovered, how far you can push it?

June 12, 2013 7:52 PM

Marco Russo (SQLBI) said:

It was an open discussion - there are several systems in the order of 30-40 GB in production. Compression rate may vary, ranging from hundred millions to billions of rows in the fact tables. Latency is another challenge. Within 1 hour we have many option, but near to 1 minute is a real challenge - at the moment it's just theory on the whiteboard, still no systems in production with this requirement.

I hope it helps!


June 13, 2013 7:01 PM

Maria said:

Thanks Marco.

June 13, 2013 7:42 PM
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement