JohnNash (2/12/2014)
just wanted to check going forward (if data increases) will be a performance problem.
Honestly, there's no way to answer that question. Depends on too many factors.
Write the code, test on representative data volumes, if performance is inadequate adjust the code.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability