Forum Replies Created

Viewing 15 posts - 10,141 through 10,155 (of 59,099 total)

  • RE: Log file and data file growth

    NP.  Thanks for the feedback.

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

    January 5, 2019 at 4:07 pm

    #2018079

  • RE: Lack of Memory

    ZZartin - Friday, January 4, 2019 10:16 AM

    robert.sterbal 56890 - Friday, January 4, 2019 8:44 AM

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

    January 5, 2019 at 2:12 pm

    #2018076

  • RE: SSIS Help!

    Heh... doesn't matter.  Real Excel file or Excel converted to CSV... you'll have the same problems because the problem isn't in the file type.  Unless the Excel file is laid...

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

    January 5, 2019 at 1:48 pm

    #2018075

  • RE: UTF-8 Requirement for DB - will it work with SQL2014

    krypto69 - Friday, January 4, 2019 6:06 AM

    HI,
    My sys admin sends me an email asking me to install a new DB....

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

    January 5, 2019 at 12:56 pm

    #2018074

  • RE: Log file and data file growth

    Tac11 - Thursday, January 3, 2019 11:56 AM

    Hi Gurus,
    Is there anyway to query to see if log or/and data file growing NOT...

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

    January 5, 2019 at 12:53 pm

    #2018073

  • RE: SQL Memory & Tempdb usage

    sqlguy7777 - Saturday, January 5, 2019 2:36 AM

    HiI agree with you completely, but we’re kind of stuck with it. The top brass...

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

    January 5, 2019 at 10:55 am

    #2018071

  • RE: Insert Faster way

    RGP - Saturday, January 5, 2019 3:37 AM

    Jeff Moden - Friday, January 4, 2019 11:55 PM

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

    January 5, 2019 at 9:05 am

    #2018070

  • RE: Insert Faster way

    p.p.s.  BTW, what's the data type of that JOB_INFO  column?

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

    January 4, 2019 at 11:55 pm

    #2018064

  • RE: SQL Memory & Tempdb usage

    sqlguy7777 - Friday, January 4, 2019 10:57 PM

    Hey thanks everyone for your great responses so far.....

    "What problems are you trying to solve?"

    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)

    January 4, 2019 at 11:40 pm

    #2018063

  • RE: Insert Faster way

    p.s.  We really need to fix that 50% FILL FACTOR thing.  It's wasting a ton of memory.  We can look at that once we've solved your original problem.

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

    January 4, 2019 at 11:25 pm

    #2018062

  • RE: Insert Faster way

    Ok... here we go...

    First, I wanted to make sure that I had the same volume of data you have.  I'd forgotten to ask you to post the DDL...

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

    January 4, 2019 at 11:13 pm

    #2018061

  • RE: Insert Faster way

    RGP - Friday, January 4, 2019 7:21 PM

    Thanks Jeff, no issues at all, I’m so glad that you are so responsive 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)

    January 4, 2019 at 9:12 pm

    #2018056

  • RE: Query

    Here's an example of how short the code can be thanks to sys.master_files.
     SELECT  DatabaseName           = DB_NAME(database_id)
            ,FileType               = type_desc
            ,dbFileLogicalName      = name
            ,dbFilePhysicalFilePath =...

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

    January 4, 2019 at 9:00 pm

    #2018055

  • RE: Query

    Nita Reddy - Friday, January 4, 2019 10:53 AM

    --My Query to get Space left in a data file.
    CREATE TABLE ##ALL_DB_Files (
    dbname...

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

    January 4, 2019 at 8:06 pm

    #2018054

  • RE: Query

    Nita Reddy - Friday, January 4, 2019 10:53 AM

    Question: from above query I am getting Spaceleft for XYZ database which has 4...

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

    January 4, 2019 at 8:00 pm

    #2018053

Viewing 15 posts - 10,141 through 10,155 (of 59,099 total)