Forum Replies Created

Viewing 15 posts - 35,491 through 35,505 (of 59,099 total)

  • RE: Are the posted questions getting worse?

    GSquared (1/5/2011)

    Brandie Tarvin (1/5/2011)

    Any programming language that complains when I try to use 0 as a divisor should be taken off the market and all its install disks buried in...

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

    January 5, 2011 at 11:46 pm

    #1269875

  • RE: Simple question regarding locks

    GSquared (1/5/2011)

    I don't know of any documentation on that. You could probably get an approximation through donkey-work. Take two copies of the same database, set one to Read-Only...

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

    January 5, 2011 at 11:38 pm

    #1269873

  • RE: Grouping problem

    knechod (1/4/2011)

    Ok, guys. Here's the progression ...

    - Google: nope

    - MSDN Help on Ranking functions: nope

    - Experts Exchange: nope

    - Start to write some God-awful RBAR code: hear mental admonishment from...

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

    January 5, 2011 at 11:31 pm

    #1269870

  • RE: update

    Tara-1044200 (1/3/2011)

    If I am prefixing numbers instead of letters it will sum the value like

    update mytable empno='2004'+'.'+empno and the result is summing up 2004 + 4398586

    but i want it as...

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

    January 5, 2011 at 7:09 pm

    #1269839

  • RE: Upper/lower case text

    I'm really surprised to see your good folks test results on the loop function for initial caps because I remember the original tests I did were quite conclusive in favor...

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

    January 5, 2011 at 7:02 pm

    #1269837

  • RE: parsing email id from string

    LutzM (1/4/2011)

    kevin4u06 (1/4/2011)

    they haven't yet....i need that solution....cause im dealing with the same scenario right now....

    Trust me,they have. 😉

    As a bit of a side bar, I'm constantly amazed at how...

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

    January 4, 2011 at 12:16 pm

    #1269161

  • RE: Are the posted questions getting worse?

    Steve, congrats on the MVP renewal! Definitely well deserved!

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

    January 4, 2011 at 12:03 pm

    #1269154

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (1/4/2011)

    Chris Morris-439714 (1/4/2011)

    Craig Farrell (1/3/2011)

    For anyone following the earlier infringment discussion, some sleuthing around SSC finally revealed the blog owner. A brief PM conversation seems to have...

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

    January 4, 2011 at 11:53 am

    #1269149

  • RE: Upper/lower case text

    You know me... I'll always be one of the first to come up with a Tally Table solution and (now) to avoid scalar UDF's like the plague. However, I'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)

    January 4, 2011 at 11:11 am

    #1269127

  • RE: change the following query to storedprocedure

    koolme_85 (1/3/2011)

    select AccountDim.accountbranchnumber,AccountDim.accountdimkey,AccountDim.accountnumber,

    AccountDim.accounttype,case AccountDim.accounttype when 'D' then 'Checking' when 'S' then

    'Savings' when 'X' then 'Club' else ''end as accounttypedesc,AccountDim.productcode,

    DDMasterFacts.currentbalance,DDMasterFacts.postdatedimkey,TimeDim.SLEOMInd,CASE

    SUBSTRING(CAST(DDMasterFacts.postdatedimkey AS varchar(8)),5,2) when 01 then 'Jan'+''+

    LEFT(DDMasterFacts.postdatedimkey,4) when...

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

    January 3, 2011 at 7:56 pm

    #1268726

  • RE: update

    LutzM (1/3/2011)

    STOP!! There is a hidden trap...

    What is the data type of the current column employeeno?

    If it's any numeric data type (e.g. INT), the update statement will fail.

    Before updating a...

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

    January 3, 2011 at 7:38 pm

    #1268724

  • RE: scalable hardware solution for 10TB now to 100TB in 3 years

    mlbauer (12/31/2010)

    We want to scan the *complete data in less than 1 hour*

    I have to ask... to what end? Why is this necessary and why will it be necessary...

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

    January 3, 2011 at 7:34 pm

    #1268723

  • RE: scalable hardware solution for 10TB now to 100TB in 3 years

    mlbauer (12/23/2010)

    All queries will take twice the time for twice the data.

    Not really true and "It Depends" pevails a whole lot in that area. Partitioned tables can really...

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

    January 3, 2011 at 7:32 pm

    #1268722

  • RE: parsing email id from string

    What if the string contains an "@" that isn't actually part of an email address?

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

    January 3, 2011 at 7:25 pm

    #1268721

  • RE: Loading XML Data into SQL Server (SQL Spackle)

    weharrelson (1/3/2011)

    FWIW, We have weekly imports of ~25MB of XML. The sp_xml_preparedocument method ran circles around the new ways (x.data.value...)

    Care to share the snippet that imports those weekly files?

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

    January 3, 2011 at 6:41 pm

    #1268715

Viewing 15 posts - 35,491 through 35,505 (of 59,099 total)