Reputation
437
Top tag
Next privilege 500 Rep.
Access review queues
Badges
4 12
Newest
 Custodian
Impact
~25k people reached

  • 0 posts edited
  • 0 helpful flags
  • 27 votes cast
9h
comment SARG cardinality estimate, why not full-scan?
@MikaelEriksson i ran test on my machine as colleague pointed out this might be the reason- server collation Latin1_General_CI_AS and DB collation- SQL_Latin1_General_CP1_CI_AS. Thannks for link!
10h
comment SARG cardinality estimate, why not full-scan?
And it not always cheapest to seek/scan non-clustered index- when values are not distinct enough or non covering index, it may be cheaper to do clustered index scan instead.
10h
comment SARG cardinality estimate, why not full-scan?
Yes, i am aware of what you writing. As you can see, there is clustered index already on TestTableID. But the thing is- if SQL server cant see statistics of column data distribution (as in this case, due to data type mismatch that should require all row value data type conversion), it should choose Clustered index scan in this case, not index seek.
11h
awarded  Custodian
11h
reviewed Approve SARG cardinality estimate, why not full-scan?
13h
asked SARG cardinality estimate, why not full-scan?
Mar
5
awarded  Yearling
Mar
5
accepted Change Tracking clenup
Mar
5
comment Change Tracking clenup
Thanks for answer and links! Kendra Little on Change Tracking article is great. And seems can use sys.dm_tran_commit_table to see oldest transaction in change tracking table.
Mar
2
asked Change Tracking clenup
Jan
23
awarded  Notable Question
Sep
12
awarded  Notable Question
Oct
30
awarded  Popular Question
Sep
18
awarded  Popular Question
May
21
answered SA permissions issues with many nested objects
May
14
awarded  Caucus
Mar
8
comment Select MaxDate where hh:mm:ss makes the difference
if there is 2 rows with the same timestamp and tag, there still can be duplicates.
Mar
6
answered Select MaxDate where hh:mm:ss makes the difference
Feb
28
comment How to select the first 10 records for each table in the same database using sql
@AaronBertrand if you like so..
Feb
27
answered How to select the first 10 records for each table in the same database using sql