Skip to Content
Programming Microsoft® SQL Server™ 2008
book

Programming Microsoft® SQL Server™ 2008

by Leonard Lobel, Andrew Brust, and Stephen Forte
October 2008
Beginner to intermediate
1024 pages
31h 30m
English
Microsoft Press
Content preview from Programming Microsoft® SQL Server™ 2008

Perspectives

As we mentioned earlier, one hallmark of Analysis Services post-version-2000 is its flexibility and accommodating nature. For example, the ability to have drillthrough actions, role-playing dimensions, and multiple fact tables allows you to use a single cube for a multitude of multidimensional and relational queries. With Analysis Services 2000, each fact table required its own cube, role-playing dimensions did not exist, drillthrough functionality was much more limited, and the lack of proactive caching meant that cube data could not be as fresh as is sometimes necessary.

This notion of a single cube acting as a one-stop shop for all your dimensional data gives rise to an Analysis Services 2005/2008 concept called the unified dimensional ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Programming Microsoft® SQL Server® 2012

Programming Microsoft® SQL Server® 2012

Leonard Lobel and Andrew Brust
Microsoft® SQL Server® 2008 Internals

Microsoft® SQL Server® 2008 Internals

Paul Randal Kalen Delaney Kimberly Tripp, and Conor Cunningham

Publisher Resources

ISBN: 9780735625990