Sql Queries, Sql Tips, Sql Server, Programming Tips, Sql.
Reset SET NOCOUNT to OFF SET NOCOUNT OFF; GO Tip 5: Avoid ORDER BY, GROUP BY, and DISTINCT Use ORDER BY, GROUP BY, and DISTINCT only when necessary. SQL creates work tables and puts the data there. It then organizes the data in the worktable based on the query and then returns the results. Tip 6: