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
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
Nov
29
asked Over use/correct use of schemas?
Nov
22
awarded  Citizen Patrol
Nov
10
accepted When should a primary key be declared non-clustered?
Nov
10
comment When should a primary key be declared non-clustered?
Thanks @BenBrocka that makes sense. What would be your recommendation if instead of having a country column, you would have another table for the countries (so the country column is now normalised)
Nov
10
asked When should a primary key be declared non-clustered?
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
Nov
10
accepted Need help figuring out correct permissions for SQL Server Users
Nov
10
accepted Is this Index checking logic ok?
Nov
10
asked Need help figuring out correct permissions for SQL Server Users
Sep
22
awarded  Critic
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
revised Is this Index checking logic ok?
updated query to latest version
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
Sep
22
revised Is this Index checking logic ok?
added 124 characters in body
Sep
22
asked Is this Index checking logic ok?