Forum Replies Created

Viewing 15 posts - 646 through 660 (of 2,462 total)

  • RE: First PASS Event

    I was looking for any advice as to how I could get the most out of this event and future ones in terms of technical information exchange

    Forgive me for being...

    "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

    June 14, 2016 at 7:53 pm

    #1885072

  • RE: SQL Calendar Table based on Start and End Date Help

    If you want to make the performance even better you can create a table that stores the required start/end dates and write a function uses it. In the example below...

    "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

    June 14, 2016 at 11:34 am

    #1884975

  • RE: Data Mining Part 39: Azure Machine Learning vs Microsoft Data Mining

    Great article, I love the series!

    For Microsoft Data Mining you need to purchase the Enterprise or the Business Intelligence Editions.

    Not any more. Now Developer Edition is free for...

    "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

    June 14, 2016 at 8:26 am

    #1884908

  • RE: Generate dynamic multilevel XML file from SQL Server table

    I'm going to see if I can do this. In the meantime, if anyone else wants to try I've created some more usable sample data.

    SET NOCOUNT ON;

    IF OBJECT_ID('tempdb..#Products') ...

    "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

    June 13, 2016 at 8:35 pm

    #1884806

  • RE: Function to get Number from word

    If you go the mapping table route do a search for "cardinal ordinal number list" or "... chart"... You may get lucky as someone out there may have already 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

    June 13, 2016 at 10:55 am

    #1884722

  • RE: SQL Calendar Table based on Start and End Date Help

    For a work-table free, sort-free, purely set-based way of handling this you could use getnumsAB[/url] and do this:

    DECLARE @STARTDATE DATETIME = '06/05/2016',

    @ENDDATE...

    "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

    June 13, 2016 at 10:27 am

    #1884714

  • RE: T-SQL find unique records

    durga.palepu (6/13/2016)

    Thanks, that's awesome solution.

    Your approach to provide hints so that I would work on actual solution is excellent so that I could learn my self.

    Here follow's my solution implementations:

    using...

    "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

    June 13, 2016 at 10:13 am

    #1884711

  • RE: FOR XML PATH

    Just to add to what R.P. Rozema said...

    Here is a good article about this technique for concatenating a string using this method: Creating a comma-separated list (SQL Spackle)[/url].

    "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

    June 13, 2016 at 9:56 am

    #1884707

  • RE: Join of two tables with sums of two different fields grouped by CustomerID

    briancampbellmcad (6/13/2016)

    I'm not following the placing of the literal amounts into the SQL. Shouldn't I just be using field names

    He's putting the example data into CTEs... It's the same as...

    "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

    June 13, 2016 at 9:44 am

    #1884703

  • RE: DBA career advice

    MikeS. (6/10/2016)

    It's funny you should bring up the subject of 'nolock' -- at most places I've worked, it's a big no-no. At my current job, you'll get your hand...

    "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

    June 10, 2016 at 8:12 pm

    #1884493

  • RE: UDF slow even when used as a persisted computed column

    Comment removed.

    I missed the whole second page of this discussion...

    "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

    June 10, 2016 at 1:15 pm

    #1884478

  • RE: Nasty Fast PERCENT_RANK

    Mike Is Here (6/9/2016)

    Great article.

    Thank you very much. 😀

    So now we know the window aggregate function is the culprit. Since we’re not partitioning the data yet (but will in a...

    "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

    June 9, 2016 at 7:18 pm

    #1884270

  • RE: How Long Before Your Database Runs Out of Space?

    Nice article John. 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

    June 9, 2016 at 7:12 am

    #1884095

  • RE: Stairway To SQL Server Columnstore Indexes Level 1: A First Look At Columnstore Indexes

    Great article Hugo. Very well researched and written. I just started the series and look forward to the rest.

    I have neen reading up on columnstore indexes recently and just read...

    "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

    June 8, 2016 at 7:57 pm

    #1884047

  • RE: Nasty Fast PERCENT_RANK

    Jeff Moden (6/7/2016)

    From the Article:

    Bring on the one million row test harness!!!

    Heh... I love it! It's like a war cry! 😀

    Very cool article, Alan. Well done.

    Hat's off...

    "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

    June 8, 2016 at 10:53 am

    #1883949

Viewing 15 posts - 646 through 660 (of 2,462 total)