Forum Replies Created

Viewing 15 posts - 4,126 through 4,140 (of 5,678 total)

  • RE: Single PROC / 3 Conditions / Multiple AND's with IF statement

    Rich Yarger (2/6/2011)


    Hi Craig -

    CalcBalance1 is the leftover debt. It's also the new balance for the originating account. I guess I have it wrong. I thought...


    - 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

  • RE: Query performance change after database refresh

    Check for lock concurrency issues at production, might be running into other processes.

    When you run the task on QA, does the first run also take 10-11 seconds, and the later...


    - 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

  • RE: Single PROC / 3 Conditions / Multiple AND's with IF statement

    DECLARE @CalcBalance1 MONEY = (SELECT CurrentBalance FROM Account WHERE AccountID = @AccountID)

    DECLARE @OverDraftAccountID1 INT = (SELECT OverDraftAccountID FROM Account WHERE AccountID = @AccountID)

    DECLARE @ODBalance MONEY = (SELECT CurrentBalance FROM Account...


    - 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

  • RE: Where are you?

    An Antartican Penguin Safari (in summer, too damned cold in general).

    Why? Because it's just funny.

    "What'd you do over summer?"

    "Penguin Hunt. Check the trophy wall."

    "Dude, look at...


    - 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

  • RE: Are the posted questions getting worse?

    WayneS (2/4/2011)


    If you wonder about not seeing me for a week, it's because you're not going to be seeing me for a week.:-) Keep safe, cool, (and for Craig, hot).

    I...


    - 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

  • RE: Accidentally set max server memory to 0

    simon.wardlaw (2/4/2011)


    Thanks for the reply. Have started the service in single user mode with -f;-m"SQLCMD"; however login fails when connecting through sqlcmd. I'm working on the console and loged in...


    - 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

  • RE: RAID & Filegroup Stategy for a new SQL Server 2005 system

    Rich Yarger (2/4/2011)


    Now - by this do you mean that the RAID 5 structure for the Filegroups should be replicated if for some reason this system acquires more db's over...


    - 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

  • RE: RAID & Filegroup Stategy for a new SQL Server 2005 system

    Rich Yarger (2/4/2011)


    I'm so grateful for this little chat of ours. Can you tell I am a new DBA?

    😛

    Perhaps new, but well spoken and you bring your own research...


    - 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

  • RE: RAID & Filegroup Stategy for a new SQL Server 2005 system

    TempDB and C:\....

    Not usually a good idea, unless this server is incredibly robust and they're just being cheap on disks. If you end up needing the swapfile, which is...


    - 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

  • RE: RAID & Filegroup Stategy for a new SQL Server 2005 system

    Rich Yarger (2/4/2011)


    ... 🙂 Or just build yourself a nice little SSIS package that will foreach file loop the backup directories and move them where you like... and include...


    - 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

  • RE: RAID & Filegroup Stategy for a new SQL Server 2005 system

    Rich Yarger (2/4/2011)


    YES!!! Great idea!!! I can set the routine up to send it all over to the C:\DRIVE and then use the Windows Task Manager to do...


    - 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

  • RE: Random Recipes

    Tom Brown (2/4/2011)


    Tonight's menu

    10 START

    20 Open can of John Smiths

    30 Drink

    40 GOTO 20

    ... Crash ...

    Must be Friday!


    - 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

  • RE: RAID & Filegroup Stategy for a new SQL Server 2005 system

    Rich Yarger (2/4/2011)


    Hi Craig -

    No - your evaluation hit the nail on the proverbial head! I appreciate it, and would have loved to have gone with an idea...


    - 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

  • RE: Are the posted questions getting worse?

    Tom.Thomson (2/4/2011)


    What you are calling an ice age is properly called "a glacial period" and an interglacial the period between two consecutive glaicial periods within the same ice age, not...


    - 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

  • RE: RAID & Filegroup Stategy for a new SQL Server 2005 system

    Rich Yarger (2/4/2011)


    Hi Craig -

    The RAID 5 Array is composed of a 4x146gb Array. The disk IO in this array is pure data, and some non-clustered indexing to go...


    - 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

Viewing 15 posts - 4,126 through 4,140 (of 5,678 total)