29,301 reputation
772123
bio website
location United Kingdom
age
visits member for 3 years, 2 months
seen 1 hour ago

Email: stackoverflowmartinsmith@gmail.com


Dec
14
answered How to join a table with a table valued function?
Dec
14
answered Is it possible to define a function within a stored procedure?
Dec
12
answered Identical tables, identical columns, identical records, but why different record sizes?
Dec
11
answered Is there a SELECT statement to subtract rows of the same column?
Dec
8
answered Query to convert the count to million or thousands
Dec
7
answered Reset Key Names to Defaults?
Nov
5
answered about latest row in sql server
Nov
3
answered Filter table before join
Oct
26
answered Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
Oct
18
answered Strange query results for DELETE with ROW_NUMBER
Oct
3
answered In SQL Server what is the database cost for setting a default value on table that already has over 1mil records?
Sep
28
answered Slow running aggregate of aggregate query
Sep
6
answered Sql Server - Select while insert on another transaction gives unexpected results
Jul
25
answered Get complete value of varchar(max) field - SQL Server 2005
Jul
23
answered Why is my select statement so slow?
Jun
29
answered How to update ID=null values in table to incremental counter values?
Jun
22
answered SQL Server: Are there any performance benefits from indexing a table <8kb in size?
Jun
14
asked Rejoining range seek on nullable composite index?
Jun
12
answered NULL value returned when concatenating a string in SQL while loop!
Feb
26
answered Re-run a specific actual query plan