Forum Replies Created

Viewing 15 posts - 19,351 through 19,365 (of 59,098 total)

  • 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

  • RE: The Hot Jobs

    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, Big Data Engineer,...

    --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 7:51 pm

    #1835631

  • RE: Missing Relationships

    Wayne West (10/26/2015)

    Jeff Moden (10/25/2015)

    ... Then, introduce them to some very high velocity pork chops.

    As it happens, I was eating a brisket and sausage sandwich when I read this. ...

    --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 7:41 pm

    #1835629

  • RE: Positive or Negative

    SQLBill (10/26/2015)

    The way I would determine which to use (Active or Inactive) would depend on how I am going to query the data. I use "pseudo code" to determine...

    --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 7:37 pm

    #1835628

  • RE: Starting to get tired of all the spam on the forums !!!!

    Steve Jones - SSC Editor (10/26/2015)

    They are using some bug that lets them submit many posts, even as unapproved users.

    [font="Arial Black"]PLEASE [/font]tell me that the bug is in the...

    --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 7:02 pm

    #1835626

Viewing 15 posts - 19,351 through 19,365 (of 59,098 total)