Iain Elder

500 reputation

113

bio	website	basetable.wordpress.com
	location	Edinburgh, United Kingdom
	age	24
visits	member for	1 year, 10 months
	seen	Jun 14 at 16:05
stats	profile views	27

Education is learning what you didn't even know you didn't know. - Daniel J Boorstin

On my day job I maintain a large database application for a growing Edinburgh-based travel search company. Every day I learn more about development and administration in the trenches, including how to cope with legacy worst practices and how to benefit from SQL Server best practices.

Studying part-time at Dundee University for an MSc in Business Intelligence.

	500 reputation	bio	website	basetable.wordpress.com	visits	member for	1 year, 10 months
113 badges		location	Edinburgh, United Kingdom		seen	Jun 14 at 16:05

summary answers questions tags badges favorites bounties reputation activity

13 Questions

votes activity newest

8	Why are non-digits LIKE [0-9]?
5	Why am I missing some output?
5	Why does the order of parameters matter for sp_trace_create?
4	How to decode a query on a composite unary-encoded attribute?
4	Type conversion in expression may affect “CardinalityEstimate” in query plan choice?

500 Reputation

+5	How do I fix SQL Server assembly optimization errors and memory exhaustion?
+5	Why does OBJECTPROPERTY return NULL?
+20	How to decode a query on a composite unary-encoded attribute?
+5	Why does the order of parameters matter for sp_trace_create?

4 Answers

votes activity newest

5	help in multi-language medical database?
2	How to run 2 separate sql server engines on the same server?
2	Help with a multi-language medical database
1	Trouble in Multi-Language DB

18 Tags

10 sql-server × 11	0 powershell × 2
8 database-design × 3	0 stored-procedures × 2
3 sql × 2	0 t-sql
2 sql-server-2008 × 6	0 upgrade
2 performance	0 sql-server-2008-r2