Forum Replies Created

Viewing 15 posts - 2,671 through 2,685 (of 3,061 total)

  • RE: Date formating

    xgcmcbain (3/17/2009)


    Im looking for SQL that would work for both TSQL and PLSQL

    Welcome to the exciting world of looking for SQL holly grail 🙂

    What I have done in the...

  • RE: A great site like this - but for ORACLE.

    dmw (3/19/2009)


    I may not register because their Privacy Policy seems to suggest 'you have no privacy from our advertisers'.

    You can always create a gmail or whatever email account for the...

  • RE: How to create user in Oracle 9i

    Gift Peddie (3/13/2009)


    ... my actual question would be what are you doing with Oracle 9i because most people are now running 10g and 11g

    This statement does not reflects reality.

    Ora9i...

  • RE: Add file to Database

    I would create a new filegroup in the desired drive, once you have it there you can reorg tables/indexes the way better fits your I/O strategy.

  • RE: Please clarify

    Steve Jones - Editor (3/13/2009)


    We are more than happy to help, but we want you to do a little work first. Go research those questions, search in Books Online. If...

  • RE: How to create user in Oracle 9i

    Ratheesh.K.Nair (3/12/2009)


    First you connect to that particular database using login 'system'

    ie conn system\password@DB_Name as sysdba. Then try

    BA

    SYS and SYSTEM are Oracle equivalents of "sa" account; you don't want to connect...

  • RE: Best Place for tempdb

    If tempdb is your bottleneck you may want to setup tempdb on as many datafiles as CPUs you have in the box.

    Datafiles should be distributed so to balance I/O -Your...

  • RE: procedure cache drop

    Check the size of Procedure Cache, is Procedure Cache growing at the same time hit ratio goes down?

    Remember that a growing Procedure Cache would take space away from Data Cache...

  • RE: SQL Backup Job

    shri_sastry (3/9/2009)


    Do you think I should just disable the transaction log job and renable it after the full backup is done

    I wouldn't be enabling/disabling backup jobs, as a DBA you...

  • RE: Gateway issues

    oerr ora 28547

    28547, 0000, "connection to server failed, probable Oracle Net admin error"

    // *Cause: A failure occurred during initialization of a network connection

    // ...

  • RE: different methods to expose a stored procedure

    RJ (2/27/2009)


    what would be the different methods to expose a stored procedure to an external application. The external application can be another sql server 2005 or web based application or...

  • RE: Foreign Key Problems on Partitioned Table

    I do not think the issue has anything to do with partitioning but with the concept of referential integrity.

    I would start by asking myself the question: "Which parent-child relationship do...

  • RE: sql server 2005 system db move to different drive

    As part of your testing do not forget to attempt to patch SQL Server.

    During SQL Server patching you are going to find out if hidden mssqlsystemresource database is in the...

  • RE: Blocked Process

    I'm not sure if I'm following you to the atomic details of the issue but I would say you may want to work in two fronts.

    1- Setting a explicit transaction

    2-...

  • RE: Unable to find Activity monitor in SQL Express edition

    Why would you like to install express edition to work on a production environment?

    My suggestion is to install the full version.

    I know... it doesn't install, huh?

    You have to uninstall express...

Viewing 15 posts - 2,671 through 2,685 (of 3,061 total)