User ErikE - Database Administrators Stack Exchange

ErikE

Member for 11 years, 10 months
Last seen this week

Seattle, Washington, United States

13 Questions

Score Activity Newest Views

96 votes

4 answers

20k views

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

asked Nov 17, 2016 at 22:39

27 votes

3 answers

16k views

Managing concurrency when using SELECT-UPDATE pattern

asked Feb 12, 2012 at 1:06

26 votes

1 answer

5k views

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

asked Nov 18, 2016 at 20:03

20 votes

4 answers

117k views

Easily show rows that are different between two tables or queries

asked Feb 9, 2012 at 19:51

19 votes

2 answers

22k views

FIFO queue table for multiple workers in SQL Server

asked Jul 4, 2012 at 22:09

14 votes

1 answer

2k views

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

asked Aug 17, 2012 at 0:32

9 votes

4 answers

765 views

Resources for understanding SQL Server locking and concurrency?

asked Feb 13, 2012 at 18:43

5 votes

1 answer

330 views

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

asked Feb 12, 2013 at 19:10

5 votes

1 answer

346 views

Writing and reading date ranges for a million items

asked Nov 28, 2016 at 20:59

4 votes

2 answers

3k views

sp_executesql adds statements to executed dynamic script?

asked May 28, 2013 at 18:03

3 votes

0 answers

199 views

Naming the parts of a supertype/subtype pattern

asked Aug 1, 2012 at 23:47

3 votes

2 answers

243 views

Use Netbackup 7.7 `WITH KEEP_CDC`

asked Nov 29, 2016 at 6:24

2 votes

0 answers

114 views

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

asked Oct 11, 2013 at 0:06