As queries become more complex, temporary tables are used more and more. While temporary table may sometimes be unavoidable, they can often be. Compare the SQL Server NOLOCK and READPAST table hints with step by step examples to show which data is deleted, returned in results sets and locked. Could Change Tracking be slowing down your SQL Server? Learn how to see internal tables, trigger cleanup, and speed up Change…