ErikE

less info

network profile

1,219 reputation

418

bio	website
	location	California
	age	41
visits	member for	1 year, 3 months
	seen	May 13 at 23:34
stats	profile views	106

email is "stackoverflow dit com atthedomain esquared dit mooo dit com", replace dit with . and atthedomain with @

summary answers questions tags badges favorites bounties reputation activity

25 Answers

votes activity newest

14	Why are queries parsed in such a way that disallows the use of column aliases in most clauses?
8	Is it possible in a view to reference a linked server implicitly rather than explicitly?
6	Should you design the database before the application code is written?
5	Table view created with triggers, someone please explain why?
5	Is it a good idea to use Synonyms to avoid creating a duplicate table?

view more

1,219 Reputation

+5	Are view references in a query properly called “derived tables” as such?
+5	Managing concurrency when using SELECT-UPDATE pattern
+10	Why are queries parsed in such a way that disallows the use of column aliases in most clauses?
+10	query optimization: time intervals

view more

7 Questions

votes activity newest

13	Managing concurrency when using SELECT-UPDATE pattern
8	Why is “Lookup” colored as a function reserved word in SQL Server?
7	FIFO queue table for multiple workers in SQL Server
5	Are view references in a query properly called “derived tables” as such?
5	Resources for understanding SQL Server locking and concurrency?

view more

43 Tags

47 sql-server × 16	7 sql × 5
24 database-design × 6	5 null × 2
14 alias	4 sql-server-2008-r2 × 2
9 sql-server-2008 × 8	4 mysql × 2
8 linked-server	4 performance × 2

view more

32 Accounts

	Stack Overflow	13,140 rep	33372
	English Language & Usage	1,355 rep	421
	Database Administrators	1,219 rep	418
	Meta Stack Overflow	994 rep	418
	Parenting	377 rep	17

20 Badges

recent class name

Popular Question × 3	Necromancer
Revival	Enthusiast
Yearling	Talkative
Notable Question	Nice Question
Nice Answer	Organizer

view more

0 Active bounties

active offered earned

This user has no active bounties

159 Votes Cast

all time			by type			month
156	up		55	question		1
3	down		104	answer		1

Technology			Life / Arts	Culture / Recreation	Science	Other
Stack Overflow Server Fault Super User Web Applications Ask Ubuntu Webmasters Game Development TeX - LaTeX	Programmers Unix & Linux Ask Different (Apple) WordPress Answers Geographic Information Systems Electrical Engineering Android Enthusiasts IT Security	Database Administrators Drupal Answers SharePoint User Experience Mathematica more (14)	Photography Science Fiction & Fantasy Seasoned Advice (cooking) Home Improvement more (13)	English Language & Usage Skeptics Mi Yodeya (Judaism) Travel Arqade (gaming) Bicycles Role-playing Games more (22)	Mathematics Cross Validated (stats) Theoretical Computer Science Physics more (7)	Stack Apps Meta Stack Overflow Area 51 Stack Overflow Careers

site design / logo © 2013 stack exchange inc; user contributions licensed under cc-wiki with attribution required

rev 2013.5.17.690

Database Administrators Stack Exchange works best with JavaScript enabled