Andrew Bickerton

1,200 reputation

720

bio	website	twitter.com/coder4hire
	location	Manchester, United Kingdom
	age	36
visits	member for	2 years, 4 months
	seen	2 days ago
stats	profile views	67

Software developer and co-founder of Australian software company Redgum Technologies, been developing since late 80's in a variety of languages, C, C++, VB, .NET, etc... as well as a few niche ones...

Last few years Have been spending the majority of my time in SQL Server databases...

	1,200 reputation	bio	website	twitter.com/coder4hire	visits	member for	2 years, 4 months
720 badges		location	Manchester, United Kingdom		seen	2 days ago

summary answers questions tags badges favorites bounties reputation activity

28 Answers

votes activity newest

7	what is the first schema checked?
6	SQL Server 2008 posibilities of having views from one database in another database?
5	Listing Non-Record
5	Why SQL Server replication related jobs do not show up under the jobs folder in SSMS?
4	Writing a simple bank schema: How should I keep my balances in sync with their transaction history?

1,200 Reputation

+10	Is the ADO.NET Entity Framework known for generating poorly performing queries?
+20	Difference between Hash, Merge and Loop join?
+5	How to execute SQL against all DBs on a Server
+10	Writing a simple bank schema: How should I keep my balances in sync with their transaction history?

9 Questions

votes activity newest

17	How to execute SQL against all DBs on a Server
9	Difference between Hash, Merge and Loop join?
9	How to get the MAX row
4	sp_repladdcolumn - is it possible to supply a list of Publications to add this column on?
4	Which is quicker: Select of existing row vs Update where no row exists?

35 Tags

35 sql-server × 24	4 stored-procedures × 3
30 sql-server-2008 × 9	4 ssms × 2
14 sql × 8	4 aggregate
11 sql-server-2005 × 6	4 indexed-view
7 replication × 6	4 database-design