Recent content by juliane26

Don't you have a test stage without or with little billing or billed by CPU? create there empty tables and test the SQL there. Best would be with few data sets to test functionality. For SQL Server: well, a simple copy could be done using Access: export as CSV and import to SQL Server using...

Marc, Ties, I am actually not looking for the cube itself ( as Ties noted the complete set is probably not needed) but for constructs like GROUP BY GROUPING SETS ... there the subtotals can be defined for some level needed. And yes, we could use that in some batches and if only for checking or...

Hi, I am aware that a group by cube is not available in DB2 z/OS V8. Any idea how to realize the same in a single SQL statement ? I cannot find anything like that in DB2 z/OS V9 documentation either: does anybody know whether it is planned to be included in future versions ? Thank you very...

The "catch": Well, you start employing an complete set of Oracle Applications including Oracle AS and when starting to grow then there is hope for Oracle to be part of it. And then it won't be that cheap anymore: Oracle Database and Oracle Application Server do not come for free. When needing...

I liked this. Learned something. Star. Juliane

MasterRacker, Depends on the size of your workgroup - 5 or 6 ok, but when all of a sudden a complete department is interested, then it becomes an issue and a problem. I am busy with SQL server only short now(2 month), but we took over already 3 Access applications for that reason, probably all...

Its not so much performance: applications had to move away from Access backend (to SQLserver in our case) to enable multi-user. Juliane

You can download it for free at Microsoft: http://technet.microsoft.com/en-us/sqlserver/bb671104.aspx Juliane

Hondy, being new to the SQL Server World and having to move quite some databases to 2005 I actually used the SQL advisor first. And in two cases the tool even found something useful. OK it was packaged software which had to be upgraded too - but there are some changes in DDL which might be...

John, we are setting up a new SQL 2005 environment over here to centralize SQL applications. We have for all other database system naming conventions: the strictest on the host, followed by Unix systems. In SQL server I can forget about naming conventions going down to table names or views...

DB2 on Linux is using the Linux user authorization. So you have to define users and passwords in your linux system. the you can grant and revoke user rights to each user. there is an db2 user called 'public' - and whatever public can do is what everybody can do. so first thing you want to do...

Which DB2 are you using ? z/OS ? In LUW you should be able to do this. In case its LUW: which error/sqlcode do you get ? Juliane

Which backup device do you select? Select disc (and not tape) then select 'add' and enter a path and filename(like dbname.BAK) for your backup. Juliane

Hi Btacy, I moved quite some databases from a SQL 2000 Server to a SQL 2005 server simply by taking a backup and restoring it on the other machine. Just adjust the path for data and log files according to your new system when restoring. If needed (ask the vendor) adjust the compatibily level...

I have a little problem with our old DTS packages. We changed them to SSIS packages. They work as long executed in a way that all connections (i.e. file sources) are local and our sqlagent(local system user) has no problem accessing them. I would like to access a remote file system and changed...