Forum Replies Created

Viewing 15 posts - 7,561 through 7,575 (of 59,091 total)

  • Reply To: Query Help - History Table with no range data.

    I'm a bit confused by the first row of your posted desired result...  Is the 4/1/2008 date for the SaleDate just a typo that should have been 1/1/2008 or 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)

    March 14, 2020 at 2:09 am

    #3734366

  • Reply To: Are the posted questions getting worse?

    Brandie Tarvin wrote:

    So an international academic writers conference (ICFA) that I usually am invited to as a fiction writer, and forgot to accept the invite last October, has been cancelled. 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)

    March 14, 2020 at 12:11 am

    #3734356

  • Reply To: Could you list db modeling tools you use on daily basis?

    A lot of people don't even know about it and a lot of people that have been spoiled by other things don't care for it but SQL Server "Diagrams" can...

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

    March 14, 2020 at 12:09 am

    #3734355

  • Reply To: Generate Index only Script for Whole db

    Admingod wrote:

    Simple recovery model. Approx 15 million rows. Unless bulk-logged is faster than simple?

    Simple and Bulk Logged are the same for this type of thing.  You didn't answer the rest...

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

    March 14, 2020 at 12:00 am

    #3734352

  • Reply To: Generate Index only Script for Whole db

    Admingod wrote:

    Thanks! I ran some tests first with clustered index in-place and second with clustered index dropped, load the data and add the  clustered index back . Noticed second one...

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

    March 13, 2020 at 11:16 pm

    #3734339

  • Reply To: Details of the transactions in Sql Server 2008 R2.

    Grant Fritchey wrote:

    Jeff Moden wrote:

    Heh... Hi!  My name is Jeff.  Grant has a problem with SQL Profiler and I can't fix Grant! 😀 😀 😀

    HA!

    And why you want to?

    I'll give you 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)

    March 13, 2020 at 10:28 pm

    #3734330

  • Reply To: Credibility of TABLE_SCHEMA column in INFORMATION_SCHEMA objects

    Thom A wrote:

    Jeff Moden wrote:

    Aye.  And I'd also like to see them fix the actual code for the ordinal.  All they need to do is change one bloody word in the code...

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

    March 13, 2020 at 3:12 pm

    #3734092

  • Reply To: Details of the transactions in Sql Server 2008 R2.

    Heh... Hi!  My name is Jeff.  Grant has a problem with SQL Profiler and I can't fix Grant! 😀 😀 😀

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

    March 13, 2020 at 3:11 pm

    #3734090

  • Reply To: Cursor inside a Stored procedure

    Hold the phone a minute... if this worked on a different instance, you have to ask yourself what changed when you copied it to the new instance if it doesn't...

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

    March 13, 2020 at 2:50 pm

    #3734075

  • Reply To: Credibility of TABLE_SCHEMA column in INFORMATION_SCHEMA objects

    Aye.  And I'd also like to see them fix the actual code for the ordinal.  All they need to do is change one bloody word in the code and update...

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

    March 13, 2020 at 2:46 pm

    #3734074

    • Viewing 15 posts - 7,561 through 7,575 (of 59,091 total)