Reference Dimensions
A reference dimension occurs when the key column for the dimension is joined indirectly to the fact table through a...
2011-11-18
1,458 reads
A reference dimension occurs when the key column for the dimension is joined indirectly to the fact table through a...
2011-11-18
1,458 reads
SQL Server 2012 RC0 (Release Candidate 0), formerly known as SQL Server Denali, is now available for download. SQL Server 2012...
2011-11-17
1,081 reads
Degenerate dimensions, also called fact dimensions, are standard dimensions that are constructed from attribute columns in fact tables instead of...
2011-11-16
4,937 reads
In SSAS, data structures do not always conform to the snowflake or star schema model where one fact is associated...
2011-11-14
1,490 reads
Parallel execution in SSIS improves performance on computers that have multiple physical or logical processors. To support parallel execution of...
2011-11-11
6,385 reads
If you have been creating SSIS packages in Business Intelligence Development Studio (BIDS) for any length of time, you have...
2011-11-09
1,079 reads
As a follow-up to my post SQL Server “Denali”: New Certifications, the seven exams for SQL Server 2012 are:
Querying Microsoft...
2011-11-07
3,466 reads
A few weeks ago I asked a colleague, who is a DBA, if he was going to the SQL PASS...
2011-11-04
1,098 reads
Are you a salaried employee looking to switch to a W-2 or 1099 contractor? (For an explanation of W-2 and...
2011-11-02
4,108 reads
All the videos for this popular conference are online or will be soon (48 of them). Take a look at the...
2011-10-31
2,256 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Bonjour à tous, J'ai un problème d'exécution de mes packages SSIS. A chaque opération...
Comments posted to this topic are about the item Being an extroverted introvert at...
I have data that contains poll results, with the poll_id consistuting a single row...
How are the statistics for query optimization stored in SQL Server?
See possible answers