28,260 reputation
771121
bio website
location United Kingdom
age
visits member for 3 years
seen 1 hour ago

Email: stackoverflowmartinsmith@gmail.com


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!
Jun
18
revised SQL query slow-down from 1 second to 11 minutes - why?
added 1 character in body
Jun
15
revised Table Data Space Used Confusion
edited tags
Jun
15
revised Rejoining range seek on nullable composite index?
added 589 characters in body
Jun
12
revised What's the difference between a temp table and table variable in SQL Server?
added 116 characters in body