28,769 reputation
771121
bio website
location United Kingdom
age
visits member for 3 years, 1 month
seen 7 hours ago

Email: stackoverflowmartinsmith@gmail.com


Nov
4
revised Filter table before join
added 7 characters in body
Nov
4
revised Filter table before join
added 113 characters in body
Nov
3
revised Filter table before join
added 269 characters in body
Oct
27
revised Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
added 419 characters in body
Oct
19
revised Strange query results for DELETE with ROW_NUMBER
added 343 characters in body
Oct
19
revised Strange query results for DELETE with ROW_NUMBER
added 779 characters in body
Oct
18
revised Strange query results for DELETE with ROW_NUMBER
added 202 characters in body
Oct
17
revised Performance first low, then high after adding index, then keep high after drop index
edited tags
Oct
15
revised Trying to return empty rows even if data does not exsist in SQL
added 24 characters in body
Sep
28
revised Slow running aggregate of aggregate query
added 19 characters in body
Sep
28
revised Slow running aggregate of aggregate query
Added info from comments to question
Sep
23
revised Inserting variables into another variable
added 147 characters in body
Sep
20
revised How to resolve stored procedure output parameter error?
added 96 characters in body
Sep
8
revised Iterate through all non-system databases and empty them
Took a guess at what follows "em"
Sep
8
revised Sql Server - Select while insert on another transaction gives unexpected results
added 289 characters in body
Sep
6
revised Sql Server - Select while insert on another transaction gives unexpected results
added 1039 characters in body
Jul
21
revised Finding last time table was updated?
added 105 characters in body
Jun
29
revised How to update ID=null values in table to incremental counter values?
WHERE ID IS NULL shouldn't apply to MAX(ID)
Jun
22
revised SQL Server: Are there any performance benefits from indexing a table <8kb in size?
added 41 characters in body
Jun
19
revised What's the difference between a temp table and table variable in SQL Server?
Hopefully explained better and updated Mr White's moniker!