ErikE
  • Member for 9 years, 11 months
  • Last seen this week
  • Seattle, Washington, United States
4 answers
83 votes
14k views
9 bookmarks
Authoritative source that <> and != are identical in performance in SQL Server
3 answers
26 votes
15k views
8 bookmarks
Managing concurrency when using SELECT-UPDATE pattern
1 answers
23 votes
4k views
1 bookmarks
Is it safe to rely on the order of an INSERT's OUTPUT clause?
4 answers
20 votes
111k views
11 bookmarks
Easily show rows that are different between two tables or queries
2 answers
18 votes
20k views
8 bookmarks
FIFO queue table for multiple workers in SQL Server
1 answers
14 votes
2k views
2 bookmarks
Why is "Lookup" colored as a function reserved word in SQL Server?
4 answers
9 votes
755 views
2 bookmarks
Resources for understanding SQL Server locking and concurrency?
1 answers
5 votes
253 views
1 bookmarks
Writing and reading date ranges for a million items
1 answers
5 votes
294 views
1 bookmarks
Are view references in a query properly called "derived tables" as such?
2 answers
4 votes
3k views
sp_executesql adds statements to executed dynamic script?
2 answers
3 votes
202 views
Use Netbackup 7.7 `WITH KEEP_CDC`
0 answers
3 votes
179 views
Naming the parts of a supertype/subtype pattern
0 answers
2 votes
113 views
Syntax for restoring SQL Server backup from non-disk source