user avatar
user avatar
user avatar
ErikE
  • Member for 10 years, 5 months
  • Last seen more than a month ago
  • Seattle, Washington, United States
20 votes
4 answers
112k views

Easily show rows that are different between two tables or queries

18 votes
2 answers
21k views

FIFO queue table for multiple workers in SQL Server

89 votes
4 answers
17k views

Authoritative source that <> and != are identical in performance in SQL Server

26 votes
3 answers
15k views

Managing concurrency when using SELECT-UPDATE pattern

24 votes
1 answer
4k views

Is it safe to rely on the order of an INSERT's OUTPUT clause?

4 votes
2 answers
3k views

sp_executesql adds statements to executed dynamic script?

14 votes
1 answer
2k views

Why is "Lookup" colored as a function reserved word in SQL Server?

9 votes
4 answers
757 views

Resources for understanding SQL Server locking and concurrency?

5 votes
1 answer
298 views

Are view references in a query properly called "derived tables" as such?

5 votes
1 answer
272 views

Writing and reading date ranges for a million items

3 votes
2 answers
209 views

Use Netbackup 7.7 `WITH KEEP_CDC`

3 votes
0 answers
181 views

Naming the parts of a supertype/subtype pattern

2 votes
0 answers
113 views

Syntax for restoring SQL Server backup from non-disk source [duplicate]