Forum Replies Created

Viewing 15 posts - 41,626 through 41,640 (of 59,102 total)

  • RE: not null column is taking empty data

    It's easier than that. To reject things that are either blank or null in VARCHAR columns, you simply need to check for anything greater than a blank...

    WHERE somecolumn >...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 3:59 pm

    #1063133

  • RE: Opportunities are less for SQL DBAs.?

    Any kind of job is scarce right now. If you log onto "Michigan Works" and take a look, there are more than 1.2 million resumes available for a bit...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 3:50 pm

    #1063128

  • RE: .fmt and Bulk Insert importing Bad Data

    dzirkelb (10/7/2009)

    I am importing a .fmt for a bulk insert, but, it is causing the data to be incorrect. here is the .fmt file:

    8.0

    12

    1SQLCHAR0255"\t"1Allied ""

    2 SQLCHAR 0 255 "\t"...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 3:44 pm

    #1063125

  • RE: Are the posted questions getting worse?

    Roy Ernest (10/7/2009)

    The recoil usually is pretty strong and your 12 yr old can handle that. And still hit a clay pigeon.

    10 year old, 12 guage gun.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 3:36 pm

    #1063119

  • RE: SQL & the JOIN Operator

    Andy DBA (10/7/2009)

    SuperDBA-207096 (10/7/2009)

    Wagner,

    You might want to mention in the:

    "Excluding the Intersection of the Sets" section this is similar to

    select... where not in (select... from table2) but it performs...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 3:08 pm

    #1063104

  • RE: CPU Usage Reported By Profiler

    Chris Howarth-536003 (10/7/2009)

    We had a similar problem last year with CPU usage - when the CPU usage was high we found that Windows would randomly complain of 'insufficient resources' when...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 3:05 pm

    #1063102

  • RE: SQL & the JOIN Operator

    Heh... of course, I will admit that, no matter which method someone uses to identify the column/table relationships, just about anything would be better than a format like the following...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 2:21 pm

    #1063069

  • RE: A little off topic

    Wow. "Brilliant" is an understatement.

    Try the following...

    Select "Field[1]" from

    ... then find the Developer, the Manager, and the DBA that allowed the brackets and see if they like porkchops... at...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 2:13 pm

    #1063062

  • RE: Are the posted questions getting worse?

    Lynn Pettis (10/7/2009)

    The last letter I got from her was dated 9/30. She said it was hard to believe that it had be 65 days already. They had...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 1:49 pm

    #1063048

  • RE: SQL & the JOIN Operator

    wagner crivelini (10/7/2009)

    Hi David

    I understand your point.

    But it came out so naturally to me writing statements with aliases that it never crossed my mind to say they are optional.

    But I...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 1:41 pm

    #1063045

  • RE: SQL & the JOIN Operator

    davidpenton (10/7/2009)

    The bigger concern that I have is when people *do not* use any alias, even for a simple query. Then the next person comes along, adds a join without...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 1:34 pm

    #1063041

  • RE: SQL & the JOIN Operator

    David Walker-278941 (10/7/2009)

    ryan.mcatee (10/7/2009)

    Speaking of queries, the ones in the article are simple examples, but when you're pulling many columns and joining on multiple keys, repeating full table names over...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 1:28 pm

    #1063040

  • RE: SQL & the JOIN Operator

    sushila (10/7/2009)

    Jeff - ...are on your way to becoming a famous author as well...could you not teach people the art of keeping an even tone..?!;-)

    Hello my long-time and trusted friend....

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 1:20 pm

    #1063034

  • RE: SQL & the JOIN Operator

    sql.varun (10/7/2009)

    Good Article,

    I have a question on Joins.Can anyone help me.

    When I run below query it is running for 40 mins as it is using Table Spool.

    Query:

    select a.*,b.*

    from table a

    left...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 12:54 pm

    #1063015

  • RE: SQL & the JOIN Operator

    David Walker-278941 (10/7/2009)

    Jeff Moden (10/7/2009)

    Actually, they ARE becoming required. The use of table names instead of aliases has been deprecated.

    Even if they weren't, short table names may work fine...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 7, 2009 at 12:51 pm

    #1063011

Viewing 15 posts - 41,626 through 41,640 (of 59,102 total)