ErikE

Member for 11 years, 10 months
Last seen this week

Seattle, Washington, United States

Summary

Reputation

4,305

4.3k
4k
3.7k

2020
2021
2022
2023

Top tag

sql-server

Next privilege

5,000 Rep.

Approve tag wiki edits

Badges

4

27

39

Newest

Yearling

Next badge

0/1

Custodian

Answers

View all 37 answers

Score Activity Newest

37

Is adding the ‘tbl’ prefix to table names really a problem?

Nov 10, 2016

19

Why are queries parsed in such a way that disallows the use of column aliases in most clauses?

Aug 3, 2012

14

Should you design the database before the application code is written?

Mar 16, 2012

8

Does SQL Server read all of a COALESCE function even if the first argument is not NULL?

Feb 9, 2012

8

Is it possible in a view to reference a linked server implicitly rather than explicitly?

Mar 6, 2012

Questions

View all 13 questions

Score Activity Newest Views

96

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

Nov 17, 2016

27

Managing concurrency when using SELECT-UPDATE pattern

Feb 12, 2012

26

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

Nov 18, 2016

20

Easily show rows that are different between two tables or queries

Feb 9, 2012

19

FIFO queue table for multiple workers in SQL Server

Jul 4, 2012

Tags

View all 66 tags

sql-server

127

Score

33

posts

best-practices

41

Score

2

posts

naming-convention

37

Score

2

posts

table

37

Score

1

post

database-design

36

Score

6

posts

Reputation

+60

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

+10

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

+10

FIFO queue table for multiple workers in SQL Server

+10

Managing concurrency when using SELECT-UPDATE pattern

Badges

View all badges

4

gold badges

Famous Question

× 4

Sep 30, 2019

27

silver badges

Outspoken

Mar 30, 2017
Taxonomist

May 3, 2015
Enthusiast

Apr 3, 2012

39

bronze badges

Mortarboard

Nov 18, 2016
sql-server

Dec 1, 2018
Tag Editor

Nov 29, 2016

Accounts

View all 89 accounts

49.2k
23
151
196

English Language & Usage

4,421
2
25
37

Database Administrators

4,305
4
27
39

2,908
3
15
15

Meta Stack Exchange

2,414
14
23

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast

196

upvotes

6

downvotes

67

question votes

135

answer votes