Forum Replies Created

Viewing 15 posts - 3,346 through 3,360 (of 5,678 total)

  • RE: The Job Posting - Do I really have to be the SQL God?

    tfifield (4/21/2011)

    Great article Craig! I've been put off by job postings that have the SQL God requirement in the past. I'll never look at job postings in 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

    April 21, 2011 at 12:49 pm

    #1314677

  • RE: Are the posted questions getting worse?

    jcrawf02 (4/21/2011)

    Personally, I learn a lot by being a wallflower in these kinds of conversations, so if it's not in the Thread but you are having it elsewhere, can 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

    April 21, 2011 at 12:02 pm

    #1314657

  • RE: Are the posted questions getting worse?

    GilaMonster (4/21/2011)

    jcrawf02 (4/21/2011)

    Personally, I learn a lot by being a wallflower in these kinds of conversations, so if it's not in the Thread but you are having it elsewhere, 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

    April 21, 2011 at 11:56 am

    #1314653

  • RE: Service Broker

    toddasd (4/21/2011)

    I've been reading about Service Broker with these questions lately and I still have a lot of questions on what exactly it is (even after reading BOL). Anyone here...

    - 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

    April 21, 2011 at 11:51 am

    #1314650

  • RE: Creating templates for use in BIDS (SQL Spackle)

    Very nice article Wayne, thank you. Perfect spackle.

    - 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

    April 21, 2011 at 11:44 am

    #1314647

  • RE: Are the posted questions getting worse?

    GilaMonster (4/20/2011)

    It's not. It's 1.6 seconds slower.

    Check your PM, I don't want to start a tech conversation in the thread. However yes, I have reasonable acquaintance with statistics. 🙂

    - 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

    April 21, 2011 at 2:24 am

    #1314362

  • RE: how to compare four columns and select only one column

    You'll have to unpivot the data, sort it desc, then select top 1 for each item.

    If you can provide a sample DDL/Data set like you'll find described in the first...

    - 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

    April 20, 2011 at 6:29 pm

    #1314272

  • RE: Are the posted questions getting worse?

    You know, this is why I'm never quite sure if I should write tech articles. No, I'm not looking for help per se, just bringing a personally amusing moment.

    So...

    - 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

    April 20, 2011 at 5:43 pm

    #1314268

  • RE: SSIS Package in Production Takes Way Too Long to Execute

    Aaron G (4/20/2011)

    I am running SS2K8 on a server with 4GB of RAM. I have an SSIS package that pulls in approximately 5,000,000 rows and does some very complex...

    - 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

    April 20, 2011 at 4:33 pm

    #1314257

  • RE: Convert to bigint

    2008 can do this natively with CONVERT options.

    The trick is to convert to VARBINARY in the middle with the style: 1

    Here's some sample code:

    DECLARE @hexStr VARCHAR(20),

    @hexBin varBINARY(20)

    SET @hexStr = '0x4158'

    SET...

    - 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

    April 20, 2011 at 4:22 pm

    #1314254

  • RE: NULL Dates

    LOOKUP_BI-756009 (4/20/2011)

    Craig & Michael, yup inserting a NULL in datetime clmn returns a NULL and empty string returned 1900-01-01 00:00:00.000.

    So what I need is to replace all 1900-01-01 00:00:00.000 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

    April 20, 2011 at 4:06 pm

    #1314252

  • RE: SSIS flat file import error

    Yeah, that's a fixed width file. Did you setup column widths in the advanced piece?

    - 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

    April 20, 2011 at 4:04 pm

    #1314251

  • RE: NULL Dates

    LOOKUP_BI-756009 (4/20/2011)

    I have a column of type datetime.

    Many of its value are NULL's but in the column it appears as 1900-01-01 00:00:00.

    I know that 1900-01-01 00:00:00 is the default for...

    - 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

    April 20, 2011 at 3:44 pm

    #1314247

  • RE: NULL Dates

    LOOKUP_BI-756009 (4/20/2011)

    Is there a way to replace NULL to a datetime column instead of 1900-01-01 00:00:00.000 for NULL dates ?

    I'm not quite sure I get the question. Can you rephrase...

    - 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

    April 20, 2011 at 3:24 pm

    #1314240

  • RE: How to pass today's date to a store procedure?

    DECLARE @today DATETIME

    SET @today = GETDATE()

    EXEC proc @MyDate = @today

    Can't send in a function as a value to a parameter.

    - 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

    April 20, 2011 at 2:57 pm

    #1314233

Viewing 15 posts - 3,346 through 3,360 (of 5,678 total)