Forum Replies Created

Viewing 15 posts - 30,616 through 30,630 (of 59,101 total)

  • RE: Data WareHouse

    If you have someone really good in either, it'll be a virtual tie for performance. Both products are capable of "enterprise class" size databases and performance.

    For "average" developers and...

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

    March 25, 2012 at 12:52 pm

    #1464027

  • RE: conersion of sql server code to slq plus

    I don't work with Oracle anymore but you don't need a loop for any of this and you probably don't need dynamic SQL for it either. Oracle has all...

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

    March 25, 2012 at 12:30 pm

    #1464022

  • RE: Are the posted questions getting worse?

    GSquared (3/23/2012)

    Reminds me indirectly of one of my three bosses at a job a couple of years ago. He ended up compulsively disagreeing with me. A couple 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)

    March 25, 2012 at 12:00 pm

    #1464018

  • RE: Data WareHouse

    farnaz224 (3/25/2012)

    Hello

    For The data warehouse oracle is better or sql ?

    Best Regards

    "It Depends". What do you actually mean by "better"?

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

    March 25, 2012 at 11:41 am

    #1464015

  • RE: how to convert seconds to time in sql

    dastagiri16 (3/25/2012)

    Lowell,

    could you please give me suggestion for..

    if seconds=999999

    then we can convert to time the result must be 277:46:39(hr:min:sec) ..

    like that the earlier mail mentioned formula

    DECLARE @seconds INT

    SELECT @seconds...

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

    March 25, 2012 at 11:34 am

    #1464014

  • RE: Reclaim Transaction Log Space

    govindarajan69 (3/25/2012)

    Hi Friends,

    I am facing an issue on reclaiming space from transaction log with my sql server 2008 with sp2. It grew up to 200 GB and running out...

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

    March 25, 2012 at 11:15 am

    #1464013

  • RE: Index Strategy

    PS. It will also allow for parameters like '% sm%' to find anyone with a last name starting with 'sm' and 'Bob %' to find anyone with a first...

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

    March 25, 2012 at 10:39 am

    #1464012

  • RE: Index Strategy

    BSavoie (3/23/2012)

    --* The optimizer uses the correct index here and does a seek

    SELECT FirstName, LastName, FullName

    FROM TestNames

    WHERE FirstName = 'Bob' AND LastName LIKE 'sm%'

    I guess my suggestion is that you've...

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

    March 25, 2012 at 10:31 am

    #1464009

  • RE: Make Meetings Fun

    I’m curious what things you do to make meetings fun, to make the long march more tolerable?

    You've correctly identified the problem with most meetings that I've seen. They're "long...

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

    March 25, 2012 at 10:16 am

    #1464007

  • RE: SCOPE_IDENTITY() error

    phijam.tansen.singh (3/25/2012)

    Hi,

    I am completely stuck with something like this :

    i am doing some insert statement then trying to update the identity index

    by using the SCOPE_IDENITY() function. But it...

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

    March 25, 2012 at 10:05 am

    #1464005

  • RE: Sequence Query Help

    Now all you have to do is solve the problem of concurrent runs getting the same number because your code does allow that to happen. It may be rare,...

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

    March 25, 2012 at 9:54 am

    #1464003

  • RE: Calendar Tables

    michaelm-746562 (2/27/2012)

    Additionally, I use an integer field in the table to allow queries easily to span segments that include differing years. The integer opens the door to arithmetic operations...

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

    March 25, 2012 at 9:09 am

    #1464001

  • RE: Get month names ordered using recursion

    ChrisM@home (3/25/2012)

    You're right Jeff, although it's faster than generating all rows, it's a "wee bit slower" than this:

    SELECT TOP (ISNULL(DATALENGTH(@pString),0)) n = n1+n2+n3+n4

    FROM (((VALUES (0),(100),(200),(300),(400),(500),(600),(700),(800),(900)) t2(n2)

    CROSS JOIN (VALUES...

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

    March 25, 2012 at 9:00 am

    #1464000

  • RE: Get month names ordered using recursion

    the sqlist (3/24/2012)

    Jeff Moden (3/24/2012)

    the sqlist (3/24/2012)

    ChrisM@home (3/24/2012)

    the sqlist (3/24/2012)

    ...I think we should not be worried about how many rows are actually generated...

    I couldn't disagree more. When you're looking at...

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

    March 24, 2012 at 11:13 pm

    #1463975

  • RE: Triangle Join - Can I do it right or a replacement?

    codebyo (3/24/2012)

    When the user clicks the year the charts, the month charts will be shown. When the user clicks the month chart, the week chart will be shown until 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)

    March 24, 2012 at 10:18 pm

    #1463973

Viewing 15 posts - 30,616 through 30,630 (of 59,101 total)