User bernd_k

4 votes

1 answer

7k views

What does TOAD do, when I terminate script execution?

asked May 2, 2011 at 9:40

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

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

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

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

36 votes

2 answers

4k views

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

asked Mar 8, 2011 at 20:48

4 votes

2 answers

4k views

What are the benefits of using a different tablespace for a new user schema?

asked May 7, 2011 at 7:38

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

6 votes

3 answers

4k views

Building Dynamic SQL-Server Where Clause

asked Jan 22, 2011 at 13:33

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

19 votes

5 answers

4k views

Why do primary keys have names of their own?

asked Feb 20, 2011 at 15:19

9 votes

2 answers

3k views

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

asked Mar 13, 2011 at 14:46

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

1 answer

3k views

Has somebody got a function that will extend hashbytes to strings of arbitrary length?

asked Jan 4, 2012 at 9:38

4 votes

3 answers

3k views

Are there ways to only replace SQL Server stored procedures when the definition has changed?

asked Oct 31, 2011 at 13:21

2 votes

1 answer

3k views

What is the purpose of sqlbulkcopy's useinternaltransaction property?

asked Feb 22, 2011 at 13:06

4 votes

2 answers

3k views

Has SELECT an INSERT clause?

asked Sep 7, 2011 at 5:32

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

2 answers

2k views

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

asked Jul 19, 2011 at 11:08

6 votes

2 answers

2k views

Can I call SMO from pure T-SQL?

asked Mar 10, 2011 at 13:32

6 votes

2 answers

2k views

Are there any reasons not enable SQLCMD-mode as default in SSMS?

asked Oct 31, 2011 at 7:42

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

2 votes

2 answers

2k views

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

asked Mar 10, 2011 at 14:23

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

5 votes

1 answer

2k views

Why is this rollback needed when using sp_addextendedproperty in a stored procedure?

asked Apr 10, 2011 at 6:59

4 votes

2 answers

2k views

How to query status changes in time series?

asked Jun 21, 2011 at 16:24

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

2 votes

1 answer

2k views

Can IMPLICIT_TRANSACTIONS set on database level?

asked Jul 23, 2011 at 16:29

6 votes

1 answer

2k views

Guarantee SQL Server Identity Columns that two consecutive values differ by constant increments?

asked Jul 19, 2011 at 12:45

3 votes

2 answers

1k views

Mapping SQL Server integer to Oracle Datatype

asked May 28, 2011 at 7:42

Stack Exchange Network

88 Questions

What does TOAD do, when I terminate script execution?

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

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

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

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

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

What are the benefits of using a different tablespace for a new user schema?

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

Building Dynamic SQL-Server Where Clause

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

Why do primary keys have names of their own?

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

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

Has somebody got a function that will extend hashbytes to strings of arbitrary length?

Are there ways to only replace SQL Server stored procedures when the definition has changed?

What is the purpose of sqlbulkcopy's useinternaltransaction property?

Has SELECT an INSERT clause?

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

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

Can I call SMO from pure T-SQL?

Are there any reasons not enable SQLCMD-mode as default in SSMS?

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

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

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

Why is this rollback needed when using sp_addextendedproperty in a stored procedure?

How to query status changes in time series?

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

Can IMPLICIT_TRANSACTIONS set on database level?

Guarantee SQL Server Identity Columns that two consecutive values differ by constant increments?

Mapping SQL Server integer to Oracle Datatype