Skip to main content
bernd_k's user avatar
bernd_k's user avatar
bernd_k's user avatar
bernd_k
  • Member for 13 years, 6 months
  • Last seen more than 10 years ago
24 votes
7 answers
104k views

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

10 votes
4 answers
101k views

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

280 votes
7 answers
155k views

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

23 votes
5 answers
6k views

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

5 votes
3 answers
565 views

Using DTA vs. evaluating DMVs?

5 votes
4 answers
5k views

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

20 votes
4 answers
26k views

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

21 votes
4 answers
94k views

Can I change the SID of an Oracle database?

5 votes
1 answer
3k views

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

4 votes
2 answers
3k views

Has SELECT an INSERT clause?

48 votes
10 answers
75k views

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

7 votes
2 answers
8k views

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

19 votes
2 answers
30k views

Can I enable SQLCMD mode from inside a script?

15 votes
5 answers
16k views

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

12 votes
4 answers
36k views

Oracle Import problem caused by different character sets

13 votes
2 answers
145k views

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

19 votes
1 answer
8k views

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

5 votes
3 answers
27k views

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

2 votes
2 answers
2k views

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

6 votes
2 answers
2k views

Can I call SMO from pure T-SQL?

25 votes
1 answer
17k views

How to use transactions with SQL Server DDL?

36 votes
2 answers
4k views

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

7 votes
3 answers
8k views

How to handle multiple Oracle homes?

9 votes
4 answers
48k views

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

4 votes
4 answers
565 views

How implement a cancel attribute in a table?

7 votes
2 answers
24k views

What is the meaning of Microsoft Compatibility Level?

2 votes
1 answer
2k views

Can IMPLICIT_TRANSACTIONS set on database level?

12 votes
1 answer
26k views

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

3 votes
2 answers
836 views

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

3 votes
2 answers
18k views

How is localhost resolved by Oracle listener?