Reputation
225
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 6
Impact
~3k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Sep
24
awarded  Autobiographer
Jul
9
comment Handling time zones in data mart/warehouse
@Zane - converting the range request to UTC only works for simple queries where the range is identical for the entire query. If your query includes entities in different timezones (e.g. "Yesterday's sales for every store" where each store is in a different timezone and you define "yesterday" in context of the store, not the client) then converting before querying won't work.
Jun
20
awarded  Popular Question
Dec
22
awarded  Yearling
Dec
22
awarded  Nice Question
Jul
31
awarded  Supporter
Jul
31
comment How does SQL Server know predicates are correlated?
great answer, very thorough. thanks!
Jul
31
accepted How does SQL Server know predicates are correlated?
Oct
9
asked index maintenance strategy if few insertion points relative to # of rows
Jul
9
asked How does SQL Server know predicates are correlated?
Jul
9
awarded  Scholar
Jul
9
accepted logical reads vs. scan count
Jun
25
awarded  Student
Jun
25
asked logical reads vs. scan count