Reputation
1,462
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
2 14 35
Impact
~124k people reached

  • 0 posts edited
  • 2 helpful flags
  • 81 votes cast
Dec
16
comment Difficulty in finding Candidate Keys
re-tagged as homework
Dec
8
comment case versus isnull versus coalesce
Thanks for the complete answer so quickly. I had no idea that the order of precedence mattered for COALESCE. Thanks again
Dec
8
comment case versus isnull versus coalesce
related I agree. but not dup. Thanks for the comment :)
Jul
15
comment Tempdb autogrowth settings
Got that down on my to-do list. Sys-admins are going to love me on Tuesday when im back in the office :D Thanks for the link.
Jul
15
comment Tempdb autogrowth settings
Yes it does, thanks for the insight. :)
Jul
15
comment Tempdb autogrowth settings
Typically in the environments I work in, SQL Server is generally placed on a multi-purpose server. So SBS might be on the box as well so I have to keep these things in mind. I am definitely an accidental dba (developer by trade) and your comments are much appreciated. I will have to come up with sensible defaults for each environment. Thanks
Jul
15
comment Tempdb autogrowth settings
Thanks for the links. It would be great if that trace flag could be configured for just one database
May
28
comment Does SQL Server evaluate functions once for every row?
Thanks for the link and explanations :)
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
Feb
15
comment Output into temporary table
Thanks. Fancy putting that in an answer :)
Dec
28
comment Table value functions vs UDF SQL Server
Didn't see the duplicate :/ my bad
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
Nov
10
comment Need help figuring out correct permissions for SQL Server Users
Thanks. I think I understand. I am going to test this and post back if I have any problems :)
Nov
10
comment Need help figuring out correct permissions for SQL Server Users
Thanks for the answer :) I am going to try this in a bit. Would you also recommend doing a Deny All then explicitly allowing the permissions you want, eg. SELECT/INSERT/UPDATE
Sep
22
comment Is this Index checking logic ok?
because im trying to learn, i dont think anyone can learn by copy - paste - execute
Sep
22
comment Is this Index checking logic ok?
@gbn, I can understand that. The aim of this was to see if I could get the best of all the scripts (except missing indexes) into 1 script/view
Aug
29
comment Strange behaviour with Computed Columns in SQL-Server
And do you know why the QO would use the non-persisted column in my example above?