User bernd_k

24 votes

7 answers

99k views

How to get rid of ORA-28002 message the password will expire within 6 days?

asked Jan 17, 2011 at 16:40

10 votes

4 answers

89k views

ORA-01502: index or partition of such index is in usable state problem

asked Jul 10, 2011 at 20:56

272 votes

7 answers

144k views

When should I use a unique constraint instead of a unique index?

asked Jan 4, 2011 at 10:32

22 votes

5 answers

5k views

Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?

asked Mar 5, 2011 at 16:59

5 votes

3 answers

558 views

Using DTA vs. evaluating DMVs?

asked Aug 7, 2011 at 10:24

5 votes

4 answers

5k views

Which problems arise, declaring the size of all varchar parameters as max in stored proc?

asked Mar 16, 2011 at 15:59

20 votes

4 answers

25k views

What is the difference between Oracle's VARCHAR and VARCHAR2 datatypes?

asked Feb 17, 2011 at 17:58

20 votes

4 answers

90k views

Can I change the SID of an Oracle database?

asked Jan 6, 2011 at 9:30

5 votes

1 answer

3k views

Which workarounds exists to missing relative path feature of SQLCMD :r?

asked Sep 12, 2011 at 7:27

4 votes

2 answers

3k views

Has SELECT an INSERT clause?

asked Sep 7, 2011 at 5:32

48 votes

10 answers

73k views

How do I copy a table with SELECT INTO but ignore the IDENTITY property?

asked Jan 26, 2011 at 16:28

7 votes

2 answers

7k views

I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer

asked May 12, 2011 at 12:36

19 votes

2 answers

29k views

Can I enable SQLCMD mode from inside a script?

asked Sep 7, 2011 at 5:59

15 votes

5 answers

16k views

Does it make sense to use SQL Server's bracket notation in hand written code?

asked Jan 5, 2011 at 14:18

12 votes

4 answers

36k views

Oracle Import problem caused by different character sets

asked May 16, 2011 at 10:10

13 votes

2 answers

144k views

How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?

asked Nov 27, 2011 at 9:21

18 votes

1 answer

7k views

Empty Strings: Why or when is '' equal to ' '?

asked Dec 20, 2011 at 12:08

5 votes

3 answers

26k views

How to replace a CLOB column by a varchar2(4000) column?

asked Sep 19, 2011 at 13:48

2 votes

2 answers

2k views

How can can I get object definitions stripped of all comments?

asked Mar 10, 2011 at 14:23

6 votes

2 answers

2k views

Can I call SMO from pure T-SQL?

asked Mar 10, 2011 at 13:32

24 votes

1 answer

16k views

How to use transactions with SQL Server DDL?

asked Aug 5, 2011 at 6:20

36 votes

2 answers

4k views

Why are Denali sequences supposed to perform better than identity columns?

asked Mar 8, 2011 at 20:48

7 votes

3 answers

8k views

How to handle multiple Oracle homes?

asked Jun 6, 2011 at 17:43

9 votes

4 answers

47k views

How to drop SQL Server database currently in use and in Single user mode

asked Sep 6, 2013 at 9:17

4 votes

4 answers

515 views

How implement a cancel attribute in a table?

asked Aug 22, 2011 at 15:54

7 votes

2 answers

24k views

What is the meaning of Microsoft Compatibility Level?

asked Aug 29, 2011 at 13:06

2 votes

1 answer

2k views

Can IMPLICIT_TRANSACTIONS set on database level?

asked Jul 23, 2011 at 16:29

12 votes

1 answer

25k views

How can I assign different random values to each row in a SELECT statement?

asked Mar 8, 2011 at 17:09

3 votes

2 answers

792 views

How can I test sql scripts intended to run with sqlcmd -v in Sql Server Management Studio

asked Aug 24, 2012 at 10:33

3 votes

2 answers

18k views

How is localhost resolved by Oracle listener?

asked Dec 3, 2011 at 18:40

Stack Exchange Network

88 Questions

How to get rid of ORA-28002 message the password will expire within 6 days?

ORA-01502: index or partition of such index is in usable state problem

When should I use a unique constraint instead of a unique index?

Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?

Using DTA vs. evaluating DMVs?

Which problems arise, declaring the size of all varchar parameters as max in stored proc?

What is the difference between Oracle's VARCHAR and VARCHAR2 datatypes?

Can I change the SID of an Oracle database?

Which workarounds exists to missing relative path feature of SQLCMD :r?

Has SELECT an INSERT clause?

How do I copy a table with SELECT INTO but ignore the IDENTITY property?

I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer

Can I enable SQLCMD mode from inside a script?

Does it make sense to use SQL Server's bracket notation in hand written code?

Oracle Import problem caused by different character sets

How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?

Empty Strings: Why or when is '' equal to ' '?

How to replace a CLOB column by a varchar2(4000) column?

How can can I get object definitions stripped of all comments?

Can I call SMO from pure T-SQL?

How to use transactions with SQL Server DDL?

Why are Denali sequences supposed to perform better than identity columns?

How to handle multiple Oracle homes?

How to drop SQL Server database currently in use and in Single user mode

How implement a cancel attribute in a table?

What is the meaning of Microsoft Compatibility Level?

Can IMPLICIT_TRANSACTIONS set on database level?

How can I assign different random values to each row in a SELECT statement?

How can I test sql scripts intended to run with sqlcmd -v in Sql Server Management Studio

How is localhost resolved by Oracle listener?