Skip to main content
Share Your Experience: Take the 2024 Developer Survey
bernd_k's user avatar
bernd_k's user avatar
bernd_k's user avatar
bernd_k
  • Member for 13 years, 4 months
  • Last seen more than 10 years ago
279 votes
7 answers
153k views

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

48 votes
10 answers
75k views

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

36 votes
2 answers
4k views

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

25 votes
1 answer
17k views

How to use transactions with SQL Server DDL?

24 votes
7 answers
103k views

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

24 votes
2 answers
77k views

How to catch and handle only specific Oracle exceptions?

22 votes
5 answers
6k views

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

21 votes
4 answers
93k views

Can I change the SID of an Oracle database?

20 votes
4 answers
26k views

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

19 votes
5 answers
4k views

Why do primary keys have names of their own?

19 votes
2 answers
30k views

Can I enable SQLCMD mode from inside a script?

19 votes
1 answer
8k views

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

15 votes
5 answers
16k views

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

14 votes
1 answer
14k views

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

13 votes
2 answers
144k views

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

12 votes
1 answer
26k views

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

12 votes
6 answers
1k views

Did anybody use sqlcmd mode in practice? [closed]

12 votes
4 answers
36k views

Oracle Import problem caused by different character sets

11 votes
2 answers
233 views

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

10 votes
2 answers
6k views

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

10 votes
4 answers
99k views

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

9 votes
2 answers
3k views

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

9 votes
4 answers
48k views

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

8 votes
2 answers
1k views

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

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?

7 votes
2 answers
2k views

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

7 votes
2 answers
7k views

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

7 votes
3 answers
8k views

How to handle multiple Oracle homes?

7 votes
1 answer
41k views

How to query given grants on Oracle?

7 votes
2 answers
24k views

What is the meaning of Microsoft Compatibility Level?