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

Email: stackoverflowmartinsmith@gmail.com


Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
@Jeroen - It's on Wikipedia FWIW
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
Ah that's an interesting theory. It is money that it casts to as well.
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
The only ones that seem incorrect to me are that it falsely reports 0 for five of the values that actually cast fine to money. The others seem accurate. SQL FIDDLE
Sep
16
comment Converting a Unicode value to a non-Unicode value (SQL Server)
SQL Server uses what this paper calls homoglyphic transformation and often converts characters that can't be represented to near equivalents. Such as losing the accent on a character or changing smart quotes to plain quotes. I agree that doesn't look very close though! I'm not sure if or where these transformations are documented.
Sep
15
awarded  Enlightened
Sep
13
comment Inserting to table: Insert rows with Left Outer Join or Insert rows then Update?
If you tag "performance" and "optimisation" you should generally tag the RDBMS you are using too.
Sep
10
comment Explain plan shows a table not in the query
And my guess is that it is CAUFV that is the view referring to AUFK as I don't see that in the explain. Maybe the V is a clue.
Sep
9
awarded  Good Answer
Sep
9
awarded  Enlightened
Sep
9
awarded  Nice Answer
Sep
9
reviewed Approve suggested edit on Sql Server - Select while insert on another transaction gives unexpected results
Sep
9
awarded  Nice Answer
Sep
8
comment A lot of data in the table is only accessed for 4 days or so, how to handle it afterwards?
What RDBMS are you using?
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
8
comment Sql Server - Select while insert on another transaction gives unexpected results
@Shanky Fair enough. Would be surprised if sys.fn_PhysLocCracker(%%physloc%%) and %%LOCKRES%% cause any issues but trace flag 1200 may well do.
Sep
8
comment INSERT takes over 5 hours, when inserting more than specific number of rows
What is the source for the insert?
Sep
7
awarded  sql-server
Sep
6
revised Sql Server - Select while insert on another transaction gives unexpected results
added 1039 characters in body
Sep
6
answered Sql Server - Select while insert on another transaction gives unexpected results