PowerPivot, you are so insensitive! (case that is)

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 “a” has now become an upper case “A”.  If “a” had come before “A”, then both rows would be “a” instead of “A” 😉 Why are you so in-sensitive? Actually, it isn’t THAT in-sensitive.  When importing, the PowerPivot client picks up the regional settings and…

Rate this:

The Ultimate SQL Data Loading Performance Guide

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 and optimize the bulk loading process.   Enjoy!  

Rate this: