Forum Replies Created

Viewing 15 posts - 2,851 through 2,865 (of 5,678 total)

  • RE: Help! Dead Server, need to restore sql database.

    Adam Hills (7/1/2011)

    If you only have the mdf/ldfs to work with, you're in a recovery scenario and I'll see if I can find you some good walkthrough links.

    This looks like...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    July 1, 2011 at 3:45 pm

    #1347366

  • RE: A Little Interviewing Advice

    sturner (7/1/2011)

    Freddie-304292 (7/1/2011)

    But I know I wouldn't fit in with any company that expected people to come in for a full day interview, and would turn them down flat. Remember...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    July 1, 2011 at 2:53 pm

    #1347354

  • RE: Are the posted questions getting worse?

    GilaMonster (7/1/2011)

    Thanks everyone. Wasn't actually planning on announcing it here.

    Fine then, one billboard coming up to announce it elsewhere.

    EDIT: Sorry, that was too big.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    July 1, 2011 at 1:46 pm

    #1347309

  • RE: How can i downgrade database from Higher Version of (Sql Server 2008 R2) to Lower Version of (SQL server2008)

    You don't.

    It's not built to be backwards compatible once you've moved a database to a higher engine.

    Rescript all the components, run said scripts on previous version, create SSIS package of...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    June 30, 2011 at 8:53 pm

    #1346838

  • RE: Running Total Issue - ANything New On this Aside from Jeff Modens "Quirky Update"?

    Jeff Moden (6/30/2011)

    I don't know if it'll make people feel any better about the "Quirky Update" but Tom Thompson and Paul White added a couple of things to it to...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    June 30, 2011 at 8:51 pm

    #1346836

  • RE: Runaway Transaction Log Growth

    sswords (6/30/2011)

    My hovercraft is full of eels.

    Apparently so is your log file. Hrm.

    Out of curiousity, can you pull the VLF information for us?

    DBCC LOGINFO('MyDB')

    I'm not sure it'll help but...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    June 30, 2011 at 3:45 pm

    #1346793

  • RE: Least Privilege Account

    bubs (6/30/2011)

    By removing the Integrated Security=false and adding in Trusted_Connection=yes resolved the connection issue.

    That seems to all be working fine now. Now on to some encryption questions.. 🙂

    There are definitely...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    June 30, 2011 at 3:40 pm

    #1346792

  • RE: Running Total Issue - ANything New On this Aside from Jeff Modens "Quirky Update"?

    hwells (6/30/2011)

    Craig Farrell (6/30/2011)

    The Running Totals issue in SQL is that it's really a presentation layer thing, not a SQL thing, which is why it causes such issues.

    Craig, would...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    June 30, 2011 at 3:28 pm

    #1346786

  • RE: Varchar to Numeric conversion error.

    You can't guarantee the order of events in a query without FORCE ORDER, so what's happening is something is trying to get through the convert that you eventually weed out...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    June 30, 2011 at 3:10 pm

    #1346771

  • RE: Advice for a very nervous first time consultant

    What Elliott mentions about being the hired gun is important here. You need to be careful about your phrasing. "This obviously grew out of its original scope." vs....

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    June 30, 2011 at 3:08 pm

    #1346769

  • RE: A Little Interviewing Advice

    djackson 22568 (6/30/2011)

    Not only that, but employers tend to talk about valuing teamwork, but do everything they can to destroy it. Best example - everyone gets the same raise,...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    June 30, 2011 at 3:01 pm

    #1346766

  • RE: Running Total Issue - ANything New On this Aside from Jeff Modens "Quirky Update"?

    YSLGuru (6/30/2011)

    If one is trying to produce output that includes a running total or running balance and the "quirky Update" method from Jeff Moden is not an option and you're...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    June 30, 2011 at 2:51 pm

    #1346759

  • RE: Help! Dead Server, need to restore sql database.

    Adam Hills (6/29/2011)

    Unfortunately, we haven't got any backup agents/programs installed, so Craig is correct. I'll take a log at the drive tomorrow and let you know if I can find...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    June 29, 2011 at 4:06 pm

    #1346282

  • RE: Help! Dead Server, need to restore sql database.

    Adam Hills (6/29/2011)

    I can get a backup of the dbs from the program files/sql server/data folder or do you mean the ntbackup?

    I have that on a network storage device which...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    June 29, 2011 at 3:52 pm

    #1346275

  • RE: Runaway Transaction Log Growth

    Just a 'is it plugged in' kind of question first:

    The actual database size is about 28 Gigs, but my nightly full backups are about 50 gigs.

    What recovery mode is the...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    June 29, 2011 at 3:48 pm

    #1346272

Viewing 15 posts - 2,851 through 2,865 (of 5,678 total)