Reputation
379
Next privilege 500 Rep.
Access review queues
Badges
3 24
Newest
 Caucus
Impact
~12k people reached

Jul
27
awarded  Caucus
Feb
11
awarded  Nice Question
Feb
9
awarded  Popular Question
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?).