Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MeganP

    ReportNet Configuration (Content Manager issue)

    I am trying to configure Cognos ReportNet on my Windows XP Home. Here is the status of the tasks. 1. Installed Apache WebServer - Tested and it is working fine 2. Installed Cogns ReportNet 1.1 - Installed properly. 3. Content Manager setup - Tried to connect Oracle 9i database with admin...
  2. MeganP

    Perl basics

    HI, I need to migrate perl program from one server to another. What steps do I need to follow during the process? If I simply install perl in the desired folder, will it be enough or do I need to tweak in any way to make it work? After installation do I need to do any additional tasks? Thank...
    • MeganP
    • Thread
    • Replies: 2
    • Forum: Perl
  3. MeganP

    Match pattern

    Thanks for your prompt reply. Previously GREEN and ZONE could find next to each other (side by side column values), but now there are two empty columns between them. If I could make the following change, Would it be suffiecient? next if $_ !~ /PECO\s*\,\,\,\s*ZONE\s*\,/;
  4. MeganP

    Match pattern

    HI, I am newbie to Perl. I started supporting one application that has one perl program and it needs modification. It does get next record if current record doesn't match pattern. I couldn't understand the use of s* and , in the match pattern. Could some one explain me in detail, please? next...
    • MeganP
    • Thread
    • Replies: 6
    • Forum: Perl
  5. MeganP

    DTS migration

    HI all, How could I migrate DTS packages, as a group, from one server to another? Currently I am coping one package at a time. Any help is greatly appreciated! Thanks!
  6. MeganP

    Crontab Issue

    Thanks a lot!
  7. MeganP

    Crontab Issue

    Hi, I have written the following script to schedule a job to run on 3rd Wednesday of every month, but It is executing on every Wednesday and every day between 15-21 dates. Can some one help me in fixing this bug. Any help is greatly appreciated! 00 16 15-21 * 3 /u11/cdw_prod/Script1.ksh Thanks!
  8. MeganP

    Remove duplicates

    I know the SQL (in Oracle) for removing duplicates (leaves one record). Can some one translate the below or write new one in T-SQL? delete from my_table t1 where exists (select 'x' from my_table t2 where t2.key_value1 = t1.key_value1 and t2.key_value2 =...
  9. MeganP

    SQL Profiler intrepretation

    Can some one explain me how to intrepret SQL profiler produced information, please? I am looking for detailed information. Thanks,
  10. MeganP

    Update performance

    I ran SQL profiler on both the servers and found out that INDEX has not been used on new server. HOw can I force SQL Server to use index for update process?
  11. MeganP

    Update performance

    DTS package executes SQL update query, but the source is TEXT file. In DTS it shows like this UPDATE Supplier SET SUPPLIER_LINE_1 =?, SUPPLIER_LINE_2 =?, Lineage_Full =?, Lineage_Short =? WHERE Supplier_number = ? How can I use this query in Query Analyzer? What changes do I need to make...
  12. MeganP

    Update performance

    How can I review the execution plan of DTS Package? I would really appreciate if You would throw some light on this.
  13. MeganP

    Update performance

    HI all, When we migrated SQL server database from one server to another (New Server is robust), Insert performance has been improved a lot, but Update performance has diminished a lot. I couldn't find any change in objects like Indexes, Keys. What could be the issue? PS: DTS packages are...
  14. MeganP

    Importing properties of table besides data

    SOme how I am just getting the table layout, not all the properties (Indexes, dependenies etc..)
  15. MeganP

    Importing properties of table besides data

    When I copy table (export data) from one SQL Server database to another, How I can import all the properties of table including primary key, indexes, dependencies etc. Any help is greatly appreciated!
  16. MeganP

    SQL Server 2000 performance on Win 2003 relative to Win2000

    How is SQL Server 2000 performance on Windows 2003 OS server in comparision to Windows 2000? Does any one have any real time experince? My DTS package performance has diminished on 2003 server, but I am not sure of the real culprit. Can anyone help me with their expereinces?
  17. MeganP

    Performance issue?

    Denny, Thanks for your quick reply. Let me give you a little bigger picture. Old server has Windows 2000 & SQL Server 2000; New one has Windows 2003 & SQL Server 2000. Complete configuration is exactly identical, except OS. How come a DTS package (Insert & Update)process time changes to that...
  18. MeganP

    Performance issue?

    HI all, We have copied DTS packages from one SQL database on one server to another. New Server is more robust and has large memory. Other applications are running pretty fast on the server, But when I execute my SQL DTS packages, they are taking noticeably much longer comapring with old server...

Part and Inventory Search

Back
Top