Posted in Admin

Performance Tuning Part-8-Temporary tables

Tuning Tip: Always create the index after dumping the data in to temporary tables. Loading the data after index creation takes more time and causes…

Continue Reading... Performance Tuning Part-8-Temporary tables
Posted in Admin

Performance Tuning part -7-Print Statement

Do not use the print statement in production (If required, use variable to capture the message for logging). Developers often use print statement to debug…

Continue Reading... Performance Tuning part -7-Print Statement
Posted in Admin T-SQL

Performance Tuning Tip#2

Tip:┬áDo not use Order by unless the output is not required in sorted format. If ‘Order by’ is required then include only required columns in…

Continue Reading... Performance Tuning Tip#2