|
|
-
|
|
In SSAS, data structures do not always conform to the snowflake or star schema model where one fact is associated with a single dimension member. For example, consider the example of financial transactions in accounts that can have one or more customers. This can be modeled as:
The relationship ......
|
|
-
|
|
Here is a quick example of when using temporary tables will give you a big performance gain. I recently was given this query to improve, as it was taking over 15 hours to run:
SELECT *
FROM
(
SELECT * FROM
GL_Star_FactsDetails GL
LEFT JOIN DimAccount ACCT on GL.Account = ACCT.AccountRapidDe......
|
|
-
|
|
In SSAS, to improve query performance, it’s important to understand what happens inside analysis services when a query is run. Analysis Services is made up of two engines:
Formula Engine (FE) – It is single-threaded. It processes the MDX queries, determines what data is needed to answer the......
|
|
-
|
|
When building a SSAS cube, you typically have a star schema containing dimension tables and fact tables. For dimension tables, you generally model these as one table per object. Building the dimension in the ETL system involves joining the various normalized description and hierarchy tables that p......
|
|
-
|
|
As you may know, the TechEd in the U.S. is not the only one. There have been many all over the world, and it 2011 there have been one’s in New Zealand, Australia, and next month in Russia. The Australia and New Zealand TechEd ended a couple of months ago, and all the videos from those sessio......
|
|
-
|
|
If you’ve been working with databases for any length of time, you have heard the term normalization.
Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in ......
|
|
-
|
|
All the videos for the sessions at 24 Hours of PASS are available for free. Check the session schedule for a complete list. Some great stuff!
......
|
|
-
|
|
First off, they don’t work for Microsoft. A Microsoft Regional Director (RD) is an unbiased third-party evangelist of Microsoft products and services. Regional Directors are members of an elite, worldwide group of technology thought-leaders known for their national and international speaking......
|
|
-
|
|
As a SQL Server DBA, usually the largest databases in size and in number of users that I had to manage was an ERP database, such as Microsoft Dynamics AX. And because these types of database typically have a lot of users, database blocking was a major concern. This would manifest itself via calls ......
|
|
-
|
|
As a follow-up to my post SQL Server “Denali”: New Certifications, the seven exams for SQL Server 2012 are:
Querying Microsoft SQL Server (70-461) [BI and DBA]
Administering a Microsoft SQL Server 2012 Database (70-462) [DBA]
Building Data Warehouses with Microsoft SQL Server 2012 (70-463) [BI]......
|
|