Jon of All Trades

less info

network profile

803 reputation

216

bio	website
	location	Austin, TX
	age	31
visits	member for	2 years, 1 month
	seen	yesterday
stats	profile views	51

summary answers questions tags badges favorites bounties reputation activity

23 Answers

votes activity newest

4	do user_scans and no user_seeks mean the index is useless?
3	Are two indexes needed?
3	Indexing of Data Warehouse tables?
2	Complex query with multiple normalized fields
2	TSQL performance - JOIN on value BETWEEN min and max

view more

803 Reputation

+10	Can a surrogate key and a primary key be in the same table?
+5	Why might a table's data space take up 4x the size of the raw data?
+10	How can I copy a user while preserving all privs?
+10	MySQL: Join one Row in a table with two Rows in other table

view more

14 Questions

votes activity newest

10	Why might a table's data space take up 4x the size of the raw data?
9	Is data retrieved from SQL Server compressed for transmission?
8	Query becomes drastically slower when wrapped in a TVF
7	What are the performance considerations between using a broad PK vs a separate synthetic key and UQ?
7	What are best practices for safely permanently deleting a database?

view more

45 Tags

10 sql-server-2008 × 18	6 index × 3
9 sql-server × 12	5 data-warehouse × 3
9 mysql × 6	4 t-sql × 3
7 database-design × 6	3 normalization × 2
6 sql × 6	3 join × 2

view more

29 Accounts

	Stack Overflow	1,285 rep	417
	Database Administrators	803 rep	216
	Role-playing Games	508 rep	29
	English Language & Usage	238 rep	17
	Arqade	195 rep	4

14 Badges

recent class name

Popular Question × 4	Excavator
Yearling × 2	Promoter
Nice Question	Critic
Tumbleweed	Teacher
Citizen Patrol	Commentator

view more

0 Active bounties

active offered earned

This user has no active bounties

250 Votes Cast

all time			by type			month
249	up		82	question		1
1	down		168	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 Christianity Arqade (gaming) Bicycles Role-playing Games more (21)	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.6.19.752

Database Administrators Stack Exchange works best with JavaScript enabled