Some useful SQL Server 2017 Transact-SQL optimization tips (Part 2) Try to avoid using the DISTINCT clause, whenever possible. The DISTINCT clause should only be used if you know that duplicate returned rows are a possibility. Because using the DISTINCT clause will result in some performance degradation, you should use this clause only when it is necessary. Use table variables...
Tag: optimization
Some useful SQL Server 2017 Transact-SQL optimization tips (Part 1)
Some useful SQL Server 2017 Transact-SQL optimization tips (Part 1) Try to avoid using SQL Server cursors, whenever possible. SQL Server cursors can result in some performance degradation in comparison with select statements. Try to use correlated subquery or derived tables, if you need to perform row-by-row operations. Encapsulate your Transact-SQL code inside a transaction when you modify database, not...
Tips for using stored procedures in SQL Server 2014
Tips for using stored procedures in SQL Server 2014 Try to avoid using temporary tables and DDL (Data Definition Language) statements inside your stored procedure. Using temporary tables or DDL statements inside stored procedure reduces the chance to reuse the execution plan. Call stored procedure using its fully qualified name. The complete name of an object consists of four identifiers:...
SQL Server monitoring and optimization–(Part 2)
SQL Server monitoring and optimization – (Part 2) Author: Basit A. Farooq Editor’s Note: In this first of the two part article series, you learned how to use monitoring tools, including System Monitor and SQL Server Profiler. You also learned how capture a trace file or table using SQL Server Profiler. In this second part, you learn how to use...
Tips for designing SQL Server 2012 tables
Tips for designing SQL Server 2012 tables Try to reduce the number of columns in a table. The fewer the number of columns in a table, the less space the table will use, since more rows will fit on a single data page, and less I/O overhead will be required to access the table’s data. Use char/varchar columns instead of...