Iain Elder

495 reputation

112

bio	website	basetable.wordpress.com
	location	Edinburgh, United Kingdom
	age	24
visits	member for	1 year, 9 months
	seen	May 16 at 13:43
stats	profile views	26

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.

	495 reputation	bio	website	basetable.wordpress.com	visits	member for	1 year, 9 months
112 badges		location	Edinburgh, United Kingdom		seen	May 16 at 13:43

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?

495 Reputation

+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?
+5	Type conversion in expression may affect “CardinalityEstimate” in query plan choice?

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 stored-procedures × 2
8 database-design × 3	0 powershell × 2
3 sql × 2	0 sql-server-2012
2 sql-server-2008 × 6	0 smo
2 performance	0 collation