bernd_k

3,753 reputation

22060

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	193

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,753 reputation	bio	website	pauerschell.blogspot.com	visits	member for	2 years, 4 months
22060 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

kviews

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

sequence sql-server-2012

dec 27 at 16:46 Martin Smith 17.4k

votes

answers

kviews

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

apr 4 at 20:58 Ravi Ramaswamy 1

votes

answers

993

views

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

sql-server sql-server-2005 clustered-index

may 9 at 7:02 gbn 42k

votes

answers

kviews

Can I change the SID of an Oracle database?

oracle oracle-11g linux

mar 11 at 16:33 Community♦ 1

votes

answers

584

views

Why do primary keys have names of their own?

sql primary-key

may 17 '11 at 2:29 RolandoMySQLDBA 41.2k

votes

answers

804

views

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

sql-server t-sql style

may 24 '12 at 1:48 AlexKuznetsov 3,607

votes

answers

151

views

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

sql-server stored-procedures

may 11 '12 at 20:42 el_stack 48

votes

answers

kviews

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

oracle datatypes

may 7 '12 at 11:35 Nick Chammas 5,910

votes

answers

kviews

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

sql-server sql sql-server-2005

apr 28 '12 at 21:33 Nick Chammas 5,910

votes

answers

634

views

Did anybody use sqlcmd mode in practice? [closed]

sql-server-2005 ssms sqlcmd

apr 15 '12 at 6:53 dbasv 1

votes

answer

kviews

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

sql-server-2008 empty-string

dec 20 '11 at 17:09 Jonathan VM 345

votes

answers

kviews

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

oracle sql-server-2005 stored-procedures migration

dec 5 '11 at 3:57 RolandoMySQLDBA 41.2k

votes

answers

kviews

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

oracle sql-server-2008 oracle-11g

oct 24 '11 at 15:07 Serge A. 21

votes

answers

273

views

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

oracle sql-server style

jan 7 '11 at 19:13 Leigh Riffel 13.7k

votes

answers

kviews

Can I enable SQLCMD mode from inside a script?

sql-server sqlcmd

sep 8 '11 at 5:36 Danere 205

votes

answers

952

views

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

oracle database-tuning oracle-sql-developer

nov 3 at 17:46 Mat 3,305

votes

answers

233

views

Is there a setting to force an error when asigning a varchar longer than a variable?

sql-server-2008

apr 19 '12 at 0:59 IgorP 11

votes

answer

551

views

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

sql-server temp-tables identity sql-server-2012 sequence

mar 16 '12 at 15:27 Nick Chammas 5,910

votes

answers

914

views

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

sql-server-2005 clustered-primary-key

nov 10 '11 at 21:45 Derek Downey 9,867

votes

answer

332

views

Which is the most performant way to copy a number of SQL Server tables to a readonly SQLite database?

sql-server sqlite

may 2 '11 at 0:02 Hector Sosa Jr 111

votes

answers

kviews

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

sql-server-2005 varchar t-sql

mar 16 '11 at 19:40 bernd_k 3,753

votes

answer

142

views

In a Trigger, can I determine if a column was explicitly set to a values or not mentioned in update statement?

sql-server triggers

mar 7 '11 at 19:36 Matt M 1,963

votes

answer

kviews

How to combine date and time to datetime in SQL Server?

sql-server

feb 26 '11 at 20:08 Gaius 7,167

votes

answers

676

views

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

oracle

feb 18 '11 at 13:57 Joe 3,116

votes

answers

kviews

Oracle Import problem caused by different charecter sets

import

jan 11 at 7:24 Jerónimo Vázquez 1

votes

answers

kviews

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

oracle security

aug 27 at 20:06 Leigh Riffel 13.7k

votes

answer

kviews

What does TOAD do, when I terminate script execution?

oracle

jul 22 at 0:00 benRollag 213

votes

answer

850

views

Can I call SMO from pure T-SQL?

sql-server-2008 stored-procedures generate-script

apr 9 '12 at 21:11 Nick Chammas 5,910

votes

answers

kviews

Building Dynamic SQL-Server Where Clause

sql-server performance sql-injection

nov 14 '11 at 14:55 Atilla Ozgur 879

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,390