Tag: nolock

Pro Members SQL Server Standard Members

Tips for using table hints in SQL Server 2017

by

Tips for using table hints in SQL Server 2017 If you want to set any table hints, do not remember to test the query with hint and without the hint and compare results. Because SQL Server 2017 query optimizer usually proposes the best execution plan, you should test the query with table hint and use this hint only when it...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Top 20 tips to optimize your T-SQL code (Part-1)

by

Top 20 tips to optimize your T-SQL code (Part-1) Author: Basit A. Farooq Troubleshooting the database performance bottlenecks is not an easy task, since it can be influenced by a lot of different factors. However, common symptoms of SQL Server database performance bottlenecks are related to bad Transact-SQL (T-SQL) code. This is because, the core database application logic is done...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

Top 20 tips to optimize your T-SQL code (Part-1)

by

Top 20 tips to optimize your T-SQL code (Part-1) Author: Basit A. Farooq Troubleshooting the database performance bottlenecks is not an easy task, since it can be influenced by a lot of different factors. However, common symptoms of SQL Server database performance bottlenecks are related to bad Transact-SQL (T-SQL) code. This is because, the core database application logic is done […]

Continue Reading →
Pro Members SQL Server Standard Members

Tips for using table hints in SQL Server 2014

by

Tips for using table hints in SQL Server 2014 One of the ways to increase the queries performance is using the SQL Server 2014 table hints. The table hints specify a locking method to be used by the query optimizer with this table, specify the locking granularity for a table, or one or more indexes to be used by the...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →