Forum Replies Created

Viewing 15 posts - 1,861 through 1,875 (of 2,458 total)

  • RE: Performance of the new (2014) Cardinality Estimator

    Eirikur Eiriksson (10/4/2014)

    Alan.B (10/2/2014)

    I have a few dev boxes running 2014 and have have experienced some instances where 2014 is giving me a parallel query plan where on 2012 I...

    "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, 2014 at 7:31 pm

    #1750457

  • RE: Report never stops loading, Out of Memory Error

    mballentine (10/3/2014)

    I found the solution. In case anyone else has this problem go to http://support2.microsoft.com/kb/115237.

    Thanks for posting that ddl and other info. Sorry I did not reply sooner; if not...

    "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 3, 2014 at 2:36 pm

    #1750096

  • RE: Parameters

    edward_hall76 (10/3/2014)

    I am working on an ssrs report and they want to be able to search by 3 parameters City, zip code and state and have it where you can...

    "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 3, 2014 at 10:45 am

    #1750033

  • RE: Report never stops loading, Out of Memory Error

    Do you have any DDL/Sample data for the three tables in question?

    Can you post the query plan for the ad-hoc SQL or Stored proc that drives this report?

    "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 3, 2014 at 10:28 am

    #1750030

  • RE: Using the WMI Event Watcher Task in SSIS to Process Data Files

    I know this was originally published a while back but I just read through it; it solves a problem I have been struggling with.

    Very well written. Clear and to...

    "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 3, 2014 at 4:57 am

    #1749914

  • RE: fast_forward cursors are read only but are they insensitive?

    I don't know; wish I could tell you. I'm replying to this post because no one else has.

    Here's a great article by Itzek Ben Gan that will get you on...

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

    #1749860

  • RE: Performance of the new (2014) Cardinality Estimator

    I have a few dev boxes running 2014 and have have experienced some instances where 2014 is giving me a parallel query plan where on 2012 I get a serial...

    "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 2, 2014 at 5:56 pm

    #1749859

  • RE: indexes - How many are too many?

    Just to add to what everyone has said... any index that does not get used is one index too many. This is a huge topic but here's a few rules...

    "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 2, 2014 at 5:44 pm

    #1749856

  • RE: Text next to plus sign for subreport

    You can add a tooltip. I don't have access to ssrs 2005 at the moment but I'm pretty sure you can't add a tool tip directly to the plus sign....

    "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 2, 2014 at 5:04 pm

    #1749854

  • RE: Reporting against a cube -- where to find / how to build one?

    pietlinden (10/1/2014)

    Is there any alternative to building your own SSAS cubes to report against? I would have sworn that SSAS creates an object that can be reported on 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

    October 2, 2014 at 11:04 am

    #1749756

  • RE: Reporting against a cube -- where to find / how to build one?

    pietlinden (10/1/2014)

    Is there any alternative to building your own SSAS cubes to report against? I would have sworn that SSAS creates an object that can be reported on 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

    October 2, 2014 at 11:04 am

    #1749757

  • RE: Data Compression and Snapshot Isolation

    Good article, very interesting.

    "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 2, 2014 at 3:48 am

    #1749637

  • RE: Remove non alpha chars from a column

    Some day we might have the ANSI/ISO Standard TRANSLATE()

    In the meantime you can use the one that I created.

    I am working on an article I plan to submit...

    "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 1, 2014 at 6:13 pm

    #1749576

  • RE: Nightly Job Failing to Truncate Transaction Log

    As a general note, I suggest looking through this free book (free when downloaded as PDF): SQL Server Transaction Log Management by Tony Davis and Gail Shaw. It's the best...

    "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 1, 2014 at 11:05 am

    #1749465

  • RE: how to show tooltip or message in parameter area in ssrs 2012

    how to show tooltip for parameter values in ssrs 2012?

    how to show hardcoded message in parameter area in ssrs 2012?

    You can't (not without making serious changes to your...

    "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

    September 30, 2014 at 12:35 pm

    #1749244

Viewing 15 posts - 1,861 through 1,875 (of 2,458 total)