User WileCau - Database Administrators Stack Exchange

WileCau

Member for 12 years, 2 months
Last seen more than 1 year ago

Brisbane, Australia

9 Questions

Score Activity Newest Views

17 votes

3 answers

32k views

How to avoid using variables in WHERE clause

asked May 16, 2013 at 13:02

5 votes

5 answers

10k views

How to select from a table without including repeated column values?

asked Jul 30, 2013 at 11:20

3 votes

2 answers

2k views

Is there a standard way to use common data and procedures across multiple databases?

asked May 20, 2013 at 8:04

3 votes

1 answer

2k views

Are there reasons to not use SCHEMABINDING on database objects?

asked Feb 25, 2014 at 0:37

2 votes

3 answers

756 views

How to restore a database then upgrade it in a single SQL script?

asked May 30, 2014 at 6:57

2 votes

3 answers

3k views

How to merge data sets without including redundant rows?

asked Jun 4, 2013 at 2:49

1 vote

3 answers

29k views

How to get the return value from a stored procedure executed with sp_executesql

asked Apr 13, 2015 at 2:29

1 vote

0 answers

132 views

Is there a way to generate an execution plan for a stored procedure before executing it?

asked May 22, 2013 at 11:58

0 votes

1 answer

53 views

Does a filtered index improve searching on the opposite condition?

asked Jan 20, 2014 at 4:34