Forum Replies Created

Viewing 15 posts - 1,651 through 1,665 (of 18,926 total)

  • RE: Are the posted questions getting worse?

    Tom Brown (10/27/2011)


    Thanks for the comments Craig

    ?? II's :unsure: Whats an II? (Some DBA shorthand for developers perhaps Ignorant Idiots?, Itinerant Interns? Infernal Irritants? )

    Maybe I'm one as I'm...

  • RE: Non-Clustered Indexes and Truncated Tables

    ... and since 100% of the data has been changed in that table, the stats will be updated when the first select runs on that table. So those will...

  • RE: Selective restore

    GilaMonster (10/27/2011)


    mike.jean17 (10/27/2011)


    yap u r right and i am 100% agree with u ......

    Ignore the spam, it's reported.

    At least SOME people try to enter the conversation.

    (Am I really complaining about...

  • RE: Please Help !!!!

    Hey Jeff, actually "xxxxxxxxxxx@gmail.com" is a real mail :-D.

    I guess we're running out of those too!

  • RE: Please Help !!!!

    Well at least he's honest and wants to learn. That says a lot about him :-).

  • RE: Selective restore

    Then take a test db and test server and test.

    No it doesn't overwrite and then rename. It just builds an entirely new version of the db at the time...

  • RE: Massive IOs!

    GilaMonster (10/27/2011)


    TheSQLGuru (10/27/2011)


    In any case I am not actually "in the running" for this non-job consulting gig either. I am (very thankfully) over-booked for months out.

    I wish...

  • RE: How to specify multiple integer values in Report Parameter

    You can't.

    A list is a series of entries.

    Not 1 entry with all the values.

    I'm sure there's a way around that but that wouldn't be by the book.

  • RE: Massive IOs!

    TheSQLGuru (10/27/2011)


    Ninja's_RGR'us (10/27/2011)


    GilaMonster (10/27/2011)


    Ninja's_RGR'us (10/27/2011)


    Don't you love the smell of backstabbing in the morning? 🙂

    Note to the <non hiring> op. Both these 2 seem to love using knives...

  • RE: How to specify multiple integer values in Report Parameter

    I usually do this the other way around

    ALL = NULL

    Then all the values.

    If all is selected I just disregard that filter.

  • RE: Selective restore

    Use the GUI.

    Right click restore on the prod db.

    Then change the name of the db, then file location.

    Then put the point in time to stop at a couple hours before...

  • RE: Selective restore

    Yes you can restore to a new name (and hd location obviously).

    If the db is in full mode you can even take a log back and restore to a point...

  • RE: Massive IOs!

    GilaMonster (10/27/2011)


    Ninja's_RGR'us (10/27/2011)


    Don't you love the smell of backstabbing in the morning? 🙂

    Note to the <non hiring> op. Both these 2 seem to love using knives while I...

  • RE: Massive IOs!

    JOKE =>

    Don't you love the smell of backstabbing in the morning? 🙂

    Note to the <non hiring> op. Both these 2 seem to love using knives while I don't...

  • RE: DETA recommendations..whats my next step?

    You'll just need it again next time you rebuil.

    Unless you're short on hd space leave it as is.

    Shrink + growth + shrink + growth = physical file fragmentation.

    If you know...

Viewing 15 posts - 1,651 through 1,665 (of 18,926 total)