Profile Activity

Kenneth Fisher

Network profile

Reputation

22,072

22.1k
16k
9.9k

2016
2017
2018
2019

Next tag badge

81/100 score

23/20 answers

Badges

7

45

96

Newest

Enlightened

Next badge

0/1

Impact

26 posts edited

4 helpful flags

2,782 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

Answers (433)

Votes Activity Newest

53	How can I see the current Database Mail configuration?
47	Script to see running jobs in SQL Server with Job Start Time
27	Why would a table use its primary key as a foreign key to itself
22	Is ELSE 0 implied in my COUNT CASE WHEN statement?
21	Hyphen in my computer's name causing T-SQL error

View more →

Reputation (22,072)

+10	Script to see running jobs in SQL Server with Job Start Time
+10	script to show all the permissions for a table
+10	LEFT vs CHARINDEX for matching the start of a string in T-SQL
-2	SQL Server 2008 R2 Restore Database From File - “failed: 38(failed to retrieve text for this error. Reason: 15105)”

View more →

Questions (42)

Votes Activity Newest

39	Why does adding a TOP 1 dramatically worsen performance?
25	Can you use COUNT DISTINCT with an OVER clause?
23	What's the best way to archive all but current year and partition the table at the same time
23	When is a Dynamic Port “dynamic”?
13	How accurate is the sys.partition.rows column?

View more →

Tags (223)

1k sql-server × 351	81 permissions × 27
231 t-sql × 48	73 database-design × 23
224 sql-server-2008-r2 × 88	69 primary-key × 7
164 sql-server-2012 × 57	68 sql-server-2014 × 19
155 sql-server-2008 × 51	61 sql-server-2005 × 23

View more →

Accounts (5)

	Database Administrators	22,072 rep	7 gold badges45 silver badges96 bronze badges
	Stack Overflow	3,257 rep	15 silver badges20 bronze badges
	Server Fault	101 rep	1 bronze badge
	Meta Stack Exchange	101 rep	2 bronze badges
	Android Enthusiasts	101 rep	1 bronze badge

Badges (44)

Recent Class Name

Enlightened × 10	Popular Question × 26
Nice Answer × 29	Good Question × 2
Cleanup	Yearling × 6
Nice Question × 7	Good Answer × 3
Notable Question × 14	Famous Question × 4

View more →

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast (2,782)

all time			by type
2,780	up		1,367	question
2	down		1,415	answer

Database Administrators Stack Exchange works best with JavaScript enabled