Forum Replies Created

Viewing 15 posts - 481 through 495 (of 18,926 total)

  • RE: Rollback data

    prashant-507002 (12/9/2011)

    Restore database is one option but we have no rights for that and also it data centre server and they charge for space

    You can restore to your local...

    December 9, 2011 at 6:58 am

    #1419312

  • RE: Today's Random Word!

    Daniel Bowlin (12/9/2011)

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

    SQLRNNR (12/8/2011)

    L' Eomot Inversé (12/8/2011)

    Cadavre (12/8/2011)

    Boo, missed that 😛

    Here's my fixed version: -

    <code snipped>

    Drat, I missed out 6 casts ("0" changed to "cast(cast 0 as datetime) as...

    December 9, 2011 at 6:57 am

    #1419309

  • RE: if more than 10000 txns are coming than that should go to CPU2.

    GilaMonster (12/9/2011)

    Can you be a little more specific?

    Can't be less specific, so that would be a yes :hehe:

    /joke.

    December 9, 2011 at 5:03 am

    #1419228

  • RE: Severe Performance Problem

    Divine Flame (12/9/2011)

    steve.clark 39713 (12/9/2011)

    the database grows by 1Gb a day and has done for the last couple of years, so nothing new on that front. The server isn't...

    December 9, 2011 at 5:02 am

    #1419227

  • RE: Severe Performance Problem

    Taking stabs in the dark here.

    Isolation level changed?

    +1000 on the bloody good consultant idea. Might be nothing, might be a whole lot harder than nothing to find to.

    #1 option...

    December 9, 2011 at 4:59 am

    #1419224

  • RE: update a huge data in one query.

    +1 on it's a bad design. Stop the headache right now and learn how to do concatenation when you present the data. NOT when you save it.

    December 9, 2011 at 4:49 am

    #1419212

  • RE: Executing query

    joeknas (12/8/2011)

    Thanks a lot.

    It works now 🙂

    Joe

    I know it works, I'm self-quoting because you're not answering my question!

    December 8, 2011 at 11:46 am

    #1418879

  • RE: Any suggestion when batch requests reaches about 1000/sec, ?

    logicinside22 (12/8/2011)

    trying to find out to minimize the batchrequest/sec .Some times it goes very high.

    This counter is not useful all by itself.

    100% cpu, very useful. 1000 requests sec, completely...

    December 8, 2011 at 11:34 am

    #1418869

  • RE: corrupt going from 2000 to 2008

    CHECKDB was extremelly enhanced between 2000 and 2005. There's a joke going around that this was the reason for the 5 years between releases.

    December 8, 2011 at 11:31 am

    #1418864

  • RE: Executing query

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

    P.S. Why are you trying to learn sql 7? Sql 12 is coming out in the next few months!!

    December 8, 2011 at 11:26 am

    #1418857

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/8/2011)

    So with this Redmond report about IT losing jobs this year, and possibly next year, how upbeat or pessimistic are you feeling about the industry?

    It's hardly any...

    December 8, 2011 at 11:26 am

    #1418855

  • RE: Transaction Log on its own disk. How to...and performance gains. Please help.

    dale.schwabjr (12/8/2011)

    Thanks all for your help thus far, troubleshooting the performance issues is one thing...and I get that.

    Still have the questions regarding

    1. Would it have better performance putting the...

    December 8, 2011 at 11:13 am

    #1418844

  • RE: Today's Random Word!

    SQLRNNR (12/8/2011)

    L' Eomot Inversé (12/8/2011)

    Cadavre (12/8/2011)

    Boo, missed that 😛

    Here's my fixed version: -

    <code snipped>

    Drat, I missed out 6 casts ("0" changed to "cast(cast 0 as datetime) as date)" in three...

    December 8, 2011 at 11:11 am

    #1418842

  • RE: Executing query

    If the table was created then it's there.

    Are you sure you are pointing to the correct server?, DB?

    Are you trying to access that table from the same login (might be...

    December 8, 2011 at 11:08 am

    #1418839

  • RE: update a huge data in one query.

    Why do you save your data like that? It's certainly NOT standard.

    December 8, 2011 at 10:45 am

    #1418825

Viewing 15 posts - 481 through 495 (of 18,926 total)