Forum Replies Created

Viewing 15 posts - 691 through 705 (of 2,462 total)

  • RE: Today's Random Word!

    ThomasRushton (5/19/2016)

    djj (5/19/2016)

    crookj (5/19/2016)

    Ed Wagner (5/19/2016)

    Alan.B (5/19/2016)

    ThomasRushton (5/19/2016)

    Ed Wagner (5/19/2016)

    BWFC (5/19/2016)

    Ed Wagner (5/19/2016)

    Grumpy DBA (5/19/2016)

    djj (5/19/2016)

    Shooter

    Oswald

    Ruby

    Tuesday

    Friday

    Tomorrow

    Tomato

    Sauce

    BBQ

    Meat

    Feast

    Fast

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 19, 2016 at 8:19 am

    #1880257

  • RE: Today's Random Word!

    ThomasRushton (5/19/2016)

    Ed Wagner (5/19/2016)

    BWFC (5/19/2016)

    Ed Wagner (5/19/2016)

    Grumpy DBA (5/19/2016)

    djj (5/19/2016)

    Shooter

    Oswald

    Ruby

    Tuesday

    Friday

    Tomorrow

    Tomato

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 19, 2016 at 6:27 am

    #1880163

  • RE: How to filter fur multiple facilities

    pietlinden (5/18/2016)

    how would I query just those people who are assigned to just the AMB facility? --- kinda contradicts your subject question... but anyway...

    If you're filtering for a single value,...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 18, 2016 at 8:17 pm

    #1880074

  • RE: How to filter fur multiple facilities

    This is where some DDL and sample data would be helpful. Note the link in my signature for tips on getting help.

    Let's say you had a users table and...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 18, 2016 at 8:15 pm

    #1880073

  • RE: DigitsOnlyEE and AlphaNumericOnly

    Argh! The SQL code get messed up for AlphanumericOnly somehow (bring on the contribution preview button 😉 ).

    The code is still good, it just looks odd at the...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 17, 2016 at 11:28 am

    #1879621

  • RE: Calculating Sharpe's Ratio, Standard Deviation, and Sorentino's Ratio

    Luis Cazares (5/17/2016)

    Are we all aware that SQL Server includes the STDEV and VAR functions?

    Other than the nulls being ignored, it should be easier to use.

    I know about them...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 17, 2016 at 10:44 am

    #1879602

  • RE: Calculating Sharpe's Ratio, Standard Deviation, and Sorentino's Ratio

    Another way without variables.

    SELECT

    mean,

    ss = SUM(POWER(measurement - mean,2)),

    n,

    stdDev = SQRT(SUM(POWER(measurement - mean,2)) / (n...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 16, 2016 at 9:29 pm

    #1879399

  • RE: Today's Random Word!

    Manic Star (5/16/2016)

    crookj (5/16/2016)

    Hugo Kornelis (5/16/2016)

    Revenant (5/16/2016)

    HappyGeek (5/16/2016)

    Grumpy DBA (5/16/2016)

    djj (5/16/2016)

    Penalty

    Shot

    Goal

    Stretch

    Limo

    Limbo

    Chiropractor

    Bill

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 16, 2016 at 5:16 pm

    #1879394

  • RE: plan for installation SSRS

    sqlfriends (5/16/2016)

    Thanks,

    The server will be a VM not physical. The host will be on SAN disks for data, log, backup drives.

    I plan to put on a 8 core, but 16...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 16, 2016 at 10:13 am

    #1879309

  • RE: Modifying XML with into or after

    Sometimes XML questions get no love around here.

    I am not great with the XML modify method (something I need to read up on and practice I guess) but here's...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 15, 2016 at 8:32 pm

    #1879160

  • RE: SSIS - XSLT file generating multiple xml files

    Provided that the XML files are similar you can absolutely do this. If they're not you can still do this, its just more complicated. You would have to post some...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 15, 2016 at 7:55 pm

    #1879158

  • RE: SharePoint crashing SQL all the time

    How do you know it's running out of memory and what is crashing? The server, just SQL? Do you have SharePoint and SQL running on the same box?

    Just a couple...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 15, 2016 at 7:35 pm

    #1879157

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Jeff Moden (5/14/2016)

    Alan.B (5/13/2016)

    Something I don't understand:

    SELECT * FROM dbo.DelimitedSplit8K('xxx,d','');

    Returns the whole string. This makes sense, the function found 0 occurrences of the delimiter.

    SELECT * FROM dbo.DelimitedSplit8K(NULL,',');

    Returns a NULL....

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 14, 2016 at 10:38 am

    #1879099

  • RE: Simple SQL challenge - who can solve

    Eirikur Eiriksson (5/13/2016)

    TheSQLGuru (5/11/2016)

    Alan.B: You have escaped the primary performance problem of chewing through unnecessary rows of each month on the date dim table with the filtered index. Well done....

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 13, 2016 at 10:30 pm

    #1879077

  • RE: Scripts Library

    Lynn Pettis (5/13/2016)

    Alan.B (5/13/2016)

    Lynn Pettis (5/13/2016)

    Actually, yes. I have seen that a couple of script authors have posted scripts in multiple parts but it is difficult to find them...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 13, 2016 at 10:08 pm

    #1879076

Viewing 15 posts - 691 through 705 (of 2,462 total)