Buffer Size in SSIS
Behind the scenes in SSIS, the data flow engine uses a buffer-oriented architecture to efficiently load and manipulate datasets in...
2011-11-30
16,624 reads
Behind the scenes in SSIS, the data flow engine uses a buffer-oriented architecture to efficiently load and manipulate datasets in...
2011-11-30
16,624 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,863 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,505 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,471 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,091 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,973 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,503 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,504 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,083 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,475 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Tlpn/wa0853.7373-7551 Jl. Lenteng Agung Raya No.26 E-F, Ps. Minggu, Kota Jakarta Selatan, Daerah Khusus...
Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec. Cilandak, Kota Jakarta Selatan,...
Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers