Các cách thay thế Cursor trong SQL Server để tăng performance

Các cách để thay thế cursor 1. Dùng Cross apply update test1 set test1.a = c.q from test1 b cross apply dbo.fnsomelogic(b.x,b.y,b.z) c ...

Convert Implicit and the related performance issues with SQL Server

A great way to tune the sql query is to look at the information in the 'set statistics io on' with the 'scan count' and look...

T-SQL Performance tuning best practices collection

Maximum Degree of Parallelism in T-SQL Queries http://bloggerzspot.com/maximum-degree-of-parallelism-in-t-sql-queries/ Avoid SQL Server ...