297 reputation
219
bio website jeroenheijmans.nl
location Netherlands
age
visits member for 2 years, 10 months
seen Oct 7 at 11:17

Software developer, gamer, chef, and Stack Overflow fan from the Netherlands.


Sep
24
awarded  Autobiographer
Sep
24
awarded  Nice Question
Sep
18
accepted What is the logic behind ISNUMERIC for certain special characters?
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
Learn something new every day! :-)
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
You're trolling us, right? Right?! :O
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
Yes, I'm using SQL 2012, I've also approved the edit. Workarounds or even better alternatives are very welcome and appreciated, but I'm also/mostly curious about the why of things.
Sep
17
awarded  Custodian
Sep
17
reviewed Approve suggested edit on What is the logic behind ISNUMERIC for certain special characters?
Sep
17
asked What is the logic behind ISNUMERIC for certain special characters?
Jul
11
comment Use NOLOCK hint when calling table valued function
@AaronBertrand Fair point about the schemas, I've updated the question. Also thanks for the link to the SO thread (perhaps it would even serve as a good addition to MarkSinkinson's answer?).
Jul
11
revised Use NOLOCK hint when calling table valued function
Following suggestion from comment, adding schema prefixes
Jul
11
comment Use NOLOCK hint when calling table valued function
@AaronBertrand The WITH NOLOCK statement on the tvf would allow me to use exactly one code statement, so that would've been preferred (but isnt possible). Using NOLOCK hints on all tables inside the tvf is obviously not an (preferred) option, as I mention in my question. Setting the isolation level is indeed the other alternative, but requires me to set it back to whatever it was (using mentioned DBCC USEROPTIONS or so), resulting in multiple (rather involved) code statements. But I guess it's the best option left.
Jul
10
comment Use NOLOCK hint when calling table valued function
Thanks for confirming this. Shame it's not possible the way I'd prefer to have it.
Jul
10
accepted Use NOLOCK hint when calling table valued function
Jul
10
asked Use NOLOCK hint when calling table valued function
Jul
7
revised SQL Server shows database in recovery
Tried to improve readability and flow without changing too much of the question itself.
Jul
6
suggested suggested edit on SQL Server shows database in recovery
Jul
2
awarded  Curious
Jul
2
asked What are the “additional actions” available for “Recovery Pending” databases?
Feb
26
awarded  Yearling