728 reputation
11127
bio website twitter.com/#!/BenBrocka
location Iowa
age 24
visits member for 3 years, 2 months
seen Aug 21 at 21:19

I'm a moderator on User Experience Stack Exchange. (That's right here!)

Programmer/Systems Analyst working mostly in PHP/HTML/CSS. Enthusiast follower of User Experience topics and solutions.


Aug
29
asked How can I change the target server type for a trace template?
Jun
7
asked Query intermittently fails with “The multi-part identifier could not be bound”
May
15
asked Combine column from multiple rows into single row
Apr
18
asked Identifying rows which don't match a master row
Feb
10
asked Why is IDENTITY_INSERT ON only allowed on one table at a time?
Feb
10
asked Single Identity column and composite key, which to make primary?
Jan
9
asked Does ORDER BY on a clustered key effect performance?
Dec
30
asked How should row-specific metadata be created handled for an outer join view?
Dec
14
asked Top 2 rows per partition from an absolute value date difference
Nov
17
asked Select a single row from two distinct columns
Nov
17
asked Will a clustered index improve performance of updates performed sequentially on that clustered index?
Nov
10
answered When should a primary key be declared non-clustered?
Nov
4
asked What reason is there to create a physical table for a report output?
Sep
30
asked What is a heterogeneous query?
Sep
30
answered Query data from multiple linked remote databases
Sep
28
asked Query data from multiple linked remote databases
Sep
22
asked Set permissions on a view
Sep
20
asked Is table aliasing a bad practice?
Sep
17
answered What is the consensus on using NOT NULL constraints on all text-based fields in a table?
Sep
16
asked Recent Queries in SQL Server 2005