John's user avatar
John's user avatar
John's user avatar
John
  • Member for 10 years, 8 months
  • Last seen more than a month ago
12 votes
1 answer
2k views

Why does SQL Server not do compound column statistics histograms?

11 votes
4 answers
804 views

Sql Server fails to use index on simple bijection

8 votes
2 answers
970 views

Index seek to specific multi-column key, then get some rows in lexicographical order

7 votes
4 answers
431 views

Relationships between like matching and comparison

5 votes
2 answers
959 views

At finding a substring, find the end position as well

4 votes
1 answer
602 views

Why does my execution plan (sometimes) include a left join?

3 votes
1 answer
444 views

The finer points of writers locking each other out under the snapshot isolation levels

2 votes
1 answer
118 views

What's the rationale for ALTER TABLE permission being required for SET IDENTITY_INSERT ON?

2 votes
1 answer
1k views

Incremental sync for Sql Server

1 vote
1 answer
350 views

Why does Sql Server makes this bad query plan choice?

1 vote
1 answer
772 views

Group by's in materialized views and query planning [duplicate]

0 votes
1 answer
174 views

On the query planners's reasons for choosing merge joins vs nested loops

0 votes
1 answer
95 views

Business Intelligence for developers

0 votes
1 answer
169 views

Foreign keys without any checking or index

0 votes
2 answers
103 views

Holding transactions as long as a user edits

-2 votes
2 answers
789 views

Database engine with counting b-trees for efficient paging support [closed]