4,220 reputation
62976
bio website pauerschell.blogspot.com
location Germany
age 62
visits member for 3 years, 3 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/


Sep
29
comment Login Problem as SYSDBA ORA-01031
Yes I use the TNS_ADMIN environment variable cf. dba.stackexchange.com/questions/3194/…
Sep
18
comment Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?
+1 for giving that link. There are some interesting hints there. But I think the result would be much more convincing, if he had compared the the given scenario with one with create nonclustered index cidx_trantime on tblTransactions (TranTime) or some other alternative. Remember when you generate such a lot of data there must be efficient ways to retrieve the data, you can't just throw every thing into a heap.
Sep
9
comment Can I enable SQLCMD mode from inside a script?
I'm using SSMS 2008 R2 and there the 2 lines produce: Meldung 102, Ebene 15, Status 1, Zeile 1 Incorrect syntax near ':'. Using SQL Server 2000 Query Analyzer you need to use RAISERROR.
Sep
8
comment Can I enable SQLCMD mode from inside a script?
For ssms the first 2 lines would be enough and for sql 2000 Query Analyzer it works, but the message is not displayed.
Aug
23
comment Which picture does the ORA-01830 error message refer to?
I prefer to use alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss'
Aug
20
comment Where to put glogon.sql in 32-bit ODAC (11.2.0.2.1)?
It is a client on my new Windows 7-64 bit notebook.
Aug
20
comment Is there a DBMS that allows the “= NULL” syntax?
The old sysbase style syntax is more readable in constructs like where x in (null, 1, 2) which you have to rewrite as where y is null or x in (1, 2). BTW even ANSI isn't stringent about NULL can't be equal to NULL. Just see how it handles GROUP BY. I really liked the old syntax, but I abounded fighting against ANSI defaults.
Aug
8
comment Can filtered indexes help improve queries that are based on a time entered or should this be avoided?
A good link is a good start. But I would like to get more information.
Aug
8
comment Which performance counters can you look at on a SQL Server Instance to determine it's performance and over all health?
Is there something at that level to monitor deadlock and waits?
Aug
6
comment How to determine if an Index is required or necessary
Just diving into it. Seems to be the most promising starting point.
Aug
6
comment Does NULL have a type?
+1 For curiosity let's try Select NULL what_type_is_this from DUAL; Of course this no practical useful example and I didn't try it yet, I have learned to use casts in such cases.
Aug
3
comment Can filtered indexes help improve queries that are based on a time entered or should this be avoided?
I see your point, but I don't find that your problem is rather specific, it is the one first problem everyone encounters who has a grown database structure with data entered with relation to time, when thinking about filtered indexes. OK it is possible to ask in different ways.
Aug
2
comment Can filtered indexes help improve queries that are based on a time entered or should this be avoided?
OK. What is the answer to your question? Does the filtered index help or not? I think you better had not accepted an answer which main part is just a link to some Microsoft paper. Now we will have a hard time asking questions about filtered indexes without risking being closed as duplicate.
Aug
2
comment Can filtered indexes help improve queries that are based on a time entered or should this be avoided?
The people who came here don't want to get only pointers to that papers. They and I want independent simple examples to get a feeling where this feature might help. They want to be able to deal with arguments like we do not like spending money in Enterprise Editions, perhaps filtered indexes helps us save the money.
Jul
27
comment Is it possible with SQL Server 2008 to have a Partioned Tables with an Identity Column?
He doesn't tell, what happens when there is a primary key on the identity column and partitions are swapped.
Jul
26
comment How to export a single huge table from SQL Server?
+1 for combination of characters. But you can use them without format files. bcp dbname.dbo.mytable OUT test1.txt -S myserver -U sa -P 1234 -c -r '€\n' -t '€|' -- or bcp "SELECT * FROM dbname.dbo.mytable WHERE xx > 100" queryout bk_test2.txt -S myserver -U sa -P 1234 -c -r '€\n' -t '€|'
Jul
25
comment How to export a single huge table from SQL Server?
The varchar fields can contain any character. How do format files help?
Jul
24
comment How to export a single huge table from SQL Server?
I do not see how a format file could help here
Jul
23
comment Guarantee SQL Server Identity Columns that two consecutive values differ by constant increments?
Think twice. Your link shows that a single session doesn't get gapeless values. I can't say that is unexpected. Looking at Foo I saw no gaps in the ids of that table: select max(id) - MIN(id) + 1, COUNT(*) from foo
Jul
19
comment Can I implement a 'gapless' identity column in Oracle?
I think SQL Server identity columns do. But I asked it here dba.stackexchange.com/questions/3948/…