Justin Grant's user avatar
Justin Grant's user avatar
Justin Grant's user avatar
Justin Grant
  • Member for 11 years, 8 months
  • Last seen more than a week ago
17 votes
1 answer
1k views

Query strategies using SQL Server 2016 system-versioned temporal tables for Slowly-Changing Dimensions

15 votes
1 answer
2k views

How does SQL Server know predicates are correlated?

9 votes
3 answers
7k views

logical reads vs. scan count

9 votes
1 answer
840 views

Hash join between master/detail tables produces too-low cardinality estimate

6 votes
2 answers
351 views

What are thresholds in SQL Server 2014 "big table join to small table" cardinality estimation optimization?

4 votes
2 answers
156 views

index maintenance strategy if few insertion points relative to # of rows

3 votes
2 answers
1k views

concatenating columns from multiple unrelated 1-row resultsets

2 votes
2 answers
478 views

Dimensional Model for inheritance in dimensions

1 vote
1 answer
504 views

storing as smallint, querying as int

1 vote
1 answer
628 views

What does "volume" mean in MAX_IOPS_PER_VOLUME?

1 vote
1 answer
356 views

Is SQL Server's fill strategy the same for multi-file tempdb as multi-file (non-tempdb) filegroups?

0 votes
1 answer
342 views

Workload group "Importance" vs. Resource pool IOPS throttling

0 votes
0 answers
439 views

Add foreign key constraint for denormalized columns in detail tables?