235 reputation
216
bio website jeroenheijmans.nl
location Netherlands
age
visits member for 2 years, 8 months
seen Jul 22 at 19:41

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


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
Feb
26
comment Re-run a specific actual query plan
No problem, thx for your help in any case: learned something new today! :D
Feb
26
accepted Re-run a specific actual query plan
Feb
26
comment Re-run a specific actual query plan
Thanks, exactly what I was asking for. (Unfortunately it leaves me with a new problem: "A query plan could not be found because optimizer exceeded number of allowed operations while searching for plan specified in USE PLAN hint.", but that's another issue to deal with I guess.)
Feb
26
asked Re-run a specific actual query plan
May
20
awarded  Caucus
May
20
awarded  Constituent
Feb
13
comment SSRS report viewer - log on failed (rsLogonFailed)
Hey @nuander, good to hear you solved your problem! It would be great if you could write up an answer, so others with the same problem can spot/find it easily.
Feb
9
awarded  Popular Question
Jan
28
awarded  Custodian