Forum Replies Created

Viewing 15 posts - 5,251 through 5,265 (of 5,678 total)

  • RE: Are Differential db backups necessary to restore from trans logs backups?

    SkyBox (10/20/2010)

    Would like some other opinions on hourly intervals for the differentials. I agree with Pavan in the sense that this is the cleanest and quickest approach, but considering...

    - 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

    October 20, 2010 at 2:35 pm

    #1239942

  • RE: Memory on the SQL Server

    valeriepobeda (10/20/2010)

    What I am trying to understand is: I calculated all databases and I got 61586.55 MB in databases memory,on sql server max memory I have 8115 MB, on 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

    October 20, 2010 at 2:30 pm

    #1239936

  • RE: Alternate value in another row if requested row does not exist

    What GSquared is talking about and is a slightly different approach than what I mentioned would be something like this. It's just as valid and may or may 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

    October 20, 2010 at 2:19 pm

    #1239930

  • RE: Alternate value in another row if requested row does not exist

    GSquared (10/20/2010)

    Craig, I think you're overcomplicating it. The select I wrote could certainly be built into a view.

    Unless I seriously missed something, your code and his sample data will...

    - 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

    October 20, 2010 at 1:48 pm

    #1239899

  • RE: Alternate value in another row if requested row does not exist

    There's no simple way of getting this out of a view because the view won't easily be able to create data on the fly. I can see a way...

    - 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

    October 20, 2010 at 1:43 pm

    #1239895

  • RE: Triggers and Loops

    jrbass81 (10/20/2010)

    A lot of things I have read indicate that I should be processing all changes as set-based transactions, and that looping is BAD. But, I am trying 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

    October 20, 2010 at 1:13 pm

    #1239880

  • RE: Triggers and Loops

    Short Answer: DECLARE CURSOR

    Longer Answer: What are you trying to do? Most of the folks around here know many, many ways to avoid actual row loops and still get...

    - 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

    October 20, 2010 at 12:00 pm

    #1239849

  • RE: Where are the good Senior Level DBA's?

    Steve Jones - SSC Editor (10/19/2010)

    I think there's a little elitist mentality, but someone ought to know how to do this in scripting. It's much more efficient, especially when you...

    - 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

    October 20, 2010 at 11:22 am

    #1239837

  • RE: Are the posted questions getting worse?

    jcrawf02 (10/19/2010)

    CirquedeSQLeil (10/19/2010)

    jcrawf02 (10/19/2010)

    ...and, because I'm a complete and utter dork, it's almost 5, and I think it's funny, I'll repeat a poll I did at work today, assuming you...

    - 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

    October 19, 2010 at 3:53 pm

    #1239400

  • RE: Are the posted questions getting worse?

    Alvin Ramard (10/19/2010)

    jcrawf02 (10/19/2010)

    I can see how you'd miss that, as it's in the third sentence, and that's WAY too much to read....:w00t::-P:-D

    My input buffer filled up before I hit...

    - 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

    October 19, 2010 at 3:14 pm

    #1239378

  • RE: More efficient way

    sturner (10/19/2010)

    So you don't think I'm a grouch and since other did point a few of the more obvious problems, I will add that I see a lot of this...

    - 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

    October 19, 2010 at 11:34 am

    #1239232

  • RE: More efficient way

    It's basically the same query except for this:

    DATEDIFF(yy, Clients1.DOB, GETDATE()) >= 30 AND DATEDIFF(yy, Clients1.DOB, GETDATE()) <= 34

    which is buried deep in the middle of the thing.

    So, instead of doing...

    - 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

    October 19, 2010 at 11:15 am

    #1239219

  • RE: How to Handle Logins After Detaching database and Reattaching it To Another SQL Server Instance

    look into sp_change_users_login 'auto_fix', <loginname>, null after the reattach.

    It'll take the users in the dabatase and re-associate them with the server login SIDs.

    - 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

    October 19, 2010 at 10:26 am

    #1239182

  • RE: T-SQL for getting string function

    We're going to want to see expected results if we're going to try to figure this out for you, unfortunately. It's a little odd. Also, if you can...

    - 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

    October 18, 2010 at 4:12 pm

    #1238775

  • RE: comparing date datatypes in SQL Server

    Sandy2704 (10/18/2010)

    (TerminationDate is null) or ( '04/11/2010'< TerminationDate) and ('04/30/2010' <TerminationDate)

    even if the TerminationDate is 04/11/2005 it gives the pid corresponding to that TerminationDate

    It's because of the funkiness...

    - 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

    October 18, 2010 at 4:08 pm

    #1238773

Viewing 15 posts - 5,251 through 5,265 (of 5,678 total)