Network profile

HLGEM

Reputation

3,093

3.1k
2.9k
2.8k

2017
2018
2019
2020

Top tag

database-design

Next privilege

5,000 Rep.

Approve tag wiki edits

Badges

14

18

Newest

Yearling

Next badge

0/1

Impact

3 posts edited

6 helpful flags

278 votes cast

Answers (93)

Votes Activity Newest

20	Why are constraints applied in the database rather than the code?
14	Common Table Expression (CTE) benefits?
11	Is a surrogate key better than a natural key in this case
10	EF Code First uses nvarchar(max) for all strings. Will this hurt query performance?
9	How could DBAs be more 'programmer friendly'?

View more →

Reputation (3,093)

+10	Is this a good strategy for importing a large amount of data and decomposing as an ETL?
+10	EF Code First uses nvarchar(max) for all strings. Will this hurt query performance?
+30	Why are constraints applied in the database rather than the code?
+10	Is it worth to separate columns into multiple tables for one-to-one relational table

View more →

Question (1)

Votes Activity Newest

1	Memory continually being eaten up since I had SQL Server 2014 SSMS installed

Tags (83)

125 database-design × 29	28 sql-server-2005 × 10
112 sql-server × 42	25 best-practices × 3
49 performance × 13	21 query-performance × 6
45 sql-server-2008 × 15	19 sql-server-2008-r2 × 7
39 mysql × 16	16 primary-key × 3

View more →

Bookmarks (3)

Votes Activity Newest Views Added

462	What's the difference between a temp table and table variable in SQL Server?
76	What are the arguments against or for putting application logic in the database layer?
5	Solutions for reporting off of an EAV structured database?

Accounts (7)

	The Workplace	138,874 rep	26 gold badges245 silver badges506 bronze badges
	Stack Overflow	87,200 rep	11 gold badges104 silver badges166 bronze badges
	Software Engineering	28,301 rep	4 gold badges65 silver badges114 bronze badges
	Database Administrators	3,093 rep	14 silver badges18 bronze badges
	Meta Stack Exchange	279 rep	1 silver badge6 bronze badges

Badges (19)

Recent Class Name

Yearling × 9	Student
Nice Answer × 4	sql-server
Necromancer × 3	database-design
Autobiographer	Enlightened
Scholar	Organizer

View more →

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast (278)

all time			by type
257	up		15	question
21	down		263	answer

Database Administrators Stack Exchange works best with JavaScript enabled