User goric

40 votes

6 answers

70k views

What is the best way to get a random ordering?

asked Jan 27, 2011 at 19:40

20 votes

4 answers

15k views

Is there any benefit of a primary key that comprises all columns of the table?

asked Jan 21, 2011 at 13:02

20 votes

2 answers

42k views

What are database statistics, and how can I benefit from them?

asked Jan 23, 2011 at 19:34

19 votes

4 answers

7k views

Why would someone put `where 1=1` in a query?

asked Jan 21, 2011 at 13:26

17 votes

2 answers

2k views

Is there any tangible difference between a unique clustered index and a clustered primary key?

asked Jan 21, 2011 at 17:51

9 votes

3 answers

3k views

Is there a way to programmatically script all objects associated with a given table?

asked Jan 23, 2011 at 22:17

6 votes

3 answers

1k views

How do you approach refactoring an ugly procedure/query?

asked Feb 9, 2011 at 0:17

5 votes

3 answers

4k views

Why can't I use newid() in a user-defined table-valued function?

asked Jan 28, 2011 at 13:25

5 votes

2 answers

127 views

How do you handle adding nullable columns to each other in a query?

asked Feb 2, 2011 at 20:11

4 votes

2 answers

10k views

What is the best way to filter or otherwise manipulate the results returned by a stored procedure?

asked Jan 26, 2011 at 16:54

Stack Exchange Network

10 Questions

What is the best way to get a random ordering?

Is there any benefit of a primary key that comprises all columns of the table?

What are database statistics, and how can I benefit from them?

Why would someone put `where 1=1` in a query?

Is there any tangible difference between a unique clustered index and a clustered primary key?

Is there a way to programmatically script all objects associated with a given table?

How do you approach refactoring an ugly procedure/query?

Why can't I use newid() in a user-defined table-valued function?

How do you handle adding nullable columns to each other in a query?

What is the best way to filter or otherwise manipulate the results returned by a stored procedure?