Forum Replies Created

Viewing 15 posts - 616 through 630 (of 844 total)

  • RE: Will order of fields create any performance issues?

    Luis Cazares (2/11/2015)

    below86 (2/11/2015)

    Some day, when I get some freee time, Ha Ha, I will run some additional test on our servers.

    Let me save you some time. 😉

    Thanks for...

    February 11, 2015 at 2:38 pm

    #1777077

  • RE: Will order of fields create any performance issues?

    Eric M Russell (2/11/2015)

    The order of columns in the insert does not matter to the optimizer or engine. Also the order of columns in the SELECT, WHERE, and JOIN do...

    February 11, 2015 at 11:00 am

    #1777025

  • RE: Will order of fields create any performance issues?

    GilaMonster (2/11/2015)

    below86 (2/11/2015)

    GilaMonster (2/11/2015)

    below86 (2/10/2015)

    I know when listing the fields in your joins in the same way the index is created has always made a difference

    It does not. Nor does...

    February 11, 2015 at 7:52 am

    #1776939

  • RE: Will order of fields create any performance issues?

    GilaMonster (2/11/2015)

    below86 (2/10/2015)

    I know when listing the fields in your joins in the same way the index is created has always made a difference

    It does not. Nor does the order...

    February 11, 2015 at 7:01 am

    #1776920

  • RE: Will order of fields create any performance issues?

    Well, OK then, I'm not sure why I thought it made a difference.

    I know when listing the fields in your joins in the same way the index is...

    February 10, 2015 at 3:55 pm

    #1776783

  • RE: Will order of fields create any performance issues?

    I guess I was just hoping that someone knew this, or has already tested it, without running my on test. Like I said anytime I write SQL I try...

    February 6, 2015 at 3:41 pm

    #1776192

  • RE: Just an idea ...

    mister.magoo (1/24/2015)

    ...or you can use the Object Explorer Details view to sort the columns.

    Just click on the "Columns" node in Object Explorer, then press F7 to open the details view...

    January 28, 2015 at 8:13 am

    #1773702

  • RE: Custom SSMS

    I just turn on the line numbers and change some of the coloring, the 'track changes before saving' the default I think is a light yellow, very hard to read,...

    January 23, 2015 at 7:53 am

    #1772640

  • RE: ID or Id

    Sean Lange (1/21/2015)

    below86 (1/21/2015)

    Sean Lange (1/20/2015)

    Eric M Russell (1/20/2015)

    I've used product_id. I like typing code in all lowercase, both keywords and identifiers, which is ok so long as underscores are...

    January 21, 2015 at 9:40 am

    #1771896

  • RE: ID or Id

    Sean Lange (1/20/2015)

    Eric M Russell (1/20/2015)

    I've used product_id. I like typing code in all lowercase, both keywords and identifiers, which is ok so long as underscores are also used for...

    January 21, 2015 at 8:09 am

    #1771831

  • RE: Debugging SQL Server

    GilaMonster (1/16/2015)

    call.copse (1/16/2015)

    I'm still a PRINT and temp table guy I'm afraid :blush: feels quite stone age but you know where you stand.

    Stone age, but it works. I'm there too....

    January 19, 2015 at 7:38 am

    #1771114

  • RE: Kitchen Culture

    aochss (12/22/2014)

    GoofyGuy (12/22/2014)

    I've been in IT going on 40 years, and I've discovered it's often the 'bad apples' who have the best ideas and insights.

    Conformity may bring a sullen peace...

    December 22, 2014 at 2:30 pm

    #1766075

  • RE: Kitchen Culture

    I had a choice out of college of two jobs, pretty much the same benefits/salary for both, except one had a cafeteria and the other barely had a break room....

    December 22, 2014 at 7:43 am

    #1765982

  • RE: Achievement Unlocked: Balance 0

    Beatrix Kiddo (11/21/2014)

    Some good points here.

    I do believe that it's in my own interest to spend few years working harder now while I'm young, have the energy, and my...

    November 21, 2014 at 8:01 am

    #1760153

  • RE: Achievement Unlocked: Balance 0

    GilaMonster (11/20/2014)

    I've been sitting with negative leave days available since July (about -0.5 at this point). No one in management is complaining, no pointed hints that I need to work...

    November 20, 2014 at 7:42 am

    #1759844

Viewing 15 posts - 616 through 630 (of 844 total)