SQL Server 2005 does not support hash partition as a product feature. But that doesn't mean you can't apply the concept of hash partition in your application or database design. Recently, I worked on an application that used SQL Server to persist the customized ASP.NET session state information, similar to the SQL Server mode for ASP.NET session ...