Forum Replies Created

Viewing 15 posts - 35,971 through 35,985 (of 59,102 total)

  • RE: Are the posted questions getting worse?

    Looks like the stress you were talking about caught up with you, Jack. I've actually been through that a couple of times including the trips to the hospital. ...

    --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 22, 2010 at 7:58 pm

    #1254155

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/22/2010)

    Brandie Tarvin (11/22/2010)

    CirquedeSQLeil (11/22/2010)

    Alvin Ramard (11/22/2010)

    Brandie Tarvin (11/22/2010)

    I live in Florida now. Black Friday is not so bad when you can wait in line at 2:00 a.m. 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 22, 2010 at 7:46 pm

    #1254154

  • RE: Little Devices

    WayneS (11/22/2010)

    Jeff Moden (11/22/2010)

    I just don't ever want to be that "productive". Down-time is very important to me.

    Yes, but I refer back to what Steve posted above:

    If a...

    --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 22, 2010 at 7:35 pm

    #1254153

  • RE: Little Devices

    Grant Fritchey (11/22/2010)

    Jeff Moden (11/22/2010)

    I just don't ever want to be that "productive". Down-time is very important to me.

    What is this "down-time" of which you speak?

    Heh... yeah... I know...

    --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 22, 2010 at 7:29 pm

    #1254151

  • RE: Little Devices

    I just don't ever want to be that "productive". Down-time is very important to me.

    --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 22, 2010 at 3:15 pm

    #1254089

  • RE: tempdb

    I guess my question would be, what are you doing where you'd ever need almost a T-Byte of TempDB? What's the total MDF/LDF size for that server?

    --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 22, 2010 at 3:14 pm

    #1254088

  • RE: need help with loading a string

    kevin4u06 (11/22/2010)

    There is one more added complexity , in some recordds the state has for example

    Arizona

    New Jersy

    instead of just their abbreviation

    Build a table of long names and short names and...

    --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 22, 2010 at 3:09 pm

    #1254086

  • RE: How to repeat/or duplicate my results?

    GSquared (11/22/2010)

    churlbut (11/22/2010)

    Here is one way of doing it:

    DROP TABLE #Temp

    DECLARE @X int

    SET @X = 1

    CREATE TABLE #Temp (Phone varchar(17) null)

    WHILE @X < 101

    BEGIN

    INSERT INTO #Temp(Phone) select Phone from People...

    --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 22, 2010 at 2:00 pm

    #1254038

  • RE: deleting huge records From Table

    Sachin Nandanwar (11/22/2010)

    Jeff Moden (11/22/2010)

    I agree. Just to be clear for folks that may think of doing it, don't ever shift from FULL recovery to SIMPLE recovery for the...

    --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 22, 2010 at 7:57 am

    #1253751

  • RE: Averaging data streaks

    Sachin Nandanwar (11/22/2010)

    keymoo (11/22/2010)

    Thanks it doesn't give me the correct results for dates that are the same. Is there a tweak needed to do that?

    Please post some sample data and...

    --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 22, 2010 at 7:53 am

    #1253746

  • RE: deleting huge records From Table

    Eralper (11/22/2010)

    Thanks Jeff,

    I checked the BOL and I found :

    The amount of logging for SELECT...INTO depends on the recovery model in effect for the database. Under the simple recovery model...

    --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 22, 2010 at 6:10 am

    #1253686

  • RE: Dynamic query in a function

    S_Kumar_S (11/22/2010)

    I dont think you can call a proc from inside a function except extended procs.

    So it concludes that there is no simple work around expect if I can find...

    --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 22, 2010 at 6:03 am

    #1253680

  • RE: Dynamic query in a function

    Heh... yes... ask an "SQL Server DBA". 😉

    --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 22, 2010 at 1:01 am

    #1253603

  • RE: deleting huge records From Table

    You can get around some of the logging issues by using a SELECT/INTO to copy only the rows you want to keep and then renaming the table(s). Read up...

    --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 22, 2010 at 12:49 am

    #1253600

  • RE: two insert statments takes long time to process

    Sachin Nandanwar (11/17/2010)

    dlam 18073 (11/16/2010)

    I dont get it. clientNumber in tblClientList is primary key.

    can you tell me abit more in detail. thx!!

    Then why are you checking whether the clientNumber exists?If...

    --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 22, 2010 at 12:43 am

    #1253598

Viewing 15 posts - 35,971 through 35,985 (of 59,102 total)