Forum Replies Created

Viewing 15 posts - 4,171 through 4,185 (of 5,678 total)

  • RE: Some questions related to database administration

    If you don't mind a little self promotion, I've written an article for people in your position here[/url].

    It's an overview of the industry. Now, to answer your question about...


    - 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: Using GETDATE() in the where clause and in joins

    george sibbald (2/3/2011)


    would not the fact that a function is being used for the join mean this is not SARGable and therefore this would always table scan?

    It's SARGable, the functions...


    - 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: I cannot understand these codes

    Brandie Tarvin (2/2/2011)


    Craig Farrell (2/1/2011)


    Brandie Tarvin (2/1/2011)


    Craig, you've got me confused now. What part of that equation changes the days from the 1st to the 3rd?

    The +2 part at 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

  • RE: Sell Vs Buy Query help

    sturner (2/3/2011)


    This sounds like a homework problem.

    I am not trying to be mean, really, but you are paid (I assume) to solve these kinds of basic query problems. Try 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

  • RE: ForEach Loop and an ADO Recordset

    Jeff Moden (2/3/2011)


    Thanks for the feedback, Craig. Yep... not that it matters but I agree with that justification. Please understand that, considering the source, I just had 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

  • RE: Need the Price with the Latest Date

    tfifield (2/2/2011)


    At some point as the number of rows increase within the partition the CROSS APPLY will start to pull away from either MAX or ROW_NUMBER() since it will seek...


    - 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: .mdf file currupt

    sourav_1002001 (2/2/2011)


    thanks for the post. Is that got currupt due to bad sector of HDD, because i have recovered this data file from a damaged HDD. So is there any...


    - 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: From DBA / Dev to Management

    Brandie Tarvin (2/2/2011)


    Next question:

    How did you half-management / half-DBA types deal with the overload of DBA tasks?

    I.E., say there's too much workload for the DBA team to handle 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: Need the Price with the Latest Date

    TheSQLGuru (2/2/2011)


    MAX DATE method has one downside though - you can get duplicate output if more than one record has the same MAX DATE. This should not happen with...


    - 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: How's This Trigger?

    Auto, this usually isn't something you want to control at the trigger level unless you absolutely have to deal with dynamic SQL coming off a front end application. Are...


    - 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: Convert to mm/dd/yyyy

    Use BOL and look up the available formats to the CONVERT function.


    - 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: Attaching generic sample properties to multiple readings

    loki1049 (2/1/2011)


    I have had constant issues with my boss on proper database design. He is constantly saying that everything belongs in one table. That way apparently he can just look...


    - 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: From DBA / Dev to Management

    Brandie Tarvin (2/1/2011)


    I'm curious. Has anyone made the move from DBA / Developer up to management (team size doesn't matter)?

    If so, what were your experiences and thoughts on the experience?...


    - 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: From DBA / Dev to Management

    The reason BI can be a better path to management is twofold. One, you learn more about the goals of the company by understanding what they research and their...


    - 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: Administering older versions of SQL

    DTS and SSIS are the biggest problems that stand out that you'll need multiple environments to deal with. There's emulators you can run to get into DTS from 2k5,...


    - 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,171 through 4,185 (of 5,678 total)