Forum Replies Created

Viewing 15 posts - 19,321 through 19,335 (of 59,072 total)

  • RE: What can I do to speed up my production daily full-backup?

    When you do your laundry, do you wash the clean clothes or just the dirty ones?

    The same holds true in databases. Typically, there are a couple of tables that...

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

    October 29, 2015 at 12:09 pm

    #1836484

  • RE: Thank you to the Forum

    jamesnt (10/28/2015)

    It's been a long time since I've posted this so we are long past due.

    Thank you to everyone who participates on this forum. Although I've been a member...

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

    October 29, 2015 at 11:55 am

    #1836478

  • RE: Thank you to the Forum

    Brandie Tarvin (10/29/2015)

    On behalf of all the regulars who already saw this but haven't yet responded, you are welcome. It's people like you that we do this for.

    Here, here! ...

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

    October 29, 2015 at 11:53 am

    #1836477

  • RE: beginner row to column ?

    christophe.bernard 47659 (10/29/2015)

    Hello all,

    thanks for all, I'm repeat perhaps 🙂 but that wonderfull to be find some help with this site ..

    have a nice day

    christophe

    Thank you for being interested enough...

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

    October 29, 2015 at 7:50 am

    #1836377

  • RE: Table Space growth based on each year

    Ed Wagner (10/29/2015)

    That's pretty slick, Eirikur. I appreciate how you use string replacement using the rows in sys.databases to generate the final SQL to fire. I've noticed that...

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

    October 29, 2015 at 7:46 am

    #1836374

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    I think that if we're going to do a study on inline Tally Table creation methods and comparisons against physical Tally Tables that have been cached, we should start another...

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

    October 29, 2015 at 6:57 am

    #1836345

  • RE: Building a tree view using t-sql

    I used a much different tactic. I'll explain why in a minute but let's first see how it solves your immediate problem.

    First, here's your original table and data (keeping...

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

    October 28, 2015 at 10:20 pm

    #1836245

  • RE: Table Space growth based on each year

    At the database level, I'll say "kind of" but only if you know what your database backup sizes have been or that info is still in the MSDB database.

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

    October 28, 2015 at 5:21 pm

    #1836234

  • RE: Today's Random Word!

    Eirikur Eiriksson (10/28/2015)

    Ed Wagner (10/28/2015)

    Eirikur Eiriksson (10/28/2015)

    happygeek (10/28/2015)

    nibble

    Quark

    String

    Tension

    "Wait-till-last-minute"

    (83-code-reviews-in-2-days-on-urgent-project :sick::blink::unsure:)

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

    October 28, 2015 at 3:56 pm

    #1836220

  • RE: Positive or Negative

    below86 (10/28/2015)

    +100 to Eric's last post.

    Except for the part about having to guess whether a 1 is true or false, I'll second that.

    As for the reason why some systems use...

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

    October 28, 2015 at 9:41 am

    #1836112

  • RE: beginner row to column ?

    christophe.bernard 47659 (10/28/2015)

    Hi yb751, Luis Cazares

    thanks for your time that's exactly what I want ..

    I don't know the function pivot but I can see that's very powerfull ..

    @yb751 => your...

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

    October 28, 2015 at 8:32 am

    #1836078

  • RE: The Hot Jobs

    xsevensinzx (10/26/2015)

    Jeff Moden (10/26/2015)

    xsevensinzx (10/26/2015)

    Eric M Russell (10/26/2015)

    ..If you look through the jobs, many are development positions, but there are some good data ones. Data modeler, BI Analyst, Data Architect,...

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

    October 27, 2015 at 9:57 am

    #1835836

  • RE: Query on a large database

    Jayanth_Kurup (10/26/2015)

    Thanks for taking the time to do this Jeff , I'll try an have a more easily usable script ready in a few minutes and send them to you.

    Looking...

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

    October 26, 2015 at 10:23 pm

    #1835650

  • RE: Query on a large database

    Jayanth_Kurup (10/23/2015)

    Just wondering if anybody was able to finish testing the scripts and if there are any new results ?

    EDIT : BUMP, hoping for some independently verified results , also...

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

    October 26, 2015 at 9:29 pm

    #1835645

  • RE: DELETE syntax - jus checking in..

    celticpiping (10/26/2015)

    hmm

    well, I must have highlighted the top line...

    because I re-ran, and deleted 1 row with:

    delete shipping_data

    where order_no='1000002'

    and running;

    delete shipping_data

    where order_no=1000002

    produced an error: "Conversion failed when converting the varchar...

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

    October 26, 2015 at 9:15 pm

    #1835643

Viewing 15 posts - 19,321 through 19,335 (of 59,072 total)