Matthew's user avatar
Matthew's user avatar
Matthew's user avatar
Matthew
  • Member for 12 years, 4 months
  • Last seen more than a month ago
  • Irvine, CA
49 votes
5 answers
58k views

Can I add a unique constraint that ignores existing violations?

44 votes
3 answers
4k views

Is the concept of a clustered index in a DB design sensical when using SSDs?

12 votes
2 answers
6k views

Is a MERGE with OUTPUT better practice than a conditional INSERT and SELECT?

9 votes
2 answers
930 views

Should I nest dependent outer joins in SQL Server?

8 votes
1 answer
6k views

How to migrate between schemas in bulk in SQL Server?

8 votes
1 answer
2k views

Are SQL Server's Date values stored as a single int?

6 votes
1 answer
5k views

Can I alter a view being referenced with schemabinding if the change fulfills the binding requirement?

4 votes
1 answer
844 views

Is SYSUTCDATETIME a safe primary key?

4 votes
2 answers
489 views

Can a single SQL Server instance issue the same SYSDATETIME twice?

3 votes
2 answers
2k views

Creating a partition on my soft-delete indicator column

3 votes
2 answers
40k views

Should I join datetime to a date using cast or range?

2 votes
1 answer
178 views

What is the appropriate SQL method for "Safe to SUM"?

2 votes
1 answer
2k views

How should I limit a table to N rows, discarding oldest?

1 vote
1 answer
634 views

Should I use a surrogate key in a mapping table?

1 vote
2 answers
1k views

Merits of inserting to temp table and renaming versus just adding/removing columns

1 vote
2 answers
493 views

How should I delete branch from adjacency list in SQL Server?

1 vote
0 answers
1k views

Can I make a sequence skip certain values?

1 vote
1 answer
750 views

Can I force MSDTC to control only within a single database?