Forum Replies Created

Viewing 15 posts - 35,866 through 35,880 (of 59,099 total)

  • RE: What is the difference between these two statements?

    Jason Norsworthy (11/28/2010)

    ... every constraint of every type will be named from now on.

    Thanks,

    Jason

    Just never name any constraint on a Temp Table or, like Craig said, you'll have some...

    --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)

    November 28, 2010 at 7:44 pm

    #1256084

  • RE: Setting up Database mail using gmail account

    sayfrend (4/7/2009)

    Try disabling your windows fire wall

    Don't do it for love nor money. 😉

    --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)

    November 28, 2010 at 4:25 pm

    #1256071

  • RE: Do You Talk Salary in the Interview?

    TravisDBA (11/27/2010)

    Andy Warren (11/27/2010)

    This is one of the areas where having an agent, usally someone from a staffing company, makes a lot of sense, it shields you from having to...

    --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)

    November 28, 2010 at 1:49 pm

    #1256067

  • RE: Date format not working

    p.stevens76 (11/28/2010)

    Hi, many thanks for that, works fine.

    i now need to put something in place so that if the date is >= 30 mins ago then a stored proc...

    --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)

    November 28, 2010 at 1:42 pm

    #1256065

  • RE: exec scope

    nadersam (11/28/2010)

    Thanks Gail,

    I appreciate your reply.

    But that means i have to rewrite the trigger code again 🙁 and so far i don't have other ideas on how to rewrite it.

    Thanks...

    --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)

    November 28, 2010 at 11:53 am

    #1256057

  • RE: Date format not working

    p.stevens76 (11/28/2010)

    Hi

    can anyone tell me why when i run the following i get an error message. I need to be able to insert dates as yyyy-mm-dd hh:mm:ss.

    Many Thanks

    Create table mfSitPosition

    (

    sitPosition...

    --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)

    November 28, 2010 at 11:47 am

    #1256055

  • RE: Searching stored procedure for table name but ignoring comments

    Here's what Steve means about "if they're up to date". This comes from Books Online under "sys.sql_dependencies"...

    [font="Arial Black"]Remarks[/font]

    Dependencies are established during CREATE only if the referenced (independent) entity exists...

    --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)

    November 28, 2010 at 11:31 am

    #1256053

  • RE: Export/Import Task

    As a side bar, wouldn't a simple insert from one table to another work?

    --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)

    November 28, 2010 at 9:36 am

    #1256039

  • RE: Export/Import Task

    sudhakara (11/25/2010)

    Hi,

    I am trying to copy the records from source server A to Destination server b by using the sql server task import/export wizard by using the query. While placing...

    --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)

    November 28, 2010 at 9:35 am

    #1256038

  • RE: open cursor takes long time

    Is it the cursor or the join? How long does it take to run the following?

    Select [Cmp],[App],[Cmd],[MsgID],[uid],[Date],[Sr],[Ct],[Rec],[E1],[Pr],[OP],[FDate],[R1],[U1],[CP],[Or],[udi2],[Se],[Se1],[Sp],[Cy],[Mt],[Ce],[Ida1],tblRec.Value

    From TempTable

    INNER JOIN tblRec ON TempTable.Rec = tblRec.Id

    Order By...

    --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)

    November 28, 2010 at 9:32 am

    #1256037

  • RE: Searching stored procedure for table name but ignoring comments

    Wouldn't a search of dependencies tell you?

    {edit} Bad suggestion on my part. :blush: Like Steve says below, it's NOT 100% guaranteed. It's always worked for me in...

    --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)

    November 28, 2010 at 9:29 am

    #1256034

  • RE: Database Standards Parsing

    ikjeft01 (11/27/2010)

    you are indeed lucky. NONE of the providers i've had to deal with can figure out how to pass UNformatted phone numbers! not to mention they often can't be...

    --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)

    November 28, 2010 at 9:15 am

    #1256032

  • RE: Index build and parallelism

    Apparently, I've got splitters on the mind, George. Yeah... I meant SWITCH and although I've not tried it myself, I saw Paul White demo it in a post on...

    --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)

    November 27, 2010 at 7:17 pm

    #1255993

  • RE: Database Standards Parsing

    To be honest, I never store formatted phone numbers and I don't format phone numbers in the database. That would be the job of the GUI if there is...

    --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)

    November 27, 2010 at 3:42 pm

    #1255990

  • RE: Index build and parallelism

    george sibbald (11/27/2010)

    It looks as if it would take a fair amount of effort to get to this set up though if it was not designed in at the beginning.

    It...

    --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)

    November 27, 2010 at 3:35 pm

    #1255989

Viewing 15 posts - 35,866 through 35,880 (of 59,099 total)