Reputation
793
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 12 33
Newest
 Nice Answer
Impact
~133k people reached

Sep
23
comment Database design for head to head sports
@a_horse_with_no_name You would store n rows per match, each with the same MatchID and with a different PlayerID. PK should be MatchID AND PlayerID. Also Sets should have an FK of MatchID into Matches, at least assuming this is like tennis where sets belong to a match, I don't know about darts.
Sep
23
accepted Set permissions on a view
Sep
22
comment Set permissions on a view
That works fine for queries I make, and SQL injection should be prevented on my set up, but unfortunately that property doesn't allow me to specify which table is "untouchable." Very good to know though.
Sep
22
asked Set permissions on a view
Sep
20
accepted Is table aliasing a bad practice?
Sep
20
revised Is table aliasing a bad practice?
added 15 characters in body
Sep
20
asked Is table aliasing a bad practice?
Sep
17
awarded  Teacher
Sep
17
answered What is the consensus on using NOT NULL constraints on all text-based fields in a table?
Sep
16
awarded  Commentator
Sep
16
comment Recent Queries in SQL Server 2005
thanks, messing with that now
Sep
16
comment Recent Queries in SQL Server 2005
Helpful but is there any way to get more than one statement from this? Unfortunately the operation I'm analyzing is a large series.
Sep
16
comment Recent Queries in SQL Server 2005
Perfect, catches a bit more info than I need but I'm tinkering with the filters.
Sep
16
accepted Recent Queries in SQL Server 2005
Sep
16
asked Recent Queries in SQL Server 2005
Sep
14
revised Why is SSMS inserting new rows at the top of a table not the bottom?
added 32 characters in body
Sep
14
comment Why is SSMS inserting new rows at the top of a table not the bottom?
It's Management studio 2008, the server is 2005, should have been clearer. I didn't know there was an "open table" command, I've always used the select statments
Sep
14
comment Why is SSMS inserting new rows at the top of a table not the bottom?
I wasn't planning on depending on the order, but visually it is a bit annoying that my last inserted items are suddenly at the top.
Sep
14
awarded  Editor
Sep
14
accepted Why is SSMS inserting new rows at the top of a table not the bottom?