Forum Replies Created

Viewing 15 posts - 676 through 690 (of 2,462 total)

  • RE: Today's Random Word!

    yb751 (5/30/2016)

    Ray K (5/27/2016)

    crookj (5/27/2016)

    A10

    A380

    Massive

    Attack

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 30, 2016 at 4:48 pm

    #1882053

  • RE: Improving performance of a query.

    Jim Covington (5/27/2016)

    In the IBM OS world, there is a view called a logical file. With a Logical file you can derive a subset of records and sort in...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 27, 2016 at 8:19 pm

    #1881906

  • RE: Dynamically Query a 100 Million Row Table-Efficiently

    TheSQLGuru (5/27/2016)

    ChrisM@Work (2/24/2015)

    ... Two omissions stood out however - the cost of recompiling, ...

    I will jump through hoops to trade CPU ticks to avoid disastrously bad plans (and the horrible...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 27, 2016 at 1:10 pm

    #1881880

  • RE: Dynamically Query a 100 Million Row Table-Efficiently

    Just finished this for the first time. Great work Gary! 5 stars.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 27, 2016 at 9:33 am

    #1881815

  • RE: Today's Random Word!

    Ed Wagner (5/26/2016)

    Grumpy DBA (5/26/2016)

    Luis Cazares (5/26/2016)

    crookj (5/26/2016)

    Coward

    Courage

    Liquid

    Lunch

    box

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 26, 2016 at 1:38 pm

    #1881670

  • RE: Diagnosing parallelism-related latching

    Good job on the article David. Very well researched, informative and full of great additional resources. 5 stars!

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 26, 2016 at 6:37 am

    #1881533

  • RE: Today's Random Word!

    Ed Wagner (5/25/2016)

    ThomasRushton (5/25/2016)

    Revenant (5/24/2016)

    Manic Star (5/24/2016)

    whereisSQL? (5/24/2016)

    Luis Cazares (5/24/2016)

    Manic Star (5/24/2016)

    crookj (5/24/2016)

    HappyGeek (5/24/2016)

    Manic Star (5/24/2016)

    Grumpy DBA (5/24/2016)

    Manic Star (5/24/2016)

    Ray K (5/24/2016)

    Ed Wagner (5/24/2016)

    crookj (5/24/2016)

    Rift

    Continuum

    Vacuum

    Cleaner

    Winston Wolfe

    Mystery

    Writer

    Ghost

    Buster

    Bunny

    Bugs

    Wascally Wabbit

    Cartoon

    Individual

    (Blame Animaniacs - "I...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 25, 2016 at 5:51 am

    #1881288

  • RE: How to filter fur multiple facilities

    Np

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 23, 2016 at 2:46 pm

    #1880891

  • RE: Today's Random Word!

    Ed Wagner (5/23/2016)

    crookj (5/23/2016)

    Grumpy DBA (5/23/2016)

    Ed Wagner (5/23/2016)

    ThomasRushton (5/23/2016)

    mjagadeeswari (5/23/2016)

    Ed Wagner (5/23/2016)

    Grumpy DBA (5/23/2016)

    BWFC (5/23/2016)

    Ed Wagner (5/23/2016)

    Cook

    Captain

    Hook

    Line

    Row

    Skid

    Fishtail

    Swallowtail

    Choke

    Artichoke

    heart

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 23, 2016 at 7:48 am

    #1880769

  • RE: Today's Random Word!

    crookj (5/20/2016)

    Manic Star (5/20/2016)

    Ed Wagner (5/20/2016)

    Manic Star (5/20/2016)

    Cops

    Slammer

    Alabama

    Sweet Home

    Freebird

    Food

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 20, 2016 at 3:58 pm

    #1880612

  • RE: Can eliminating blocking / deadlocking ever be BAD for performance?

    simon.friling (5/19/2016)

    Look, a lot of people say a lot of things.

    As the person who said this particular thing, I thought I might elaborate on my thought process a bit:

    Lets...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 19, 2016 at 9:36 pm

    #1880419

  • RE: How do I enforce a begin date is before an end date?

    Rod at work (5/19/2016)

    Lynn Pettis (5/19/2016)

    Here is a simple way to swap two values to ensure StartDate is less than EndDate:

    d e c l a r e -- spaced to...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 19, 2016 at 10:59 am

    #1880314

  • RE: Today's Random Word!

    Revenant (5/19/2016)

    Ed Wagner (5/19/2016)

    Alan.B (5/19/2016)

    ThomasRushton (5/19/2016)

    djj (5/19/2016)

    crookj (5/19/2016)

    Ed Wagner (5/19/2016)

    Alan.B (5/19/2016)

    ThomasRushton (5/19/2016)

    Ed Wagner (5/19/2016)

    BWFC (5/19/2016)

    Ed Wagner (5/19/2016)

    Grumpy DBA (5/19/2016)

    djj (5/19/2016)

    Shooter

    Oswald

    Ruby

    Tuesday

    Friday

    Tomorrow

    Tomato

    Sauce

    BBQ

    Meat

    Feast

    Fast

    Slow

    Burn

    Out

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 19, 2016 at 10:51 am

    #1880310

  • RE: How do I enforce a begin date is before an end date?

    On the SSRS side of things I handle this kind of thing like this.

    At the top of my report is a text box with an error message in red...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 19, 2016 at 9:31 am

    #1880284

  • RE: Can eliminating blocking / deadlocking ever be BAD for performance?

    This sentence does not make sense to me:

    However, somebody has just suggested that any one of these cycles, in effectively moving blocking / deadlocking on from one statement to another,...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 19, 2016 at 9:19 am

    #1880280

Viewing 15 posts - 676 through 690 (of 2,462 total)