344 reputation
321
bio website jeroenheijmans.nl
location Netherlands
age
visits member for 3 years, 1 month
seen Jan 9 at 13:25

Software developer, gamer, chef, and Stack Overflow fan from the Netherlands. TW: @jeroenheijmans


Jan
5
suggested rejected edit on How do I list all columns for a specified table
Dec
30
awarded  Notable Question
Dec
30
accepted How to measure or find cost of creating a query plan?
Dec
30
comment How to measure or find cost of creating a query plan?
Thanks for taking (quite some) time to answer! I'm a bit skeptical though about the first bit about how to get the compile time, given that it is a factor 3 lower than the result I get by using @PaulWhite's approach. - The second on Dynamic SQL bit is interesting (though it would also require time to implement; at least more than just slapping an OPTION on my query), and wouldn't hurt me too much since this sproc is well harnessed in integration tests. - In any case: thanks for your insights!
Dec
29
asked How to measure or find cost of creating a query plan?
Nov
17
awarded  Popular Question
Oct
28
awarded  Popular Question
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 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.