1. You could just have the whole field that you are using as the first character as the partition key. You can then setup your partition scheme to be A,...

Use SSIS and make sure that the destination table has no indexes. Use a data flow task and not SQL command task it will be much faster and will be...

Exactly...if you know that the 2 numbers you are "bizzing" and "buzzing" are prime numbers then the only time you would "BizzBuzz" is when it's evenly divisible by the product...