Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Boost performance and use less disk space with hash keys
- Question on sample SPI don't see where you are referencing the calculated field Name_GroupName_hb. Your SP example shows a comparison of @id against hashkey, but you are creating the hashkey field on the fly. Are you saying I should create a field in the Department table called Name_GroupName_hb...
- Tags: @id, LIKE, Name_GroupName_hb, sql server, strings, hashkey, SirPssD, software, disk, performance
- Discussion threads 2006-03-07
Additional Resources
- Boost performance and use less disk space with hash keys
- Arthur Fuller discusses a very slick alternative to using string indexes known as hash buckets or hash keys. Find out how using hash keys can produce a gain in performance and save you disk space. A common SQL Server application requirement is to support searches based on one...
- Tags: Arthur Fuller, Databases, Performance management, SQL Server application requirement, performance, disk, long string, hash, SQL Server Newsletter, Column, Index, Table, Enterprise Software, Human Resources, Workforce Management, Software, Data Management
- Technical articles 2006-03-06
- << Previous
- page 1 of 1
- Next >>