Forum Replies Created

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

  • RE: Removing Non-Alphabetical Characters

    I think you were pretty close... You could do this:

    WITH removebadstuff(old,new) AS

    (

    SELECT LastName, replace(replace(replace(replace(replace(lastname,'#',''),'^',''),'/',''),'\',''),' -','')

    FROM #tmp_lastnames

    )

    SELECTold, -- old here for display only, not needed

    new =

    case patindex('%[a-z][^a-z]',new)

    when 0 then new...

    "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 9, 2014 at 10:00 am

    #1751368

  • RE: CHECKDB fails, then succeeds after restore to another instance

    Plucky (10/7/2014)

    Hi

    Occasionally (once every 3 months or so) CHECKDB fails on our busiest database on our VMware management SQL Server instance (this is a VM itself 10.0.5775). No other VMs...

    "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 9, 2014 at 8:44 am

    #1751324

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    samirabrahao1 60347 (10/7/2014)

    Hello Jeff, Paul, and everyone else involved in this discussion.

    I hope you are still following up on this. Great article indeed.

    I took the liberty to make a minor...

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

    #1750794

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

    GilaMonster (10/7/2014)

    Alan.B (10/6/2014)

    So it is whatever the default is - is what it is set at. I will tell you exactly tomorrow.

    Which means it'll be cost threshold of 5 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 7, 2014 at 12:38 pm

    #1750744

  • 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

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