Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 18,926 total)

  • RE: DBA in Space

    Also can't. Sucks. Big time.

  • RE: DBA in Space

    GilaMonster (10/20/2011)


    Grant Fritchey (10/20/2011)


    Ian Massi (10/20/2011)


    The website for Space Adventures has a video that shows them testing the rocket they would use. Really impressive and seems to work well....

  • RE: Script

    the other answer is change management tracking. Which means new code is tested, saved and accessible with all the info you need.

  • RE: database size

    exec sp_spaceused

  • RE: Wide table performance issue

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


    rajiv.varma (10/20/2011)


    Oops..Bad math hits me again :D. You are right Ninja. Your count seems to be right.

    Maybe but your count can be right too.

    There's a point where you should...

  • RE: Query Optimization using Indexes

    ChrisM@Work (10/20/2011)


    Blimey! I've only ever found one bug in SQL Server, that was 5 years ago.

    It's not like it's a achievement I was striving for :hehe:.

  • RE: Query Optimization using Indexes

    ChrisM@Work (10/20/2011)


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


    adlakha.22 (10/20/2011)


    @ninja

    But from now i m not investing my time in reading and replying to ur post...

    😉

    19K+ points. ±5 threads started so far. 3 of them...

  • RE: Wide table performance issue

    rajiv.varma (10/20/2011)


    Oops..Bad math hits me again :D. You are right Ninja. Your count seems to be right.

    Maybe but your count can be right too.

    There's a point where you should be...

  • RE: Wide table performance issue

    rajiv.varma (10/20/2011)


    Yes. The SQL_POST_DATE is indeed a string. But the AW_POST_DATE is a datetime format column and using that too did not offer any performance improvement. As of now, I...

  • RE: Query Optimization using Indexes

    adlakha.22 (10/20/2011)


    @ninja

    But from now i m not investing my time in reading and replying to ur post...

    😉

    19K+ points. ±5 threads started so far. 3 of them still unanswered...

  • RE: Query Optimization using Indexes

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


    adlakha.22 (10/20/2011)


    @ninja

    I know in b/w 8 hours u r usually....see the posts read them...

    its lot of work to do...its very time consuming to read all the posts..

    I can understand

    Thanks

    For...

  • RE: DBA in Space

    bkubicek (10/20/2011)


    Ian Massi (10/20/2011)


    The website for Space Adventures has a video that shows them testing the rocket they would use. Really impressive and seems to work well. That...

  • RE: Query Optimization using Indexes

    adlakha.22 (10/20/2011)


    @ninja

    I know in b/w 8 hours u r usually....see the posts read them...

    its lot of work to do...its very time consuming to read all the posts..

    I can understand

    Thanks

    For giving...

  • RE: Database not marked as suspect

    1 last shot from me.

    Disconnect from that server and reconnect.

    If that doesn't "fix" it then I have no idea what is the problem.

    Gail is good with those weird trivias... maybe...

  • RE: Query Optimization using Indexes

    ChrisM@Work (10/20/2011)


    adlakha.22 (10/20/2011)


    what should i do? 🙁

    Run the tests, post the results.

    If there's no significant gain from my last suggestion, a gain which you're happy with, then Remi will...

Viewing 15 posts - 1,816 through 1,830 (of 18,926 total)