User bernd_k

282 votes

7 answers

156k views

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

asked Jan 4, 2011 at 10:32

48 votes

10 answers

76k views

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

asked Jan 26, 2011 at 16:28

36 votes

2 answers

4k views

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

asked Mar 8, 2011 at 20:48

25 votes

1 answer

17k views

How to use transactions with SQL Server DDL?

asked Aug 5, 2011 at 6:20

25 votes

2 answers

78k views

How to catch and handle only specific Oracle exceptions?

asked Dec 20, 2011 at 6:56

24 votes

7 answers

105k views

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

asked Jan 17, 2011 at 16:40

23 votes

5 answers

6k 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

21 votes

4 answers

94k views

Can I change the SID of an Oracle database?

asked Jan 6, 2011 at 9:30

20 votes

4 answers

26k views

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

asked Feb 17, 2011 at 17:58

19 votes

5 answers

4k views

Why do primary keys have names of their own?

asked Feb 20, 2011 at 15:19

19 votes

2 answers

30k views

Can I enable SQLCMD mode from inside a script?

asked Sep 7, 2011 at 5:59

19 votes

1 answer

8k views

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

asked Dec 20, 2011 at 12:08

15 votes

5 answers

17k views

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

asked Jan 5, 2011 at 14:18

14 votes

1 answer

14k views

Why does SQL*PLUS need a slash after CREATE TYPE?

asked Mar 8, 2011 at 11:40

13 votes

2 answers

145k views

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

asked Nov 27, 2011 at 9:21

12 votes

1 answer

26k views

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

asked Mar 8, 2011 at 17:09

12 votes

6 answers

1k views

Did anybody use sqlcmd mode in practice? [closed]

asked Jan 9, 2011 at 13:54

12 votes

4 answers

36k views

Oracle Import problem caused by different character sets

asked May 16, 2011 at 10:10

11 votes

2 answers

234 views

Is there anybody using the SQL Server feature to create groups of stored procedures differentiated by number?

asked Jan 7, 2011 at 15:36

10 votes

2 answers

6k views

Why can't I read Oracles CLOB columns via SQL-SERVER 2008 linked server?

asked Jan 5, 2011 at 18:10

10 votes

4 answers

104k views

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

asked Jul 10, 2011 at 20:56

9 votes

2 answers

4k views

How to migrate SQL Server Stored Procedures using temporary tables or table variables to Oracle?

asked Mar 13, 2011 at 14:46

9 votes

4 answers

48k views

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

asked Sep 6, 2013 at 9:17

8 votes

2 answers

1k views

Is this a new common pattern in Oracle Where exists ( Select NULL FROM...)?

asked Jan 5, 2011 at 16:11

8 votes

2 answers

5k views

What is the difference between terminating an Oracle sql statement with semicolon or with a slash on the next line?

asked Feb 17, 2011 at 18:39

7 votes

2 answers

2k views

How to convert primary keys into clustered primary keys for a great number of tables keeping referential identity

asked Mar 6, 2011 at 12:25

7 votes

2 answers

8k views

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

asked May 12, 2011 at 12:36

7 votes

3 answers

8k views

How to handle multiple Oracle homes?

asked Jun 6, 2011 at 17:43

7 votes

1 answer

41k views

How to query given grants on Oracle?

asked Sep 20, 2011 at 10:45

7 votes

2 answers

24k views

What is the meaning of Microsoft Compatibility Level?

asked Aug 29, 2011 at 13:06

Stack Exchange Network

88 Questions

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

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

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

How to use transactions with SQL Server DDL?

How to catch and handle only specific Oracle exceptions?

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

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

Can I change the SID of an Oracle database?

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

Why do primary keys have names of their own?

Can I enable SQLCMD mode from inside a script?

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

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

Why does SQL*PLUS need a slash after CREATE TYPE?

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

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

Did anybody use sqlcmd mode in practice? [closed]

Oracle Import problem caused by different character sets

Is there anybody using the SQL Server feature to create groups of stored procedures differentiated by number?

Why can't I read Oracles CLOB columns via SQL-SERVER 2008 linked server?

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

How to migrate SQL Server Stored Procedures using temporary tables or table variables to Oracle?

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

Is this a new common pattern in Oracle Where exists ( Select NULL FROM...)?

What is the difference between terminating an Oracle sql statement with semicolon or with a slash on the next line?

How to convert primary keys into clustered primary keys for a great number of tables keeping referential identity

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

How to handle multiple Oracle homes?

How to query given grants on Oracle?

What is the meaning of Microsoft Compatibility Level?