Reputation
1,172
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
2 10 29
Impact
~78k people reached

  • 0 posts edited
  • 2 helpful flags
  • 81 votes cast
May
28
comment Does SQL Server evaluate functions once for every row?
Thanks for the link and explanations :)
May
28
accepted Does SQL Server evaluate functions once for every row?
May
28
asked Does SQL Server evaluate functions once for every row?
May
23
accepted Is it recommended to clear the query plan cache
May
23
comment Is it recommended to clear the query plan cache
Thanks for the discussion guys. It's been most helpful :)
May
22
comment Is it recommended to clear the query plan cache
Probably no more than 15% for this one query. Don't have access to the server at the moment to check
May
22
comment Is it recommended to clear the query plan cache
Not sure if you saw the edit I put on as you were writing but most of the top queries are like SELECT blah FROM t WHERE param = 1 then param = 2 and so on... Does that affect your answer? Sorry if it does, you were too quick :P
May
22
asked Is it recommended to clear the query plan cache
Apr
5
accepted CROSS APPLY-ing a parameterised function
Apr
4
asked CROSS APPLY-ing a parameterised function
Mar
28
awarded  Nice Question
Feb
15
comment Output into temporary table
Thanks. Fancy putting that in an answer :)
Feb
13
asked Output into temporary table
Jan
16
awarded  Nice Question
Dec
28
accepted Table value functions vs UDF SQL Server
Dec
28
comment Table value functions vs UDF SQL Server
Didn't see the duplicate :/ my bad
Dec
28
asked Table value functions vs UDF SQL Server
Nov
29
accepted Over use/correct use of schemas?
Nov
29
comment Over use/correct use of schemas?
I usually sort out permissions at the end of development as we have somewhat "fluid" specifications at times. Is this how you do it? Or do you assign permissions as you create the objects etc
Nov
29
comment How large is “too large” for SQL 2008 Web Edition?
Thanks for the links about the future licensing