Forum Replies Created

Viewing 15 posts - 841 through 855 (of 1,136 total)

  • RE: Best/fastest way to move all the DB's

    krypto69 (9/9/2009)


    Yep they are pretty small..and it's okay to take them all off line.

    So it would be better to dettach the MDF/LDF's then it would be to create BAK files?

    Is...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Are the posted questions getting worse?

    RBarryYoung (9/9/2009)


    GilaMonster (9/9/2009)


    GSquared (9/8/2009)


    jcrawf02 (9/8/2009)


    It's a shame they're not doing this with a laden swallow...

    Yes, but African swallows are non-migratory.

    They are? Or is that a Monty Python reference?

    Ouch! That's...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: What on earth is a Database Administrator Architect

    Jeff Moden (9/8/2009)


    Silverfox (9/8/2009)


    I am intrigued to know your Title though. As you have mentioned you are not titled as a DBA. :-P.

    Heh... "Sr. Turtle Furlong per Fortnight Counter"....

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/9/2009)


    GilaMonster (9/9/2009)


    GilaMonster (9/8/2009)


    Only in South Africa - http://pigeonrace2009.co.za/pigeon-race-2009

    My money's on the pigeon.

    The pigeon won. By a significant amount. The download was 4% complete by the time the pigeon...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Am I the only DBA

    Jeff Moden (9/9/2009)


    Perhaps you should also 😉

    I am always working :hehe:

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Question about creating a huge table in SQL Server

    Seth Lynch (9/9/2009)


    We are guessing what he may have meant but he may have meant...

    Creating a filegroup and adding files to that file group which exist on separate drives and...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Max connection for database

    Nice to know you solved your own problem, thanks for posting your solution 🙂

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Best/fastest way to move all the DB's

    krypto69 (9/9/2009)


    What is the fastest way to move two dozen DB's from one server to another server?

    well as long as you have latest backups for them. simpliest answer, is to...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Table listing for SSIS Package

    jfn (9/9/2009)


    Yes. I am hoping to be able to build some kind of table so I can track tables in each package I have.

    hmm, it might be possible to do...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Rebuilding of indexes

    Possibly not, but if possible I would have the step that you are having problems with, run in a period where you know there is nothing else running, that could...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Question about creating a huge table in SQL Server

    Animal Magic (9/9/2009)


    was he talking about partitioning? if so then yes that can greatly improve the performance of your database

    he didnt mention it, but if you have a large table,...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Rebuilding of indexes

    Are there any other sql jobs that run on that database anywhere near the time it failed, or any that might have either failed or over run.

    can you check to...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Rebuilding of indexes

    there are two things you could do now, one to check the windows event logs and see what else is running, or re-schedule your maintenance job + - 1 hour...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Restore fails with error 32

    Paul White (9/9/2009)


    Quinn (9/9/2009)


    I am just trying to restore from SSMS. From the context menu in databases.

    I see. ARe you able to rename the file from Windows explorer? ...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Question about creating a huge table in SQL Server

    Wayne (9/9/2009)


    Hello all,

    I need to create a huge table (more than 500 million rows and 50 columns) in SQL Server. One of my coworkers told me that I should split...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

Viewing 15 posts - 841 through 855 (of 1,136 total)