Forum Replies Created

Viewing 15 posts - 1,606 through 1,620 (of 3,061 total)

  • RE: Package fails when adding field from Oracle

    S Hodkinson (8/19/2010)

    We have tried running the scripts attached but still get the error reported on the ODBC connection.

    Please do this...

    Log into Oracle database via sqlplus then execute query -...

    August 19, 2010 at 6:42 am

    #1209056

  • RE: SQL on VMWare

    rdecker (8/18/2010)

    Yes, 10K concurrent users. We're a little reluctant to call MS or and other third party at this point, it's just too involved.

    I can understand that.

    If that's the...

    August 18, 2010 at 2:53 pm

    #1208790

  • RE: SHRINKFILE

    sudhakara (8/18/2010)

    Steve Jones - Editor (8/18/2010)

    I believe that data is moved to other files in the filegroup, round robin style, and then the file is emptied.

    Thanks for your reply. My...

    August 18, 2010 at 10:55 am

    #1208639

  • RE: Openquery hanging, is it Oracle or SQL Server's fault?

    tomiboy59 (8/18/2010)

    Ok. The query hanging hasn't happened for a while, but now I got the error in the picture attached. This gets fixed if I restart the server. It happens...

    August 18, 2010 at 10:45 am

    #1208627

  • RE: how to check database is schedule for backup operation or not

    diva.mayas (8/18/2010)

    i get from backupset but how to find in scheduled jobs ?Is there any way to find through T-sql

    Problem is, you wouldn't know the name of the job which...

    August 18, 2010 at 10:31 am

    #1208614

  • RE: SQL on VMWare

    rdecker (8/18/2010)We're looking at 10K concurrent users with short, bursty queries.

    Like in "10K concurrent requests to the database"?

    Better to get Microsoft involved in the project.

    August 18, 2010 at 10:24 am

    #1208610

  • RE: The Logic, Mathematics, and Utility of NULLs

    Steve Jones - Editor (8/18/2010)

    It could be N/A, but that implies a specific meaning. Using NULL there as a placeholder works, but you are assigning a value to NULL. I...

    August 18, 2010 at 9:44 am

    #1208579

  • RE: Package fails when adding field from Oracle

    S Hodkinson (8/18/2010)

    We have an integration services package which collects data from an Oracle 7 database. At the moment it collects quite a lot of data but we need...

    August 18, 2010 at 9:38 am

    #1208575

  • RE: How to connect to Oracle 9i via Instant Client from Oracle

    bechihai (8/17/2010)

    Thanks for your help. Today I actually downloaded the Oracle 11g Release 2 for Windows 64 bit then run the setup.exe to install the client on my server....

    August 18, 2010 at 9:35 am

    #1208570

  • RE: Number of TempDb Files

    DBAgal (8/17/2010)

    I've done some research and it seems like every person has a different recommendation as to the number of data files the tempdb should have.

    Here's my scenaro - I...

    August 17, 2010 at 1:07 pm

    #1208091

  • RE: Please Help me improve this SPROC!!! It runs too slow!

    Two questions...

    - How many rows are in the table?

    - How many rows is expected this query to retrieve?

    Anyway, how about creating an index on PERIOD column?

    August 17, 2010 at 11:53 am

    #1208069

  • RE: how to check database is schedule for backup operation or not

    diva.mayas (8/17/2010)

    IS there any way or sys tables where we can check whether database is scheduled in backup operation.

    Check msdb.dbo.backupset - should contain one row per backup operation.

    August 17, 2010 at 10:14 am

    #1208012

  • RE: Data warehouse - Dimensions

    PrincessPuja (8/17/2010)

    I have a question on Data warehousing - Dimension Types. I am interested to know what are different types of Dimesnions that can be used in Data warehousing.

    I...

    August 17, 2010 at 9:45 am

    #1207987

  • RE: How to connect to Oracle 9i via Instant Client from Oracle

    bechihai (8/16/2010)

    I have a SQL 2008 64 bit and I need to connect to Oracle 9i to read data via SSIS 2008.

    I have already downloaded Instant Client Basic and...

    August 17, 2010 at 9:17 am

    #1207956

  • RE: Deleting a Partition Table

    amy26 (8/13/2010)

    Dropping the table does not get rid of the files and filegroups that I have created for the table.

    That's a different story - did you already drop the offending...

    August 13, 2010 at 10:45 am

    #1206794

Viewing 15 posts - 1,606 through 1,620 (of 3,061 total)