Reputation
1,217
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
2 12 32
Impact
~92k people reached

  • 0 posts edited
  • 2 helpful flags
  • 81 votes cast
Jul
11
asked Safely moving and creating new tempdb files
Jul
6
awarded  Yearling
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
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