Home Forums SQL Server 2012 SQL Server 2012 - T-SQL 108,000,000 row table - check for matches RE: 108,000,000 row table - check for matches
Erland Sommarskog
SSC-Insane
Points: 24038
More actions
September 24, 2013 at 5:59 am
#1652668
A small addiiton in case it was not clear: add that colimn as a computed column to the able and index it. That saves some space over adding it as a regular column.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]