Message from MarkTab
After years of graduate education and even more years of professional experience (with SAS and Microsoft), I still find data mining an awesome and challenging topic. I use this blog to share my best tips and achievements learned sometimes through great struggle. Today, I provide data mining advice to leading companies and industries in the United States and around the world. I share my journey and insights at leading conferences like SAS Global Forum, Microsoft TechEd, and Predictive Analytics World.
As I continue learning, my hope is to inspire you to not just learn more but also apply mathematics through technology. Data mining is a powerful tool for leaders of leaders of leaders. If you like this blog, click the "About" page to find out how to go deeper. -- Mark Tabladillo ("MarkTab")- by
Tag Archives: query optimization
SQL Server Data Mining and Apollo Columnstore Indexes
Note: This post was revised November 12, 2010 to clarify the brand names Apollo and VertiPaq (thanks Denny Lee of SQLCAT) — and I extended comments on Amir Netz’s C++ versus C# analogy which I believe clarifies the discussion between what … Continue reading
Architecture of Query Execution — Retrieving Data from Storage
Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 30 An earlier chapter discusses how Analysis Services saves data in files. This chapter talks about how SSAS retrieves information from these disparate files to fulfill query and processing requests on different … Continue reading
Architecture of Query Execution — Calculating MDX Expressions
Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 29 This chapter starts with a claim which should make everyone happy: “Optimization of MDX calculations was one of the most important goals of Analysis Services 2008.” (page 527) This focus on MDX performance … Continue reading
English