Forum Replies Created

Viewing 15 posts - 3,046 through 3,060 (of 18,926 total)

  • RE: Yeah! my first real corrupt DB

    Reposting a private e-mail from wayne with interesting test results.

    P.S. @Wayne Don't waste too much time on 6.5 I was mostly curious about a behavior change between 2k and...

  • RE: Yeah! my first real corrupt DB

    Brandie Tarvin (8/26/2011)


    FYI: I can reproduce both bugs (Remi's and Paul's) in SQL 2008 SP1. I've added my votes and comments to the Connect items.

    Thanks.

  • RE: Non-clustered indexes

    jwbart06 (8/25/2011)


    Not my intention.

    Be careful, some of them are helpers on this forum!

    Sorry, but the exams are frustrating, that is why they are exams. 😎

    I am here to learn.

    Hey I...

  • RE: Bad performance. EXECSYNC wait type?

    Colleen M. Morrow (8/25/2011)


    Thanks. I saw that, but it didn't really clarify anything for me. 🙂

    We're not using LOBs in this database. Can you explain what, exactly,...

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/25/2011)


    Ninja's_RGR'us (8/25/2011)


    Roy Ernest (8/25/2011)


    I was trying my level best to hit 3K posts before the THREAD hits 30K. Till yesterday evening I was doing good. From yesterday evening to...

  • RE: UPDATE Way Too Slow

    dan-572483 (8/25/2011)


    Yes, the column is indexed, it is not the primary key. The table has 513 rows and only one is updated by the query. The estimated...

  • RE: Non-clustered indexes

    jwbart06 (8/25/2011)


    Cool, I will do that.

    Weird thing is the column name is lastName as an nvarchar(max).

    So I could just assume the lastname will never be 2gb long, but it could...

  • RE: Bad performance. EXECSYNC wait type?

    That's the definition I can get from MS, not sure if it actually helps.

    Occurs during parallel queries while synchronizing in query processor in areas not related to the exchange iterator....

  • RE: Are the posted questions getting worse?

    Roy Ernest (8/25/2011)


    I was trying my level best to hit 3K posts before the THREAD hits 30K. Till yesterday evening I was doing good. From yesterday evening to till now,...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/25/2011)


    Ninja's_RGR'us (8/25/2011)


    What's 100% of 0?

    You see why she's not in the top 10 yet :-D.

    OhHo!

    Look at you talkin' smack about me. Better watch it, Ninja, or I will...

  • RE: Non-clustered indexes

    You can CREATE it.

    You'll get a warning which says that if you have more than 900 bytes in your data, the insert / update will fail.

    Quite easy to test if...

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (8/25/2011)


    Brandie Tarvin (8/25/2011)


    Stefan Krzywicki (8/25/2011)


    Brandie Tarvin (8/25/2011)


    SQLRNNR (8/25/2011)


    I think you should submit a question that has "It Depends" as an answer. But that choice should be wrong.:-D

    Which...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/25/2011)


    Whoot!

    Space Tramps is going to be available for order through your local bookstore when it comes out next month.

    I HAVE ARRIVED!!!! Finally, a book I've written for that...

  • RE: Back in the saddle

    brandon.leach (8/25/2011)


    Ninja's_RGR'us (8/25/2011)


    My job description is simple.

    Get in here, butt in chair & and make sure that stuff works.

    They don't care about the acronyms!

    I work for a...

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (8/25/2011)


    Brandie Tarvin (8/25/2011)


    SQLRNNR (8/25/2011)


    I think you should submit a question that has "It Depends" as an answer. But that choice should be wrong.:-D

    Which is the correct color...

Viewing 15 posts - 3,046 through 3,060 (of 18,926 total)