Forum Replies Created

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

  • 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

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

    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. This makes sense,...

    "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 9:28 pm

    #1879073

  • RE: Scripts Library

    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 since there are...

    "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 8:01 pm

    #1879069

  • RE: Transactional Replication, Log Shipping, Redgate: Getting data from point A to point B without changing the target database design and file system...

    I tried both Transactional Replication and Log Shipping, but both methods end up making the Target database exactly like the Source (e.g. data, table design, and file system).

    That's basically...

    "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 7:57 pm

    #1879068

  • RE: plan for installation SSRS

    sqlfriends (5/13/2016)

    We are implementing a project and need to setup a new SQL server.

    The server probably will be used only for this project at least now.

    It has database...

    "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 7:38 pm

    #1879066

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