gbn

less info

network profile

34,927 reputation

22875

bio	website
	location	Malta/Switzerland
	age	42
visits	member for	1 year, 4 months
	seen	26 mins ago
stats	profile views	1,340

aka Shawn

SQL Server Developer/DBA
MySQL Developer
British expat
Code monkey

summary answers questions tags badges favorites bounties reputation activity

704 Answers

votes activity newest

35	What is the difference between select count(*) and select count(any_non_null_column)?
22	Poor SQL Server performance when management studio closed
22	How to execute SQL against all DBs on a Server
20	Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?
20	Does a DBA need to know how to program in a system language besides SQL?

view more

34,927 Reputation

+10	Allow db_owner to add/view existing logins to database
+10	Should I use table hints with a process-keyed table?
+10	Can I restore a database to a point of time without backup?
+15	where clause short circuit? (sybase)

view more

5 Questions

votes activity newest

8	Possible to make MySQL use more then one core
7	SQL Server: filegroup for system tables only?
3	MySQL aggregate anomaly
2	Equivalent functions in MySQL that exist in SQL Server
1	View metadata refresh in MySQL

210 Tags

2k sql-server × 341	236 performance × 57
768 sql-server-2008 × 202	207 mysql × 65
526 sql × 110	164 sql-server-2008-r2 × 40
458 sql-server-2005 × 105	139 index × 31
349 database-design × 64	102 backup × 20

view more

10 Accounts

	Stack Overflow	127,762 rep	1078153
	Database Administrators	34,927 rep	22875
	Server Fault	4,907 rep	1413
	Programmers	2,171 rep	1512
	Meta Stack Overflow	1,258 rep	515

105 Badges

recent class name

Enlightened × 15	Tag Editor
Nice Answer × 46	Popular Question
Strunk & White	Outspoken
Excavator	Necromancer × 2
backup	Announcer

view more

0 Active bounties

active offered earned

This user has no active bounties

884 Votes Cast

all time			by type			month
839	up		273	question		19
45	down		611	answer		19

view more

Database Administrators - Stack Exchange works best with JavaScript enabled