Forum Replies Created

Viewing 15 posts - 661 through 675 (of 3,060 total)

  • RE: Database in 'Recovery Pending' State -Error 945

    Do you have a good backup of the affected database?

    _____________________________________
    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: Design Advice - Partitioned Views or Partitioned Tables?

    EAS-917374 (12/23/2011)


    I think you are making my point for me. If I partition by date, then I only get the benefit of partition elimination when I query using a...

    _____________________________________
    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: restore from transaction logs point in time

    bill.akin (12/27/2011)


    yes it was

    Check TLOG BACKUP script - it should include a "TO DISK=N'----location of the tlog trn files----' option.

    _____________________________________
    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: Script SQL 2005 Security

    angel.fernandezj (12/27/2011)


    Hi everyone, I was asked to script or backup all the security of a SQL server with multiples databases. I have to script: SQL server users, database logins, roles...

    _____________________________________
    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: Recusive query using cte

    Cross post - please answer here: http://www.sqlservercentral.com/Forums/Topic1227037-392-1.aspx

    _____________________________________
    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: restore from transaction logs point in time

    bill.akin (12/27/2011)


    I have restored my live database into my test dbase with norecovery so that i can get to my transaction logs to restore at a point in time. ...

    _____________________________________
    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: Advice for my scenario

    mrecuerop (12/27/2011)


    Hi, thanks for your answer.

    No, it's not a test nor homework, it's just a doubt about how could i get some data.

    I think that my poor english doesnt make...

    _____________________________________
    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 databases

    erwinluke (12/24/2011)


    Many ways are present to move or copy a database from one server to another server using SQL server tools. Even so, as my experience the best way 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: Learn T-sql Help please!!!

    logicinside22 (12/22/2011)


    I do have sql server enterprise installed and have some books also ,i am just confused from where to start first.

    but thanks for guidence.

    happy Holidays and Marry Xmas

    Okay... install...

    _____________________________________
    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: Design Advice - Partitioned Views or Partitioned Tables?

    EAS-917374 (12/19/2011)


    There is an advantage to partitioned views which in my opinion is frequently overlooked, and that is the ability to specify multiple "partition keys", by adding multiple constraints to...

    _____________________________________
    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: ER diagram question

    tangoo111 (12/11/2011)


    thanks ....

    Wondering why you got all your posts blanked out - ashamed of them?

    _____________________________________
    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: Learn T-sql Help please!!!

    logicinside22 (12/22/2011)


    I want to learn T-SQL Programming but don't know from where to get starts ?

    so if you send me some advices ,guidenece or work flow ...

    _____________________________________
    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: Backups for beginners

    raotor (12/22/2011)


    Any advice or pointers to any plain-English articles on the broader subject of backup or restore would be welcome.

    This is pretty straight forward.

    As you may be aware of some...

    _____________________________________
    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: OLAP versus Datamart STAR schema

    Dev (12/20/2011)


    PaulB-TheOneAndOnly (12/20/2011)


    Dev (12/20/2011)


    At the end of the day, if business is asking for granular data or for an aggregation nobody thought before there is little...

    _____________________________________
    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: Materialized View in SQL Server 2008

    Elliott Whitlow (12/20/2011)


    Although the phrase Materialized views is not used often with MS SQL the Indexed views are the equivalent. As they must be materialized and stored very much...

    _____________________________________
    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 - 661 through 675 (of 3,060 total)