Forum Replies Created

Viewing 15 posts - 48,391 through 48,405 (of 59,099 total)

  • RE: TOP and TABLESAMPLE

    Wow... although I've not needed to use it, I've heard about TableSample before. Didn't know it would return a random number of rows in the rows mode. What...

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

    September 10, 2008 at 7:58 pm

    #870076

  • RE: sqlquery

    Heh... thanks for the confidence in the Tally table, Gary, but I don't believe it can be made to number rows for what's essentially a 1 row "paging" system. ...

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

    September 10, 2008 at 6:04 pm

    #870052

  • RE: String function

    Sergiy (9/10/2008)

    khushbu.kumar (9/10/2008)

    Thanks a lot Chris!

    But the here posted code was just a snippet

    i really dont know how many rows can be present(i'm selecting them on the basis of...

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

    September 10, 2008 at 5:56 pm

    #870048

  • RE: Concatenate multiple rows into a single row

    anthony.evans (11/15/2007)

    simple but effective solution in sql 2000 , modified to return each case statement result in different column , effectively creating pivot report.thank you

    If you'd like to see more...

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

    September 10, 2008 at 5:46 pm

    #870044

  • RE: disabled component to install

    Absolutely not... if you want to install on some version of Windows for a desktop, you need to buy the Developers Edition... it costs less than a good book on...

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

    September 10, 2008 at 5:27 pm

    #870036

  • RE: sqlquery

    Heh... if only it were that simple, Gary. 🙂 Op wants the 40th row... not the top 40. Of course, this is SQL Server 2005 and TOP is...

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

    September 10, 2008 at 5:15 pm

    #870031

  • RE: String function

    Chris Morris (9/10/2008)

    Thanks Jeff, and thanks also for posting up your tally table article. One of these days I'll take the time to put them in my sig

    INSERT INTO sig...

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

    September 10, 2008 at 5:11 pm

    #870029

  • RE: String function

    Chris Morris (9/10/2008)

    Hi Khushbu

    You're welcome, thanks for the feedback.

    The number of rows will probably matter if there are hundreds of thousands. If the query runs too slowly (and it runs...

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

    September 10, 2008 at 5:08 pm

    #870027

  • RE: tempdb reporting Error: 9002 log full

    SanjayAttray (9/10/2008)

    I know when tempdb size has grown as its a process which we perform once in a 3 months. I needed the space back because of space issue...

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

    September 10, 2008 at 5:03 pm

    #870024

  • RE: String function

    Well done, Chris! And, no bloody UDF, either!

    khushbu,

    If you don't know what a Tally table is or does, please refer to the following article. I believe you'll find...

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

    September 10, 2008 at 5:44 am

    #869540

  • RE: Soft Skills

    majorbloodnock (9/10/2008)

    Indeed, the knowledge someone has those weapons available but chooses not to use them does in itself help to establish that person's integrity.

    I found absolutely no correlation between soft-skills...

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

    September 10, 2008 at 5:40 am

    #869536

  • RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

    thivyapraba (9/10/2008)

    Jeff,

    Nice article, But how do you measure the performance, is there any tools?

    There's lot's of tools like Performance Monitor, etc. But, I didn't use anything quite so sophisticated...

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

    September 10, 2008 at 5:14 am

    #869522

  • RE: How do I determine Free & Total Space for disk drives, using T-SQL?

    Good article, but you do have to audit all the drives beforehand to use it. And, what if a new drive is made available by the SysOps? 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)

    September 9, 2008 at 6:11 am

    #868978

  • RE: Auto update table with correlated subquery

    Heh... thanks for the feedback guys.

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

    September 9, 2008 at 6:03 am

    #868973

  • RE: On Indexes and Views

    Timothy! Great article on NO EXPAND. Nicely done!

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

    September 9, 2008 at 6:01 am

    #868972

Viewing 15 posts - 48,391 through 48,405 (of 59,099 total)