Forum Replies Created

Viewing 15 posts - 10,816 through 10,830 (of 22,213 total)

  • RE: SQL Server 2012 Future...

    Not entirely sure what you mean by the question, but one of the coolest new pieces of technology to come with SQL Server 2012 is the AlwaysOn Availability Groups. You...

  • RE: Does studying a Masters give you an edge in the employment stakes?

    In the US, in certain fields, it will absolutely help. But overall, no, it won't help your technology career that much. If you were just getting started and I were...

  • RE: Database OPTIMIZATION

    Nope. Sorry, nothing but hard work in front of you to make a database run faster. Check out my book on query tuning.

    Or, you can buy really big servers. Throwing...

  • RE: backup software

    Just an aside, instead of relying on backups for stored procedures, triggers, and other structural pieces of the database, I'd get all that code into a source control system.

  • RE: automate db backup

    Do you already have a backup process in place? Have you verified that your backups work? That means have you tested a restore? I'd start there as step one of...

  • RE: How do I decide if current hardware configuration is good enough for SQL server ?

    pages/sec is just an indication of load. You don't know if it's high or low until you get a baseline to compare it to.

  • RE: Never, Ever Use Clustered Indexes

    patrickmcginnis59 (5/31/2012)


    Grant Fritchey (5/31/2012)


    patrickmcginnis59 (5/31/2012)


    Grant Fritchey (5/31/2012)

    I'm with you. Fast enough is fast enough.

    But, I remember when a friend of mine (wish I could say I did this) spotted a...

  • RE: Never, Ever Use Clustered Indexes

    patrickmcginnis59 (5/31/2012)


    Grant Fritchey (5/31/2012)

    I'm with you. Fast enough is fast enough.

    But, I remember when a friend of mine (wish I could say I did this) spotted a problematic query in...

  • RE: Never, Ever Use Clustered Indexes

    donnapatriciakelly (5/31/2012)


    Coming late to this, but a couple of thoughts, if I may?

    I work in the Business Intelligence area, and deal with all sorts of source systems. Getting data...

  • RE: Never, Ever Use Clustered Indexes

    jfogel (5/31/2012)


    patrickmcginnis59 (5/31/2012)


    Grant Fritchey (5/31/2012)


    TravisDBA (5/31/2012)


    Sorry about that. I was trying to make the point that "generic" database designs aren't really possible due to the nature of the underlying infrastructure....

  • RE: Never, Ever Use Clustered Indexes

    Chris.C-977504 (5/31/2012)


    Grant Fritchey (5/31/2012)


    ...I was trying to make the point that "generic" database designs aren't really possible due to the nature of the underlying infrastructure. Clearly failed.

    Well you didn't completely...

  • RE: DB Locking

    Rog Saber (5/31/2012)


    I guess the main problem is that it locks up the system for a long time. Within our application, the system will hang for about 10 minutes when...

  • RE: Never, Ever Use Clustered Indexes

    TravisDBA (5/31/2012)


    Sorry about that. I was trying to make the point that "generic" database designs aren't really possible due to the nature of the underlying infrastructure. Clearly failed.

    I'm a little...

  • RE: Never, Ever Use Clustered Indexes

    Chris.C-977504 (5/31/2012)


    I almost flipped the bozo bit before I got to the fourth paragraph.

    Now that I've read the whole article, I'm really not clear what your message is.

    FWIW,

    ...

  • RE: What motivates those of you who answer questions?

    A few reasons:

    * I've got the "helper" gene. I try to pitch in & help out. Can't stop.

    * It's a great way to learn how to do stuff

    * I learn...

Viewing 15 posts - 10,816 through 10,830 (of 22,213 total)