Ben Brocka's user avatar
Ben Brocka's user avatar
Ben Brocka's user avatar
Ben Brocka
  • Member for 12 years, 7 months
  • Last seen more than a month ago
27 votes
6 answers
8k views

Is table aliasing a bad practice?

23 votes
9 answers
13k views

Is there a reason to use extremely abbreviated table names?

20 votes
2 answers
16k views

Why is IDENTITY_INSERT ON only allowed on one table at a time?

15 votes
3 answers
20k views

What is a "heterogeneous query"?

14 votes
4 answers
174k views

Combine column from multiple rows into single row

14 votes
3 answers
14k views

Why is SSMS inserting new rows at the top of a table not the bottom?

8 votes
3 answers
4k views

How can I change the target server type for a trace template?

6 votes
1 answer
681 views

Will a clustered index improve performance of updates performed sequentially on that clustered index?

6 votes
3 answers
4k views

Does ORDER BY on a clustered key affect performance?

4 votes
2 answers
3k views

Set permissions on a view

3 votes
2 answers
1k views

Recent Queries in SQL Server 2005

3 votes
2 answers
5k views

Single Identity column and composite key, which to make primary?

3 votes
3 answers
2k views

Identifying rows which don't match a master row

2 votes
2 answers
3k views

Query intermittently fails with "The multi-part identifier could not be bound"

2 votes
2 answers
802 views

What reason is there to create a physical table for a report output?

2 votes
2 answers
4k views

Query data from multiple linked remote databases

1 vote
1 answer
10k views

Select a single row from two distinct columns [duplicate]

1 vote
4 answers
2k views

Top 2 rows per partition from an absolute value date difference

1 vote
1 answer
198 views

How should row-specific metadata be created handled for an outer join view?

0 votes
1 answer
31 views

Bulk Fix Datasources on imported SSRS Reports