By Johnny Papa – In this month’s column I’ll demonstrate four techniques that can be used to either improve your SQL Server™-based application’s performance or improve its scalability. I’ll examine the use of LEFT JOINs, CROSS JOINs, and retrieving an IDENTITY value. Keep in mind that there is no ma
