Forum Replies Created

Viewing 15 posts - 4,456 through 4,470 (of 5,678 total)

  • RE: convert military time to standard time

    I think it's because of where you're including the replicated 0's.

    This will work:

    DECLARE @MilDate VARCHAR(20)

    SET @MilDate = '13:38'

    SET @MilDAte = REPLACE( @MilDate, ':', '')

    SELECT @MilDate

    SET @MilDate = LEFT( @MilDate +...

    - 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

    January 6, 2011 at 4:49 pm

    #1270369

  • RE: High work_queue_count and THREADPOOL WAITS

    I would agree that turning down parallelism should help with the worker starvation.

    One other thing about VM boxes that I recently ran into is that you will want to talk...

    - 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

    January 6, 2011 at 4:18 pm

    #1270366

  • RE: UniqueIdentifiers

    Try using CAST( nTextField AS nVARCHAR(MAX)) = uniqueIDField.

    It'll run like a three legged dog, but it should run.

    - 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

    January 6, 2011 at 2:55 pm

    #1270345

  • RE: Are the posted questions getting worse?

    mtillman-921105 (1/6/2011)

    Zero, the way that we're discussing it, is more than just a placeholder - it means nothing. Spaces used to be used as placeholders, but, to me, that's...

    - 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

    January 6, 2011 at 12:50 pm

    #1270302

  • RE: unique Index for existing table with duplicates

    WebTechie38 (1/6/2011)

    Hello,

    What would be the best approach to make to create the unique index and get rid of the duplicates?

    I'd start with getting a straight count on the number 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

    January 6, 2011 at 12:36 pm

    #1270290

  • RE: Are the posted questions getting worse?

    mtillman-921105 (1/6/2011)

    Tom, in a conceptual way I sort of get the fact that zero divided by any other (real) number equals zero. But logically, I don't know why we...

    - 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

    January 6, 2011 at 12:30 pm

    #1270287

  • RE: Interview

    GSquared (1/6/2011)

    I dug around with a search engine a bit, and "sev3/sev4" refers to software support "severity level". There aren't standard definitions, but it appears that the higher 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

    January 6, 2011 at 12:16 pm

    #1270278

  • RE: Update Multiple Rows

    martin.edward (1/6/2011)

    The update values are dynamic and not fixed as such.

    You missed some of Todd's sarcasm in that. You've given us very little to work from in terms 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

    January 6, 2011 at 12:08 pm

    #1270270

  • RE: Trust People

    TravisDBA (1/6/2011)

    Eric Russell 13013 (1/6/2011)

    We can't expect a good result simply by wrapping process around un-trustworthy people. The fast food and financial industry have proven that. More can be done...

    - 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

    January 6, 2011 at 12:05 pm

    #1270266

  • RE: sp_send_dbmail fails in SQL Server Agent Job

    JayK (1/5/2011)

    Eureka! So I finally solved the issue - just by trail and error.

    When I set the 'Run as user' to 'dbo' in the Job Step it runs without an...

    - 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

    January 6, 2011 at 11:36 am

    #1270236

  • RE: Interview

    GilaMonster (1/6/2011)

    Craig Farrell (1/6/2011)

    Best way to start that research is get yourself a small partition on a drive (usually your C:\ is smaller), create a database, and fill...

    - 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

    January 6, 2011 at 11:26 am

    #1270227

  • RE: Interview

    vk24/7 (1/6/2011)

    Craig,

    I have not copied these q's from any site, these are the questions i was asked in the interview. I'm a newbie to this site and this is my...

    - 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

    January 6, 2011 at 11:24 am

    #1270225

  • RE: Are the posted questions getting worse?

    WayneS (1/6/2011)

    jcrawf02 (1/6/2011)

    WayneS (1/6/2011)

    Edit3: I'd like to go, if for no other reason than to hang out with Brent and Tim for a week and to be able to absorb...

    - 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

    January 6, 2011 at 11:14 am

    #1270222

  • RE: Please help with SQL code

    pwalter83 (1/6/2011)

    Hi Harinerella,

    Thanks for your reply. However, I dont know what you mean by CTE ?

    CTE is a common table expression. It's a pretty way to write a subquery....

    - 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

    January 6, 2011 at 11:09 am

    #1270219

  • RE: Are the posted questions getting worse?

    Koen (da-zero) (1/6/2011)

    Craig Farrell (1/5/2011)

    Of course, if you really want to mess with your own head, you can always assume because of graph charts and the like that -infinity =...

    - 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

    January 6, 2011 at 12:41 am

    #1269897

Viewing 15 posts - 4,456 through 4,470 (of 5,678 total)