Tag Archives: Trace Flag 610

How to set SQL Server trace flag 610 on

SQL Server implements minimally logged operations to support high-volume data loading scenarios. Minimally logged operations will speed up your loading operations. It will also reduce the amount of log entries which implies less disk usage by the database logs or … Continue reading

Posted in SQL Server 2014 | Tagged , , | Leave a comment

Why is my data warehouse always out of disk space?

This question most customers ask business intelligence (BI) consultants who implemented data warehouse (DWH) or BI solutions. Not stating the obvious, DWH’s do grow over time, what we need to pay attention to is the database log space. The log … Continue reading

Posted in SQL Server 2008 | Tagged , , , | 1 Comment