Working with my compatriots Ayad Shammout (@aashammout) and Peter Myers, we had found out that PowerPivot at times can be really insensitive…in terms of case that is. That is by default, the collation for PowerPivot is case-insensitive. For example, if you import the table below: Within the PowerPivot window, you’ll notice that the lower case [...]
Posts Tagged ‘Loading’
PowerPivot, you are so insensitive! (case that is)
Posted in PowerPivot, tagged Excel, FAQ, Loading, workbook on June 18, 2010 | 11 Comments »
The Ultimate SQL Data Loading Performance Guide
Posted in Integration Services, SQL, tagged Loading, Performance on February 15, 2009 | Leave a Comment »
For all of you whom wanted to know about how to load data within SQL Server, please refer to the "Ultimate" SQL Data Loading Performance Guide at: http://sqlcat.com/whitepapers/archive/2009/02/15/the-data-loading-performance-guide-2008.aspx This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune [...]

