Network profile

Jon of All Trades

Reputation

5,537

5.5k
4.2k
2.9k

2017
2018
2019
2020

Top tag

sql-server

Next privilege

10,000 Rep.

Access moderator tools

Badges

4

34

62

Newest

Caucus

Next badge

543/600

Impact

33 posts edited

23 helpful flags

1,377 votes cast

Answers (115)

Votes Activity Newest

60	Can I write portable SQL statements?
17	How do I grant the privilege of connecting to SSIS?
11	Composite Primary Key efficiency as a Foreign Key
9	What are valid usage scenarios for HEAP tables?
7	Are two indexes needed?

View more →

Reputation (5,537)

+10	How long is the output of EncryptByPassPhrase(), relative to the input?
+20	How do I grant the privilege of connecting to SSIS?
+10	How do I grant the privilege of connecting to SSIS?
+10	Design star schema for many-many relationship

View more →

Questions (35)

Votes Activity Newest

24	What steps are necessary to safely restart a machine hosting Microsoft SQL Server?
23	Is data retrieved from SQL Server compressed for transmission?
18	Why does this query become drastically slower when wrapped in a TVF?
18	Why might a table's data space take up 4x the size of the raw data?
14	What's a good tool for visualizing SQL Agent jobs? [closed]

View more →

Tags (139)

91 sql-server × 61	29 performance × 13
60 migration	26 sql-server-2008 × 22
56 database-design × 30	22 primary-key × 6
40 mysql × 27	21 ssis × 5
29 data-warehouse × 18	20 clustered-index × 6

View more →

Bookmarks (21)

Votes Activity Newest Views Added

76	What are the arguments against or for putting application logic in the database layer?
26	Subqueries' aliases same as main queries' aliases
17	Is there any tangible difference between a unique clustered index and a clustered primary key?
14	Behavior of data in indexes based on fill factor
14	Mysql int vs varchar as primary key (InnoDB Storage Engine?

View more →

Accounts (44)

	Database Administrators	5,537 rep	4 gold badges34 silver badges62 bronze badges
	User Experience	264 rep	2 silver badges9 bronze badges
	Politics	155 rep	1 silver badge8 bronze badges
	Seasoned Advice	133 rep	4 bronze badges
	Space Exploration	133 rep	6 bronze badges

Badges (37)

Recent Class Name

Caucus	Notable Question × 15
Yearling × 9	Reviewer
Popular Question × 24	Census × 2
Necromancer × 2	Guru
Custodian × 5	Good Answer

View more →

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast (1,377)

all time			by type
1,320	up		543	question
57	down		834	answer

Database Administrators Stack Exchange works best with JavaScript enabled