Forum Replies Created

Viewing 15 posts - 406 through 420 (of 2,458 total)

  • RE: Deleted

    chocthree (10/16/2016)

    1) Which type of BI will provide the most job security (i.e. MS, Hadoop, etc)? Not fussed about high salary but just the demand of jobs.

    SSAS, Hadoop 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

    October 18, 2016 at 8:20 pm

    #1907309

  • RE: Talking baseball

    Ray K (10/14/2016)

    Tried to stay up last night to watch Dodgers vs. Nationals Game 5. I made it to the 8th inning before I finally gave up and went...

    "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

    October 14, 2016 at 5:36 pm

    #1906729

  • RE: Today's Random Word!

    djj (10/14/2016)

    whereisSQL? (10/14/2016)

    ThomasRushton (10/14/2016)

    djj (10/14/2016)

    Lynn Pettis (10/14/2016)

    Kaye Cahs (10/14/2016)

    djj (10/14/2016)

    Grumpy DBA (10/14/2016)

    djj (10/14/2016)

    crookj (10/13/2016)

    Bang

    Drum

    Slowly (anyone get this reference?)

    Book

    Worm

    Fish

    Fry

    Day

    Happy

    Excited

    incited

    "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

    October 14, 2016 at 10:25 am

    #1906626

  • RE: Split String On Delimiter

    Luis Cazares (10/14/2016)

    Here's a simple option using the DelimitedSplit8k that can be found here along with its explanation: http://www.sqlservercentral.com/articles/Tally+Table/72993/

    A specific function could be made to split only on the 7th...

    "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

    October 14, 2016 at 8:32 am

    #1906581

  • RE: Select all child nodes

    Jeff Moden (10/6/2016)

    Alan.B (10/6/2016)

    No need to use the Query method, it would be more efficient to just use value like this:

    SELECT Id ,

    ...

    "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

    October 7, 2016 at 2:01 pm

    #1905460

  • RE: Talking baseball

    "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

    October 7, 2016 at 11:57 am

    #1905441

  • RE: Splitting a multi-delimiter string and update

    Mike-342950 (10/6/2016)

    This is great! I have one question. Since the values are in a table already, would I still need a temp table?

    No. The temp table is just so you...

    "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

    October 6, 2016 at 1:05 pm

    #1905258

  • RE: Good hardware-slow performance. Possibly misconfigured.

    Mostly one Filegroup has one Data File.

    Log file is on L:\ drive

    But one huge 563 GB data file 'Scene_Data2' also lives in L:\ drive.

    Probably interfering with Log file.. or it...

    "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

    October 6, 2016 at 1:00 pm

    #1905257

  • RE: Can I allow a user to select nothing a multi-valued parm?

    This is pretty simple. You would just add a <None> option to your parameter drop-down; have a look at this:

    -- table that provides the parameter options

    DECLARE @yourtable TABLE (val...

    "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

    October 6, 2016 at 12:02 pm

    #1905243

  • RE: Talking baseball

    Ray K (10/6/2016)

    calvo (10/6/2016)

    Any last thoughts before these series begin to play out?

    I'm rooting for anyone except Boston! 😛 😀

    Good. You a Cubs fan now. Go Cubs!

    "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

    October 6, 2016 at 10:19 am

    #1905219

  • RE: Select all child nodes

    No need to use the Query method, it would be more efficient to just use value like this:

    SELECT Id ,

    XmlCol.value('(text())[1]',...

    "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

    October 6, 2016 at 10:18 am

    #1905218

  • RE: Solving FIFO Queues Using Windowed Functions

    Great, great work Drew. Very 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

    October 6, 2016 at 8:37 am

    #1905190

  • RE: Recommendation for better perfromance

    ramyours2003 (10/4/2016)

    HI

    I need recommendations for better performance of sql .we have 32bit SQL servers and want to make sure we have them configured optimally for performance. We...

    "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

    October 5, 2016 at 6:42 pm

    #1905071

  • RE: Setting Up Reporting Services

    amy26 (10/5/2016)

    But the report viewer is only available "intranet" its not available on the internet... our website is public facing. The database server is not accessible from the outside....

    "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

    October 5, 2016 at 9:05 am

    #1904940

  • RE: Setting Up Reporting Services

    Part of the SSRS setup is configuring a Report Server URL. This is something you can also do after SSRS is set up. The Report Server URL is where you...

    "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

    October 5, 2016 at 8:27 am

    #1904923

Viewing 15 posts - 406 through 420 (of 2,458 total)