Forum Replies Created

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

  • RE: changing ALL font sizes on a chart

    One way to approach this is to do it in the code.First back up your report. Then, in SSDT or BIDS (whichever you're using), you could select "View Code" then...

    "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 31, 2016 at 12:30 pm

    #1882246

  • 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

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