How to set MicroStrategy to use SQL Server's minimally logged INSERT for the intermediate temporary tables
This is going to be a discussion around some specific VLDB settings which once enabled, can provide flexible control over how the temporary tables are used in fulfilling a report request. As you've probably noticed by now, for some types of data merging (usually when a report has metrics coming from separate fact tables), MicroStrategy uses multiple passes to fulfil it. Those intermediate passes will then be merged in a last pass (if metric join type is set to outer then the last pass is a full outer join). In the case of SQL Server database instance, the intermediate passes will store the data into true temporary tables, as stated by the "Tables -> Intermediate Table Type" VLDB option. During the report execution, the temporary tables are created under the tempdb database using SELECT INTO statement. This is the fastest way to create and populate a table in SQL Server, mainly because it's not a logged operation like INSERT and DELETE. We're constan...