SELECT Count(*)
FROM [dbo].[book];
WITH __data
AS (SELECT [dbo].[book].[id],
[dbo].[book].[writerid],
[dbo].[book].[name],
[dbo].[book].[year],
[dbo].[book].[description],
Row_number()
OVER(
ORDER BY [dbo].[book].[name] DESC) AS [_#_]
FROM [dbo].[book])
SELECT [id],
[writerid],
[name],
[year],
[description]
FROM __data
WHERE [_#_] BETWEEN 6 AND 7
BETWEEN expression does not take sql parameter, just values.
This causes to create new execution plan every time query is called.
SqlQueryPager builds query like this one:
BETWEEN expression does not take sql parameter, just values. This causes to create new execution plan every time query is called.