Forum Replies Created

Viewing 15 posts - 661 through 675 (of 2,462 total)

  • RE: Nasty Fast PERCENT_RANK

    Ken Hiatt (6/7/2016)

    Thanks Alan, it's always fun to learn faster ways to do things, even if it's not something I expect to be using 🙂

    While my SQL programming skills 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

    June 8, 2016 at 10:51 am

    #1883946

  • RE: Nasty Fast PERCENT_RANK

    Thank you Kevin and Mauricio.

    "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 7, 2016 at 10:19 am

    #1883678

  • RE: Nasty Fast PERCENT_RANK

    Thanks Eirikur!

    "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 7, 2016 at 4:49 am

    #1883533

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

    Lowell (6/6/2016)

    DennisPost (6/6/2016)

    Hi Lowell,

    Thanks for taking the time to read and reply.

    That approach won't work for us as the server is set to UTC and we need to be able...

    "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 6, 2016 at 6:08 pm

    #1883488

  • RE: performance vs indexes

    To identify "missing undexes" and unused indexes have a look at:

    https://www.red-gate.com/library/performance-tuning-with-sql-server-dynamic-management-views

    It will give you some tools and ideas for proactive index monitoring.

    "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 6, 2016 at 4:46 pm

    #1883486

  • RE: Adding Time Intelligence to a Power BI Data Model

    Excellent article Adam, 5 stars. I've enjoyed your each of your Power BI articles as it's something I've needed to become familiar with lately. Great work.

    "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 6, 2016 at 9:58 am

    #1883406

  • RE: Translate function for SQL Server

    ChrisM@Work (6/1/2016)

    h.tobisch (6/1/2016)

    everything fine, but what's that checksum for ?

    Currently the fastest known method for converting a bigint to an int.

    I learned this technique from Eirikur Eiriksson. One of those...

    "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 1, 2016 at 4:58 pm

    #1882682

  • RE: Translate function for SQL Server

    ChrisM@Work (6/1/2016)

    Nice job Alan.

    A few years ago DC and I played with numerous variations of this method as a spinoff of the PatternSplit project. One of the most promising methods...

    "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 1, 2016 at 4:52 pm

    #1882681

  • RE: Split two delimited strings in table

    mikes84 (6/1/2016)

    I should have clarified. If it's part of a CTE, I can use a Tally table. I'm trying to avoid adding a physical table to the database as it'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

    June 1, 2016 at 1:07 pm

    #1882621

  • RE: It's time for a SQL Server 2016 Forum

    No more pre-coffee requests for me. I don't know why I didn't see it.:blush:

    "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 1, 2016 at 10:02 am

    #1882534

  • RE: Split two delimited strings in table

    First, why no Tally Table? Have there been complaints that your queries are too fast perhaps?

    OK, no other functions either, fine. Have a look at the article about APPLY referenced...

    "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 1, 2016 at 7:51 am

    #1882460

  • RE: Inserting XML

    I don't know why you get an error. This code

    CREATE TABLE Mytest (id INT, x XML)

    INSERT mytest

    VALUES

    (1, CAST('1200' AS XML))

    ...

    "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 31, 2016 at 8:42 pm

    #1882314

  • RE: Multiple Tablixes, only some refresh

    A couple thoughts...

    First, I believe there are refresh property settings on tablixes, double check the settings on those.

    Are you seeing this behavior in SSDT or when you deploy 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 31, 2016 at 5:19 pm

    #1882307

  • RE: What is SQL Fertilization any links?

    Grant Fritchey (5/31/2016)

    That's weird. It has to be a typo or a misinterpretation. They could mean normalization or optimization or... I've never heard of SQL Fertilization, so I've got nothing....

    "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 31, 2016 at 4:54 pm

    #1882306

  • RE: changing ALL font sizes on a chart

    One way to approach this is to do it in the code.First back up your report. Then, in SSDT or BIDS (whichever you're using), you could select "View Code" then...

    "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 31, 2016 at 12:30 pm

    #1882246

Viewing 15 posts - 661 through 675 (of 2,462 total)