Forum Replies Created

Viewing 15 posts - 16,246 through 16,260 (of 59,067 total)

  • RE: How to Make Scalar UDFs Run Faster (SQL Spackle)

    TomThomson (11/18/2016)

    I read this again because I saw Jeff's reference to it in the "Find the Brackets" QotD discussion, and seeing that the measurements were all run on a fairly...

    --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 21, 2016 at 8:46 am

    #1913760

  • RE: Find the brackets

    TomThomson (11/18/2016)

    Jeff Moden (11/17/2016)

    Stewart "Arturius" Campbell (11/17/2016)

    Another cause of disparity are scalar functions, which the execution plan appears to ignore completely.

    Agreed. In fact, those little beasties can be downright...

    --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 21, 2016 at 8:41 am

    #1913755

  • RE: Find the brackets

    Iwas Bornready (11/21/2016)

    Laurie Dunn (11/17/2016)

    This would also work and keep the code simple...

    SELECT *

    FROM dbo.MyData

    WHERE Left(mychar,1)='[';

    Nice alternative, thanks.

    It could be a huge killer of performance and use a large number...

    --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 21, 2016 at 8:38 am

    #1913751

  • RE: Approach to normalising 15 million transactions

    Grant Fritchey (11/21/2016)

    If you're migrating your data into a new configuration, I wouldn't do it in a single set as you're describing. Instead, break it apart and move only 100k...

    --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 21, 2016 at 8:33 am

    #1913746

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/21/2016)

    I have to do some more research on it but it may be time for me to get ready to retire.

    [font="Arial Black"]Microsoft Replaces Command Prompt with PowerShell 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 21, 2016 at 6:23 am

    #1913677

  • RE: Are the posted questions getting worse?

    I have to do some more research on it but it may be time for me to get ready to retire.

    [font="Arial Black"]Microsoft Replaces Command Prompt with PowerShell in Latest Windows...

    --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 21, 2016 at 5:54 am

    #1913667

  • RE: Wow. Just Wow

    Gosh, Manie... I wouldn't transfer backup files in the clear if there were any company data involved (and, of course, there will be) but I especially wouldn't do it 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 21, 2016 at 4:58 am

    #1913656

  • RE: DTS For Importation of Data From CSV file to SQL SERVER 2008 R2 Express

    joshua 15769 (11/20/2016)

    I just learned open rowset!

    SELECT *

    FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

    'Excel 12.0 Xml;

    Database=C:\DataFiles\EmployeeData1.xlsx',

    [vEmployee$]);

    That's correct for an Excel file (although I typically add...

    --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 21, 2016 at 4:52 am

    #1913654

  • RE: Approach to normalising 15 million transactions

    A transaction table is a history table which is also an audit table of sorts. Whatever happened, happened. In most cases, such tables should NOT be normalized because...

    --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 20, 2016 at 1:16 pm

    #1913623

  • RE: What is Normal?

    Eirikur Eiriksson (11/20/2016)

    I'm strictly for the full most practical normalisation with one exception, carrying forward a very carefully selected keys such as Invoice-->InvoiceLine-->InvoiceLineDetail(InvoiceID) where, at the cost of a single...

    --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 20, 2016 at 1:05 pm

    #1913622

  • RE: use microsoft updates

    starttreck2016 (11/19/2016)

    Is it possible to rerun the installation wizard just to check for the updates and run them

    Yes.

    --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 19, 2016 at 9:09 pm

    #1913588

  • RE: use microsoft updates

    starttreck2016 (11/19/2016)

    There was nothing rude in my original question , and my question was whether the use Microsoft update only lists the updates or does the update itself which 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)

    November 19, 2016 at 8:21 pm

    #1913586

  • RE: Wow. Just Wow

    This is one of my many fears about putting stuff on the cloud. A lot of people think they have control over their data when, in reality, someone else...

    --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 19, 2016 at 8:17 pm

    #1913585

  • RE: What is Normal?

    Oooooo.... don't get me started on the silliness of denormalized data being stored in the database. I'm going through some hell (again) because my predecessors thought it would 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 19, 2016 at 6:47 pm

    #1913584

  • RE: DTS For Importation of Data From CSV file to SQL SERVER 2008 R2 Express

    joshua 15769 (11/17/2016)

    I'm not quite sure when and where the data will be 4 or 6 columns since the data source is a scientific device which measures temperatures. It has...

    --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 19, 2016 at 6:14 pm

    #1913583

Viewing 15 posts - 16,246 through 16,260 (of 59,067 total)