Forum Replies Created

Viewing 15 posts - 1,666 through 1,680 (of 3,060 total)

  • RE: Step-by-Step how to configure SQL server 2000 log shipping?

    ganeshanmsc (8/3/2010)


    Step-by-Step how to configure SQL server 2000 log shipping?

    i want configure to sqlserver 2000 logshipping

    Is anything wrong with Microsoft documentation?

    In my opinion - in a case like this...

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: Need suggestion on Database Design

    tassadaque (8/2/2010)


    In my web application project i have packages, modules and documents (such as creatememo, createcircular,CreateEmployee). in my database i created tables for packages, associated modules and objects (employee, memo,...

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: Table Naming Question

    jere42 (8/3/2010)


    I just ran across a database here at work that has several tables where the name ends with a $. For example: Calls$

    What does the $ signify and is...

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: linked server timeout problem

    scottichrosaviakosmos (8/2/2010)


    I am currently working on sql server2008 and trying to fetch data from oracle 10.2 . when i right click on my linked server and click test connection it...

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: Many to many table relationship

    As a rule of thumbs, when you bump into a many-to-many relationship consider adding a bridge table to convert such m-to-m relationship into two 1-to-m.

    Hope this helps.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: Hi i am a sql dba.In my organizastion i am only the who will take care sql servers.2 servers are going to production within 2 days.

    Minto access (7/31/2010)


    ...2 servers are going to production within 2 days.

    ...didn't provide me any documents also.

    So please give me suggestions what are the activities need to test or to create...

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: maintain history

    Raunak Jhawar (7/25/2010)


    bozworth hollinz (5/10/2010)


    I'm working on a strategy to deploy ddl changes to a schema. However, I have the requirement to maintain the data within the schema. Does anyone...

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: (Cross) Relationship between 2 tables.

    Couple of questions about "Projects" table.

    Is there one and only one row per "project" in Projects table?

    When you say "Project has resources" do you mean "Projects" table knows which "resources"...

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: posting xml data to url using sql query or procedure

    neelagirichandra (7/29/2010)


    🙂

    nice smile 😀

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: oracle encoding

    sunloyhimmon (7/27/2010)


    So I figured I could do a workaround by importing from a view that kind of converts encoding on the external database instead.

    :blink: This is very confusing. There is...

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: Is Data Integrity really important or not

    doobya (7/24/2010)no point in implementing loads of checks if the system transfers £1,000,000 to complete strangers in 10 minutes because of a logic error

    :w00t: interesting approach.

    Shall I understand you are...

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: Database Partitioning

    hxkresl (7/21/2010)


    One more question on partitioning. Is it common to add a DateCreated column to every table and assign every table to the same partition scheme so that related...

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: Migrating from Sybase to SQL Server 2008

    sandyinfowave (7/23/2010)


    I have been assigned a new job of Migrating the databases from Sybase to SQL Server 2008.....Can anybody help me in providing the documentation and any suggestions on how...

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: Are DB snapshots read-only or can they be used for restoring a database fully?

    hxkresl (7/23/2010)


    OK, got the part about speed but I'm tripping on "read-only". That doesn't sound fully functional.

    It is read-only... until you restore it 🙂

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • RE: Not well known about how E.F. Codd was rejected

    CELKO (7/23/2010)


    He actually wrote that I was just like the bastards who made him stop writing perfectly good GOTO's in his code years ago.

    I had one of those in my...

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 15 posts - 1,666 through 1,680 (of 3,060 total)