Role-playing Dimensions
Dimensions are often recycled for multiple purposes within the same database. For instance, a “Date” dimension can be used for...
2011-11-28
4,885 reads
Dimensions are often recycled for multiple purposes within the same database. For instance, a “Date” dimension can be used for...
2011-11-28
4,885 reads
A conformed dimension is a dimension that has the same meaning to every fact with which it relates. Conformed dimensions allow...
2011-11-21
3,521 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,474 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,098 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,993 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,514 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,528 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,089 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,478 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,122 reads
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Comments posted to this topic are about the item A Challenge of Our Knowledge
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Comments posted to this topic are about the item Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers