Martin Smith

17,507 reputation

43579

bio	website
	location	United Kingdom
	age
visits	member for	1 year, 7 months
	seen	15 mins ago
stats	profile views	1,397

Email: stackoverflowmartinsmith@gmail.com

	17,507 reputation	bio	website		visits	member for	1 year, 7 months
43579 badges		location	United Kingdom		seen	15 mins ago

summary answers questions tags badges favorites bounties reputation activity

262 Revisions

suggestions reviews revisions comments badges posts accepts all

1d	revised	How to improve the performance for SQL Server Count(distinct()) and Sum() functions? added 208 characters in body
Apr 15	revised	In MySQL, does the order of the columns in a WHERE clause affect query performance,why? improve readability, fix code formatting, fix grammar and syntax
Apr 4	revised	What query can give me this result? edited tags
Apr 4	revised	What query can give me this result? added 40 characters in body
Mar 21	revised	Window functions cause awful execution plan when called from a view with external parametrized 'where' clause added 323 characters in body
Mar 17	revised	Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN added 488 characters in body
Mar 16	revised	What's the difference between a temp table and table variable in SQL Server? Lengthened Logging shortened Locking
Mar 8	revised	Window functions cause awful execution plan when called from a view with external parametrized 'where' clause added 68 characters in body
Mar 8	revised	Does this query make sense? deleted 27 characters in body
Mar 8	revised	Does this query make sense? added 1711 characters in body
Mar 2	revised	check constraint that has dynamic list added 609 characters in body
Feb 27	revised	Is there a better option than Union All for multiple selects from the same row? added 994 characters in body
Feb 27	revised	Does SQL Server read all of a COALESCE function even if the first argument is not NULL? added 538 characters in body
Feb 25	revised	Subquery in the VALUES clause added 214 characters in body
Feb 22	revised	Is it better to seperate a big query into multiple smaller queries? added 408 characters in body
Feb 20	revised	What exactly does “No Join Predicate” mean in SQL Server? Had one too many UNION ALL
Feb 20	revised	What exactly does “No Join Predicate” mean in SQL Server? added 177 characters in body
Feb 19	revised	Trigger in combination with transaction added 70 characters in body
Feb 17	revised	How does sampling work when updating statistics? added 199 characters in body
Feb 17	revised	How does sampling work when updating statistics? added 199 characters in body