It means that if all columns making up the primary key is larger than 900 bytes combined, you would be able to add that to the alias table. In practice...

Thanks for the feedback.

Your are right with the issue with renamed columns, I have already runned into it, but it is not easy to fix, as it would need to...

use these links below or type the sql.soendergaard.info. in the address bar.

-- # You can download a complete install script here.

-- # http://files.soendergaard.info/Install_spFixColumnDefaultNaming_V2005-2008.sql

-- #

-- # I also...

Did you download the install script from below. or did you copy the sql code. I tried both install scripts on a server, and none of them failed with missing...

Actually I tried to design it as you described. But it is not that easy, if I want the code reusablity, which my TVF gives me.

I reuse the same...

BTW for all future readers.

I have noticed two errors in the publication.

1. I am showing the source code for spFixColumnCheckNaming instead of spFixColumnDefaultNaming. However they are 99% identical...

Don't worry about the warning it only matters if you alias rows are larger than 900 bytes. And if you are not using any aliases it doesn't matter at all

Actually...

An untested idea for minimizing hash collisions could be, having 2 hash columns. One for hashing columns in ascending and one in descending order. If you have a hash collisions...

An untested idea for minimizing hash collisions could be, having 2 hash columns. One for hashing columns in ascending and one in descending order. If you have a hash collisions...

Another limitation is the small varchar sizes for @TableName, @ClusterKeyName and ClusteredIndexNames. You should use sysname instead of varchar(50) and varchar(75). This will also make the script usable international.

Also tablename,...

If you use the temporary table as part of your solution, why doesn't that temp table have the right datatypes and indexes?

Are you copying data from another table into the...

If you can't modify the table, when there is not much you can do.

Are you allowed to create an indexed view on the table? This view could use the...

I believe that I can save you the headache. I have just published two scripts, one which can convert bound default objects to column defaults and one that converts bound...

You are converting to a date datatype, but that doesn't exist on SQL 2005 only 2008. Try DateTime instead

If the table didn't had varchar columns before the refactoring, when sql server would have to include some more bytes for each row. Each row would be expanded to include...