Skip to main content
BanksySan's user avatar
BanksySan's user avatar
BanksySan's user avatar
BanksySan
  • Member for 10 years, 2 months
  • Last seen more than a month ago
44 votes
2 answers
66k views

What is a WITH CHECK CHECK CONSTRAINT?

9 votes
1 answer
5k views

Why does this execution plan have Compute Scalars?

7 votes
2 answers
397 views

Find the value OPTIMIZE FOR UNKNOWN is using

6 votes
3 answers
8k views

Get ID of row in aggregate

6 votes
1 answer
3k views

Is there an upper limit to the SqlDbType.Structured ADO.NET type?

4 votes
2 answers
4k views

Safe alternative to exec(sql)

4 votes
1 answer
5k views

Fast way to load a large amount of test data

2 votes
1 answer
305 views

Name for SELECT equivalent of UPSERT

1 vote
1 answer
60 views

Get rows without an 'end' event

1 vote
0 answers
44 views

Index added to view affecting other view

1 vote
0 answers
40 views

Find the failing component given an error message

1 vote
1 answer
95 views

Unexpected Indexing performance (Everything's equal)

0 votes
1 answer
980 views

Invalid column for SELECT with OVER

0 votes
1 answer
671 views

Increase the time to live of a cached plan [duplicate]

0 votes
1 answer
53 views

How is an Index Seek satisfying this query?