Forum Replies Created

Viewing 15 posts - 37,471 through 37,485 (of 59,072 total)

  • RE: SQL formula calc challenge

    Understood on ALL that, thanks.

    Do you want the "setup values" to be hard coded or should they be stored in a "setup" table somewhere?

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

    July 26, 2010 at 9:04 pm

    #1198516

  • RE: Many DeadLocks

    GilaMonster (7/26/2010)

    Jeff Moden (7/26/2010)

    BWAA-HAA!!!! Gotta love that... MS "supports" deadlocks. :-):-D:-P;-):hehe:

    The Sharepoint team only.

    Someone I know took this problem to customer support. The SQL support team looked over 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)

    July 26, 2010 at 8:58 pm

    #1198515

  • RE: 8,000 charachter limit

    You do know about VARCHAR(MAX) in 2k5 and 2k8, right? Will hold 2 million characters just like the old TEXT datatype in 2k without all the pointer headaches.

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

    July 26, 2010 at 8:49 pm

    #1198514

  • RE: Importing Tab Delimited Flat Files Using SSIS

    I believe the easy way to do this will be to use "OPENROWSET" against the file because it will read the first row with the correct column names. Then...

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

    July 26, 2010 at 8:21 pm

    #1198510

  • RE: SQL formula calc challenge

    Actually, I do have another question...

    You seem to have very neatly solved the problem in the .xls file. Your goal is (in your words) to chart the output. ...

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

    July 26, 2010 at 8:09 pm

    #1198508

  • RE: SQL formula calc challenge

    First of all, very well done on the data and the loader code you provided. You just can't ask for much better than that.

    My only questions would be...

    1. ...

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

    July 26, 2010 at 8:00 pm

    #1198507

  • RE: Avoid cursor....

    NewBeeSQL (7/25/2010)

    No luck with your code..can you please generate the code which was mentioned in my first mail with your logic...

    This is one of those places where a cursor isn't...

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

    July 26, 2010 at 12:45 pm

    #1198387

  • RE: Avoid cursor....

    Adiga (7/25/2010)

    You can create a stored procedure for this code and use sp_MSforeachdb to execute it against each database.

    Example:

    EXEC SP_MSFOREACHDB @COMMAND1 ='SELECT DB_NAME(),DATABASEPROPERTYEX([?],'IsAutoClose''

    That doesn't actually avoid a cursor. MSForEachDB...

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

    July 26, 2010 at 12:44 pm

    #1198385

  • RE: MDOP

    Tara-1044200 (7/26/2010)

    I agree with you but i am cocnered about the perofrmance if i drop to 6 as the other 2 cpu's will be idle unless some one queries using...

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

    July 26, 2010 at 11:44 am

    #1198338

  • RE: Many DeadLocks

    GilaMonster (7/26/2010)

    From what I've heard, deadlocks are 'expected' on sharepoint when running the search crawl. They can be ignored as the search will retry the queries. (this is per 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)

    July 26, 2010 at 11:36 am

    #1198334

  • RE: 8,000 charachter limit

    8000 characters has never been a limit for code. ie... EXEC (@a+@b+@c.... etc).

    What are you using to import your data with because there's no 8k limit on imports either....

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

    July 26, 2010 at 11:34 am

    #1198332

  • RE: ISNUMERIC Issue

    Michael Valentine Jones (7/26/2010)

    It would by handy if SQL Server had an enhanced IsNumeric function that you could pass a specific target data type to, but that's the way 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)

    July 26, 2010 at 11:24 am

    #1198324

  • RE: Increment a field starting with the same number everytime.

    J-F Bergeron (7/26/2010)

    Ken@Work (7/26/2010)

    The RowNumber() approach looks nice.

    Is that a Server 7 command? I'm having trouble with it.

    Sadly, no, it's a sql server 2005 function. Sorry to have mislead...

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

    July 26, 2010 at 11:21 am

    #1198321

  • RE: The same day(1,2,3..31) of every month.

    Eugene Elutin (7/26/2010)

    Jeff Moden (7/26/2010)

    asiaindian (7/26/2010)

    Add a month to the startdate

    declare @StartDate date

    set @StartDate = '01-31-2010''

    select DATEADD(mm, 1, @StartDate)

    Repeat above code through any number of frequencies. Hope this helps.

    Ok.... you...

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

    July 26, 2010 at 11:13 am

    #1198318

  • RE: The same day(1,2,3..31) of every month.

    asiaindian (7/26/2010)

    Add a month to the startdate

    declare @StartDate date

    set @StartDate = '01-31-2010''

    select DATEADD(mm, 1, @StartDate)

    Repeat above code through any number of frequencies. Hope this helps.

    Ok.... you have 100 frequencies... now...

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

    July 26, 2010 at 7:38 am

    #1198192

Viewing 15 posts - 37,471 through 37,485 (of 59,072 total)