User bernd_k

4 votes

2 answers

531 views

How to compare performance of two versions of a function?

asked Jan 11, 2011 at 10:09

4 votes

2 answers

8k views

How to return a CTE as REFCURSOR from an Oracle stored procedure?

asked Jan 12, 2011 at 14:10

4 votes

2 answers

8k views

How can I catch the output of DBMS_OUTPUT.PUT_LINE when executing a block using [Oracle.DataAccess.Client]?

asked Feb 19, 2011 at 15:16

4 votes

4 answers

2k views

Best method to give two Oracle databases on the same server access to common data

asked Feb 15, 2011 at 20:13

3 votes

2 answers

377 views

Is there a setting to suppress C-Style comments appearing as DOC in Oracle Output?

asked Jun 22, 2011 at 6:33

3 votes

1 answer

4k views

Recovering from: A transport-level error has occurred when sending the request to the server in SSMS

asked Jun 24, 2011 at 11:23

3 votes

2 answers

1k views

Mapping SQL Server integer to Oracle Datatype

asked May 28, 2011 at 7:42

3 votes

1 answer

1k views

Casesensitive vs. Caseinsensitive Collatesequences?

asked Apr 24, 2011 at 9:45

3 votes

1 answer

239 views

Is there a way to load a sql script with a specified encoding into a running SQL Server Management Studio (SSMS)?

asked May 3, 2011 at 6:15

3 votes

2 answers

4k views

Is it possible with SQL Server 2008 to have a Partioned Tables with an Identity Column?

asked Jul 27, 2011 at 5:46

3 votes

1 answer

8k views

How can I query the SQL Server Compatibility Level into a variable?

asked Oct 27, 2011 at 8:27

3 votes

3 answers

7k views

Login Problem as SYSDBA ORA-01031

asked Sep 29, 2011 at 10:26

3 votes

2 answers

18k views

How is localhost resolved by Oracle listener?

asked Dec 3, 2011 at 18:40

3 votes

2 answers

806 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

2 votes

1 answer

207 views

SQLCMDMODE from SSMS. Can I set -b mode when using :r to include files?

asked Sep 7, 2011 at 7:38

2 votes

1 answer

261 views

What are hypothetical indexes?

asked Sep 6, 2011 at 12:31

2 votes

1 answer

2k views

Can IMPLICIT_TRANSACTIONS set on database level?

asked Jul 23, 2011 at 16:29

2 votes

1 answer

377 views

Where to put glogon.sql in 32-bit ODAC (11.2.0.2.1)?

asked Aug 20, 2011 at 8:31

2 votes

1 answer

148 views

Can SQL profiles be deployed to other Oracle Databases?

asked May 16, 2011 at 10: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

2 votes

1 answer

3k views

What is the purpose of sqlbulkcopy's useinternaltransaction property?

asked Feb 22, 2011 at 13:06

1 vote

2 answers

2k views

Can I implement a 'gapless' identity column in Oracle?

asked Jul 19, 2011 at 11:08

1 vote

1 answer

642 views

Performance problem caused by joining with the result of a scalar function?

asked Jun 24, 2011 at 11:47

1 vote

1 answer

2k views

What is the replacement for EXEC sp_dboption <dbname> in SQL Server 2012?

asked Mar 11, 2012 at 8:02

1 vote

1 answer

2k views

Isn't a tab (char(9) ) whitespace in the ANSI/ISO SQL-92 specification (Section 8.2, , General rules #3)?

asked Dec 22, 2011 at 9:55

0 votes

1 answer

150 views

What is the rationale for requiring a column list when inserting into a table with identity column?

asked Nov 21, 2011 at 12:44

0 votes

1 answer

287 views

How to find "outer join in the where" syntax in SQL 2005 using cmptlevel 80?

asked Oct 24, 2011 at 18:07

0 votes

2 answers

1k views

Is where x = 0 or x is null to be replaced by where isnull(x, 0) = 0 resp. where NVL(x, 0) = 0

asked Feb 25, 2011 at 9:03

Stack Exchange Network

88 Questions

How to compare performance of two versions of a function?

How to return a CTE as REFCURSOR from an Oracle stored procedure?

How can I catch the output of DBMS_OUTPUT.PUT_LINE when executing a block using [Oracle.DataAccess.Client]?

Best method to give two Oracle databases on the same server access to common data

Is there a setting to suppress C-Style comments appearing as DOC in Oracle Output?

Recovering from: A transport-level error has occurred when sending the request to the server in SSMS

Mapping SQL Server integer to Oracle Datatype

Casesensitive vs. Caseinsensitive Collatesequences?

Is there a way to load a sql script with a specified encoding into a running SQL Server Management Studio (SSMS)?

Is it possible with SQL Server 2008 to have a Partioned Tables with an Identity Column?

How can I query the SQL Server Compatibility Level into a variable?

Login Problem as SYSDBA ORA-01031

How is localhost resolved by Oracle listener?

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

SQLCMDMODE from SSMS. Can I set -b mode when using :r to include files?

What are hypothetical indexes?

Can IMPLICIT_TRANSACTIONS set on database level?

Where to put glogon.sql in 32-bit ODAC (11.2.0.2.1)?

Can SQL profiles be deployed to other Oracle Databases?

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

What is the purpose of sqlbulkcopy's useinternaltransaction property?

Can I implement a 'gapless' identity column in Oracle?

Performance problem caused by joining with the result of a scalar function?

What is the replacement for EXEC sp_dboption <dbname> in SQL Server 2012?

Isn't a tab (char(9) ) whitespace in the ANSI/ISO SQL-92 specification (Section 8.2, , General rules #3)?

What is the rationale for requiring a column list when inserting into a table with identity column?

How to find "outer join in the where" syntax in SQL 2005 using cmptlevel 80?

Is where x = 0 or x is null to be replaced by where isnull(x, 0) = 0 resp. where NVL(x, 0) = 0