Forum Replies Created

Viewing 15 posts - 24,436 through 24,450 (of 59,102 total)

  • RE: Sending a Variable Number of Elements in a Parameter

    Peter E. Kierstead (2/9/2014)

    Why not try an inline function? What have you got against them?

    lol, we've come full circle. The original intent of my question was to stretch the boundaries...

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

    February 9, 2014 at 6:44 pm

    #1687409

  • RE: Oddball Interview Questions

    mtucker-732014 (2/9/2014)

    IMHO oddball questions are not reliable or valid means of determining a candidates competence or fit for a job.

    I couldn't agree more.

    A few weeks ago I read...

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

    February 9, 2014 at 6:38 pm

    #1687408

  • RE: Performance Tuning Through Panic

    I like this editorial and Paul's sort article on this a lot but, most of the time, I've found it to be just crap code and crappy table design.

    Heh... I...

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

    February 9, 2014 at 6:06 am

    #1687365

  • RE: Oddball Interview Questions

    Knut Boehnert (2/7/2014)

    "How would you fill a coffee cup in T-SQL?"

    I wouldn't because that's RBAR. I'd write the code to fill a million coffee cups according to size...

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

    February 7, 2014 at 10:05 pm

    #1687302

  • RE: OS Disk Capacity Information

    My problem is that I'm still stuck with 2005 at work (apologies for forgetting to mention that on a 2K12 forum). CMS isn't possible for me at this time.

    I'll...

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

    February 7, 2014 at 9:31 am

    #1687115

  • RE: How many partitions & files are supported in 2008R2

    sqlcentral2 (2/6/2014)

    Jeff Moden (2/5/2014)

    sqlcentral2 (2/5/2014)

    Simple question.

    The partitioning scheme with indices calls for about 1100 file groups per year (one file per file group), and there is 20 years 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)

    February 7, 2014 at 9:27 am

    #1687114

  • RE: OS Disk Capacity Information

    wak_no1 (2/6/2014)

    Thank you.

    Code to retrieve disk information needed via Powershell

    Get-WMIObject Win32_LogicalDisk -filter "DriveType=3" -computer (Get-Content c:\computers.txt) | Select SystemName,DeviceID,VolumeName,@{Name="size(GB)"; Expression={"{0:N1}" -f($_.size/1gb)}},@{Name="freespace(GB)";Expression={"{0:N1}" -f($_.freespace/1gb)}}

    Of the back of this, I've created a table...

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

    February 7, 2014 at 8:05 am

    #1687076

  • RE: OS Disk Capacity Information

    wak_no1 (2/6/2014)

    Bob, thank you, this is working as I'd hoped. I can sort of see what I needed to do.

    One thing has just occurred to me though, I need 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)

    February 7, 2014 at 8:02 am

    #1687073

  • RE: OS Disk Capacity Information

    Robert klimes (2/6/2014)

    try this out

    $ds = New-Object system.Data.DataSet

    $ds = Get-WMIObject Win32_LogicalDisk -filter "DriveType=3" -computer (Get-Content c:\computers.txt) | Select SystemName,DeviceID,VolumeName,@{Name="size"; Expression={"{0:N1}" -f($_.size/1gb)}},@{Name="freespace";Expression={"{0:N1}" -f($_.freespace/1gb)}}

    foreach ($d in $ds)

    {

    $systemname = $d.systemname

    $deviceID = $d.DeviceID

    $volumename...

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

    February 7, 2014 at 7:53 am

    #1687066

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (2/7/2014)

    Ed Wagner (2/7/2014)

    That's one thing I really enjoy about SSC. The people here aren't paid to answer questions. We do it because we enjoy doing 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)

    February 7, 2014 at 7:09 am

    #1687028

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (2/6/2014)

    Steve Jones - SSC Editor (2/6/2014)

    However, this way they can give feedback that something worked. We are talking about how to best get other info from the "crowd"...

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

    February 7, 2014 at 12:36 am

    #1686920

  • RE: How comma separated values are divided into rows?

    Luis Cazares (2/6/2014)

    Evil Kraig F (2/6/2014)

    Jeff, do you have SSIS 2k8 available to you or do you need said examples in 2k5?

    That's just mean 😀

    Nah... Craig knows me. I...

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

    February 7, 2014 at 12:26 am

    #1686917

  • RE: How comma separated values are divided into rows?

    Koen Verbeeck (2/6/2014)

    Jeff Moden (2/6/2014)

    Shifting gears to the idea that you came up with using "Split.String" and a loop in SSIS, I couldn't have come up with that partiicular answer...

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

    February 7, 2014 at 12:18 am

    #1686915

  • RE: How comma separated values are divided into rows?

    Evil Kraig F (2/6/2014)

    Jeff Moden (2/6/2014)

    Heh... I'm used to, welcome, and embrace criticism. It's one of the tools I use to learn new things. For example, if someone...

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

    February 7, 2014 at 12:15 am

    #1686913

  • RE: Sending a Variable Number of Elements in a Parameter

    I just reported the formatting problems for this article. Hopefully, someone at SQLServerCentral will pick up on it and fix it. Again, these problems aren't caused by 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)

    February 6, 2014 at 8:42 pm

    #1686886

Viewing 15 posts - 24,436 through 24,450 (of 59,102 total)