Conformed dimensions
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,503 reads
James Serra's Blog
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,471 reads
SQL Server 2012 RC0 is here!
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,090 reads
Degenerate Dimensions
Degenerate dimensions, also called fact dimensions, are standard dimensions that are constructed from attribute columns in fact tables instead of...
2011-11-16
4,971 reads
Many-to-Many Dimensions
In SSAS, data structures do not always conform to the snowflake or star schema model where one fact is associated...
2011-11-14
1,502 reads
Parallel execution in SSIS
Parallel execution in SSIS improves performance on computers that have multiple physical or logical processors. To support parallel execution of...
2011-11-11
6,504 reads
Why does my SSIS package run slower in BIDS than DTEXEC?
If you have been creating SSIS packages in Business Intelligence Development Studio (BIDS) for any length of time, you have...
2011-11-09
1,083 reads
SQL Server 2012: New Certifications
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,474 reads
What is SQL PASS?
A few weeks ago I asked a colleague, who is a DBA, if he was going to the SQL PASS...
2011-11-04
1,110 reads
Salaried employee vs contractor
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,120 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Pantai Indah Kapuk Tlpn/Wa 0853.7373.7551
Jl. Pantai Indah Selatan Blok DF No.1 & 2, Kapuk Muara, Kecamatan Penjaringan, Jkt...
BCA KCP Tebet Barat 2 Telpon/WA:08137887595
BCA KCP Tebet Barat 2 Telpon/WA:08137887595.Jl. Tebet Raya No.25 B Blok CI, Tebet Tim.,...
BCA KCP Puri Deltamas Tlpn/Wa 0853.7373.7551
Komplek Ruko Puri Deltamas Blok J. 5, Jl. Bandengan Sel. No.43, Daerah Khusus Ibukota...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers