Forum Replies Created

Viewing 15 posts - 13,606 through 13,620 (of 22,213 total)

  • RE: Unusual backup/restore scenario

    I agree. It sounds like you're in a situation where replication would work better.

    As far as Red Gate's SQL Backup goes, yes, you can restore objects and rows if you're...

  • RE: Are the posted questions getting worse?

    SQLkiwi (1/13/2011)


    Grant Fritchey (1/13/2011)


    Thank you very much. I've already shot this one in the head. I was working off a bad notion of how heaps are stored, so the whole...

  • RE: cpu bottleneck

    Koen (da-zero) (1/13/2011)


    Grant Fritchey (1/13/2011)


    Koen (da-zero) (1/12/2011)


    TheSQLGuru (1/12/2011)


    I am curious what you mean by "advisor" here. Hopefully you do NOT mean Database Tuning Advisor!! Avoid that like the...

  • RE: cpu bottleneck

    Koen (da-zero) (1/12/2011)


    TheSQLGuru (1/12/2011)


    farax_x (1/12/2011)


    Check queries that have high cpu usage using activity moitor, then by thinking on execution plan u can solve problem. sql profiler + advisor may also...

  • RE: New functionalities in SQL Server 2008

    Koen (da-zero) (1/12/2011)


    siamak.s16 (1/12/2011)


    Lets not forget Intellisense 😀

    I'm not always convinced it is an improvement 🙂

    Not when you compare it to Red Gate's SQL Prompt it isn't.

    Same thing in Denali,...

  • RE: Future Forecast for performance

    sql_butterfly (1/13/2011)


    Gila, But i think that would be pretty good idea to do future forecasting for performance. Analyzing those execution plans can tell a lot of story.

    Any alternative ways to...

  • RE: Are the posted questions getting worse?

    SQLkiwi (1/12/2011)


    Grant Fritchey (1/12/2011)


    Anyone interested in reading a short blog post? I'm a little nervous about putting this one up. I'm talking about how heaps are stored and I've made...

  • RE: Are the posted questions getting worse?

    WayneS (1/12/2011)


    Stefan Krzywicki (1/12/2011)


    I'm just outside Boston, we're certainly snowed in here.

    How much did you get?

    Grant / Adam - how much did you'll get?

    I don't know what the official number...

  • RE: cpu bottleneck

    I would not push Advisor as a choice for improving performance.

  • RE: Does Server service need to be running to enable FILESTREAM

    berg.ec (1/12/2011)


    Grant Fritchey (1/12/2011)


    If you go into configuration manager for the instance in question and open the properties for that instance, you can't enable FILESTREAM on the appropriate tab? It...

  • RE: Are the posted questions getting worse?

    WayneS (1/12/2011)


    Grant Fritchey (1/12/2011)


    Anyone interested in reading a short blog post? I'm a little nervous about putting this one up. I'm talking about how heaps are stored and I've made...

  • RE: Does Server service need to be running to enable FILESTREAM

    If you go into configuration manager for the instance in question and open the properties for that instance, you can't enable FILESTREAM on the appropriate tab? It sounds like it...

  • RE: View question

    It kind of depends on what you're doing with the view because the optimizer is pretty smart about their use. But when you start talking about JOINs with a view......

  • RE: Are the posted questions getting worse?

    Anyone interested in reading a short blog post? I'm a little nervous about putting this one up. I'm talking about how heaps are stored and I've made mistakes there in...

  • RE: Performance between union of table valued functions

    TheSQLGuru (1/12/2011)


    I advise my clients to avoid ALL UDFs of ALL flavors simply because there are WAY too many ways to get in trouble with them.

    Proof positive that you're a...

Viewing 15 posts - 13,606 through 13,620 (of 22,213 total)