4,405 reputation
84085
bio website pauerschell.blogspot.com
location Germany
age 62
visits member for 3 years, 11 months
seen Nov 22 '13 at 19:11

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/


Jun
5
comment What are the consequences of setting varchar(8000)?
Is sorting a table with a varchar(100) column filled with fields of 100 byte length worth another question, because sorting assumes an average of 50 character ?
Jun
5
comment What are the consequences of setting varchar(8000)?
That means performance decreases when the bigger size is really used, not by the pure fact, that it it's use is allowed.
Jun
5
comment What are the consequences of setting varchar(8000)?
Performance when the row exceeds 8060 bytes. That refers to actual used bytes and not to maximal allowed bytes?
Jun
4
comment What are the consequences of setting varchar(8000)?
I think we have to differentiate here between use in create table and use in parameter declarations of stored procedures. For the second interpretation see my question dba.stackexchange.com/questions/1772/…
May
29
comment Mapping SQL Server integer to Oracle Datatype
I asked this question because the internet sources, didn't state explicitly that an constraint to true integers is enforced. But I checked that point.
May
29
comment Mapping SQL Server integer to Oracle Datatype
I'm not sure, if I follow you with respect to varchar. It is a rather simple text replacement. But keeping the number types in sync is a real advantage.
May
29
comment Mapping SQL Server integer to Oracle Datatype
The only practical problems I encountered so far, occurred when porting back from Oracle to SQL-Server are with date to dateime when used to contain time only values. But migration back is the exception.
May
28
comment Mapping SQL Server integer to Oracle Datatype
In this special case no. But generally We (the developers) always hope that the Oracle database administrator of our customers retire and we can migrate the house to SQL Server.
May
16
comment Oracle Import problem caused by different character sets
I changed my table definition ...VARCHAR2(60 CHAR) NOT NULL ... and used IMP with IGNORE=Y and Import terminated successfully with warnings.
May
16
comment Oracle Import problem caused by different character sets
I have the create table script and can modify it according to your proposal. If imp works when the tables are already created, all would be fine.
May
16
comment Oracle Import problem caused by different character sets
not yet, but perhaps a good time to learn.
May
16
comment Oracle Import problem caused by different character sets
See my edit. My only hope is to first create the tables with extended width and than import the data ignoring the create tables from the import.
May
16
comment I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer
The true sql statement is tuned to be less than 4000 char. It has to run on 10g. But printed to output and coped to a file it got 415 KB due to trailing blanks.
May
13
comment I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer
I tried this in different VMs and with different users. It works sometimes, but after analyzing some long query I get the problem.
May
6
comment Is there a way to load a sql script with a specified encoding into a running SQL Server Management Studio (SSMS)?
and OEM 437 and OEM 850
May
6
comment Query execution time in Oracle SQL Developer
In German versions it is called Fortschritt - Task
May
4
comment What is the difference between select count(*) and select count(any_non_null_column)?
The main question is not which one runs faster, but if they return the same value
May
3
comment What does TOAD do, when I terminate script execution?
Now I have 119MB tracefile. What now?
May
3
comment What does TOAD do, when I terminate script execution?
There is a lot of analytical functions Rank() OVER (PARTITION
May
3
comment What does TOAD do, when I terminate script execution?
I#M not inserting or updating anything in that schema. No use of global temporary tables. Why does a long running query create any redo/undo or what else? Are there hidden 'temporay tables' ?