SQLLawman

Latest comments

• Who’s Winning the Olympics?:
  • MichaelDeputy: That is a very astute observation, but if one athlete were able to win 2 golds and 2 silvers it would give the country a huge boost and obviously that country produced the best athlete (in his/her discipline) which is what I am looking for. After all the song they play is the national...
  • SQLRockstar: how about tracking the distinct number of athletes that win medals? if one country sends ten athletes, but one athlete wins two golds and two silvers, then their score (by your scale) would be a 1.0, which is quite skewed. it would be better to only count that athlete once, not sure which medal...
  • Jenny: Very cool system. I can't wait to see how your scores pan out over the next two weeks.
• SKU is Invalid when installing 2nd node in SQL 2008:
  • Vittorio Pavesi: Thanks for reference ;-)
• Find all Triggers:
  • SQLRockstar: funny, i just put together some t-sql for finding triggers as well: SELECT name, OBJECT_NAME(parent_id), is_disabled as [Parent Object] FROM sys.triggers i use sys.triggers because it includes DDL triggers, which are not in the sysobjects table.