bernd_k

3,773 reputation

32161

bio	website	pauerschell.blogspot.com
	location	Germany
	age	61
visits	member for	2 years, 4 months
	seen	May 6 at 15:33
stats	profile views	195

Database developer for SQL-Server and ORACLE. Doing a lot with PowerShell.

I'm German and it is now only 4 years that I started bloging (in english) and now i'm contributing to several OpenSource Projects. Codeplex SQLPSX is the most important of them. There I'm porting SQLIse to Oracle and now to MySQL too.

If your are interested in databases and PowerShell (or other ways to use ADO.NET) please visit: http://sqlpsx.codeplex.com/

	3,773 reputation	bio	website	pauerschell.blogspot.com	visits	member for	2 years, 4 months
32161 badges		location	Germany		seen	May 6 at 15:33

summary answers questions tags badges favorites bounties reputation activity

88 Questions

views newest activity votes

votes

answers

198

views

Are there other sites forbidding SQL developer to use c style comments?

style

oct 20 '11 at 20:09 Marian 8,440

votes

answers

kviews

Has SELECT an INSERT clause?

sql-server select

sep 7 '11 at 5:45 gbn 42.4k

votes

answers

258

views

Using DTA vs. evaluating DMVs?

sql-server-2008 performance index-tuning

aug 7 '11 at 15:47 gbn 42.4k

votes

answers

kviews

How to handle multiple Oracle homes?

oracle

jun 7 '11 at 13:00 Leigh Riffel 13.8k

votes

answers

219

views

How can I fix the Oracle syntax of this update by the result of a select in Oracle 10g?

oracle-10g syntax

mar 31 '11 at 17:42 Leigh Riffel 13.8k

votes

answers

775

views

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

oracle database-recommendation

feb 16 '11 at 21:21 BillThor 2,025

votes

answers

212

views

How to compare performance of two versions of a function?

sql-server performance-testing

jan 11 '11 at 14:00 bernd_k 3,773

votes

answer

215

views

Are there tools for SQL-Server helping to add the semicolons?

sql-server-2008 syntax

jan 5 '11 at 1:27 mrdenny♦ 17.2k

votes

answers

kviews

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

oracle stored-procedures oracle-11g cte

dec 28 at 14:12 Leigh Riffel 13.8k

votes

answers

kviews

Login Problem as SYSDBA ORA-01031

oracle sqlplus

jul 26 at 10:47 Community♦ 1

votes

answers

890

views

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

sql-server stored-procedures

may 2 '12 at 18:28 Nick Chammas 5,920

votes

answer

kviews

How to write a check constraint to disallow empty varchar fields?

sql-server constraint

dec 21 '11 at 15:33 Martin Smith 17.5k

votes

answers

kviews

How to catch and handle only specific Oracle exceptions?

oracle exception

dec 20 '11 at 10:55 Sathya 729

votes

answer

492

views

How to query given grants on Oracle?

oracle

sep 20 '11 at 11:24 Vijayaraghavan 86

votes

answers

662

views

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

sql-server sqlcmd

sep 12 '11 at 8:52 bernd_k 3,773

votes

answers

534

views

What is the meaning of Microsoft Compatibility Level?

sql-server compatibilitylevel

aug 29 '11 at 13:30 gbn 42.4k

votes

answers

views

How implement a cancel attribute in a table?

sql-server oracle

aug 22 '11 at 16:17 gbn 42.4k

votes

answer

kviews

How to use transactions with SQL Server DDL?

sql-server-2008 transaction ddl

aug 5 '11 at 6:34 gbn 42.4k

votes

answers

kviews

How to export a single huge table from SQL Server?

sql-server export

jul 23 '11 at 19:06 SqlACID 1,624

votes

answers

741

views

Mapping SQL Server integer to Oracle Datatype

sql-server oracle datatypes

may 31 '11 at 7:46 Jack Douglas♦ 12.8k

votes

answers

756

views

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

oracle tablespaces

may 9 '11 at 14:40 Leigh Riffel 13.8k

votes

answer

563

views

Casesensitive vs. Caseinsensitive Collatesequences?

sqlite collation casesensitive

apr 24 '11 at 15:40 ik_zelf 3,254

votes

answers

kviews

How to convert a Top 1 subquery using outer table alias to Oracle?

oracle subquery

apr 22 '11 at 12:15 bernd_k 3,773

votes

answers

264

views

How can I extract a lessequal char from SQL_Latin1_General_CP1_CI_AS?

sql-server collation

apr 14 '11 at 5:54 bernd_k 3,773

votes

answer

815

views

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

sql-server transaction

apr 12 '11 at 4:59 gbn 42.4k

votes

answer

185

views

Can I determine if a stored procedure uses dynamic sql without parsing the definition?

sql-server-2008 dynamic-sql

mar 13 '11 at 12:57 gbn 42.4k

votes

answer

kviews

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

sql-server-2005 random

mar 8 '11 at 19:36 gbn 42.4k

votes

answer

kviews

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

oracle sqlplus usertypes

mar 8 '11 at 14:16 Brad Mace 225

votes

answer

558

views

Which fillfactor is used by ALTER INDEX REBUILD?

sql-server-2008 sql-server-2005 index

mar 8 '11 at 8:06 mrdenny♦ 17.2k

votes

answers

views

What can I do to find out since which release a given DBMS supports a feature, function, etc?

features

jan 7 '11 at 15:05 Gan 293