190 reputation
8
bio website
location Juneau, AK
age 46
visits member for 2 years, 1 month
seen Feb 6 at 0:41

I have three wonderful kids, two boys and a girl. My wife is a treasure.


Mar
19
awarded  Popular Question
Aug
7
answered How to query a database for empty tables
Jun
5
answered Find procedures that haven't been called in <n> days
Dec
2
accepted Why SQL Server doesn't support foreign key constraints on views?
Nov
30
awarded  Critic
Nov
30
asked Why SQL Server doesn't support foreign key constraints on views?
Nov
23
comment Security and Performance implications of “View Server State”
@PeterCarter: thanks for answering.
Nov
23
accepted Security and Performance implications of “View Server State”
Oct
26
comment Security and Performance implications of “View Server State”
@PeterCarter: +1 for the DoS and common wait states. I was hoping for something a bit more encompassing, but at least it's a solid potential risk.
Oct
24
comment Security and Performance implications of “View Server State”
@ThomasStringer: the question isn't about necessity, it's about risk. To put it in monetary terms, you may know what additional risks this would expose your servers to, and so be able to say no to a penny, and yes to a million dollars. I don't, but I want to.
Oct
23
awarded  Commentator
Oct
23
comment Security and Performance implications of “View Server State”
I understand Least Privileges, I in fact referenced it in my question -- I am looking for how to evaluate need vs risk. If 50% of the views cause the server to grind to a halt or it allows the user to view confidential information, then the need would have to be significant.
Oct
22
asked Security and Performance implications of “View Server State”
Aug
11
awarded  Student
Aug
11
comment UDF in check constraint — downside?
The application is where you try to do things right, the database is where you can say "this is wrong, don't allow it".
Aug
11
comment Why aren't primary key / foreign key matches used for joins?
@onedaywhen: I was referring to the syntax "natural join table_name (columnlist)", which I don't belive is ANSI 92, as an extension which allows you to join on more than one columns provided that both tables have them.
Aug
11
comment UDF in check constraint — downside?
@AlexKuznetsov: I read your blog, and have verified your general conclusion, but your query is incorrect for your stated goals (only one row with b if any row with b has 1), you need a second query to check for the number of rows with b's (otherwise adding a row with c2=0 works). I think the "workaround" of including all columns that are evaluated in the UDF in the parameter list should fix the general problem, but it's definitely a potential "gotcha" that you have to be aware of if you're going to use a UDF in a check constraint.
Aug
10
awarded  Scholar
Aug
10
accepted UDF in check constraint — downside?
Aug
10
comment UDF in check constraint — downside?
So, I'd have a table with a composite foreign key to a bridge table? Seems a bit strange, but that might be the best way to go...