T-SQL Analyzer

# SQL Server Rule: SML026 | | | |----|----| | Assembly | TSQLSmellSCA | | Namespace | TSQLSmellSCA | | Class | TSQLSmellSCA26 | ## Rule Information | | | |----|----| | Id | SML026 | | Friendly Name | RANGE windows are much slower then ROWS (Implicit use) | | Category | CodeSmells | | Ignorable | false | | Applicable Types | Model | ## Description RANGE windows are much slower then ROWS (Implicit use) ### Examples ```sql /* Default is Range UNBOUNDED PRECEDING ( Defining the frame )*/ Create Procedure dbo.ImplicitRangeWindow as Set nocount on select sum(TestTableSSDT.Col1) over(partition by TestTableSSDT.IdCol order by TestTableSSDT.Col2 ) as RollingBalance, row_number() over(partition by TestTableSSDT.IdCol order by TestTableSSDT.Col2 ) as Rown from dbo.TestTableSSDT order by Col1,Col2; -- SML026 ``` _{^{Generated by a tool}}