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


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