ErikE's user avatar
ErikE's user avatar
ErikE's user avatar
ErikE
  • Member for 12 years, 1 month
  • Last seen more than a month ago
  • Seattle, Washington, United States
96 votes
4 answers
20k views

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

27 votes
3 answers
16k views

Managing concurrency when using SELECT-UPDATE pattern

26 votes
1 answer
5k views

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

20 votes
4 answers
117k views

Easily show rows that are different between two tables or queries

19 votes
2 answers
22k views

FIFO queue table for multiple workers in SQL Server

14 votes
1 answer
2k views

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

9 votes
4 answers
768 views

Resources for understanding SQL Server locking and concurrency?

5 votes
1 answer
335 views

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

5 votes
1 answer
354 views

Writing and reading date ranges for a million items

4 votes
2 answers
3k views

sp_executesql adds statements to executed dynamic script?

3 votes
0 answers
201 views

Naming the parts of a supertype/subtype pattern

3 votes
2 answers
248 views

Use Netbackup 7.7 `WITH KEEP_CDC`

2 votes
0 answers
114 views

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