Forum Replies Created

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

  • 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

  • RE: Today's Random Word!

    yb751 (5/30/2016)

    Ray K (5/27/2016)

    crookj (5/27/2016)

    A10

    A380

    Massive

    Attack

    "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 30, 2016 at 4:48 pm

    #1882053

  • RE: Improving performance of a query.

    Jim Covington (5/27/2016)

    In the IBM OS world, there is a view called a logical file. With a Logical file you can derive a subset of records and sort in...

    "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 27, 2016 at 8:19 pm

    #1881906

  • RE: Dynamically Query a 100 Million Row Table-Efficiently

    TheSQLGuru (5/27/2016)

    ChrisM@Work (2/24/2015)

    ... Two omissions stood out however - the cost of recompiling, ...

    I will jump through hoops to trade CPU ticks to avoid disastrously bad plans (and the horrible...

    "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 27, 2016 at 1:10 pm

    #1881880

  • RE: Dynamically Query a 100 Million Row Table-Efficiently

    Just finished this for the first time. Great work Gary! 5 stars.

    "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 27, 2016 at 9:33 am

    #1881815

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