Reputation
730
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 8 18
Newest
 Necromancer
Impact
~45k people reached

Apr
11
comment How to improve estimate of 1 row in a View constrained by DateAdd() against an index
In summary, as stated in your blog. this answer provides a usable estimate and seek based plan. The answer by @PaulWhite gives the best estimate. Perhaps the 1 row estimates I was getting (vs 1500) could be due to the table not having any rows in the last ~24 hours.
Apr
11
accepted How to improve estimate of 1 row in a View constrained by DateAdd() against an index
Apr
11
comment How to improve estimate of 1 row in a View constrained by DateAdd() against an index
Great point. I was thinking it could convert it internally. Verified that it is performing a scan.
Apr
9
revised How to improve estimate of 1 row in a View constrained by DateAdd() against an index
update picture
Apr
9
answered How to improve estimate of 1 row in a View constrained by DateAdd() against an index
Apr
9
revised How to improve estimate of 1 row in a View constrained by DateAdd() against an index
added Sql Server Version to top
Apr
9
revised How to improve estimate of 1 row in a View constrained by DateAdd() against an index
added two more test cases
Apr
8
asked How to improve estimate of 1 row in a View constrained by DateAdd() against an index
Apr
5
answered Map a Login to a User that was Created Without Mapping to a Login
Mar
18
awarded  Necromancer
Mar
3
awarded  Famous Question
Dec
30
awarded  Popular Question
Dec
18
revised Are SQL Server in-place upgrades as ill advised as they used to be?
Mention server roles and provide example script
Dec
18
answered Are SQL Server in-place upgrades as ill advised as they used to be?
Nov
24
comment Deterministic function for getting today's date
Have you considered just pushing the view instead of replicating a table? I suppose this assumes the servers are in the same timezone which could be overcome in the view.
Nov
14
revised Why does ORDER BY not belong in a View?
added 8 characters in body
Nov
14
revised Why does ORDER BY not belong in a View?
Improve example/comments and suggestion.
Nov
14
answered Best practice between using LEFT JOIN or NOT EXISTS
Nov
11
awarded  Notable Question
Nov
6
comment How to log error details when using using try/catch for dynamic SQL backup commands
This works great for some common errors but there are some errors that apparently only get thrown directly to the client. The sp_readerrorlog log will include a message saying refer to "application log", where I assume by "application" they mean the external process that is issuing commands. SO Link