Jean-Sebastien Carle (8/19/2009)
TheSQLGuru (8/19/2009)
could you please redo your testing using a char(17) datatype instead of a varchar(17)?I'm not sure what would be the point since IP addresses (when used as strings) are not fixed length.
The point would be exactly what your article was about - what offers the best performance. There is a chance that fixed storage will perform better (however slightly just like parsename as opposed to substrings). It should be very easy to modify your existing test suite to try this option out. It wasn't like I was asking you to completely reinvent the wheel. 🙂
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service