Forum Replies Created

Viewing 15 posts - 241 through 255 (of 2,462 total)

  • RE: SQL Server Maintenance Plan - Unable to Edit

    You have a couple options, none of which are super simple. 

    OPTION 1 - Edit in BIDS or SSDT
    As already mentioned, you can open the maintenance plan with...

    "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

    July 10, 2017 at 7:55 am

    #1950172

  • RE: Change SSN in textbox

    Luis Cazares - Friday, July 7, 2017 1:55 PM

    Is there any problem if we follow the logic from the original function? Or...

    "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

    July 7, 2017 at 2:17 pm

    #1950035

  • RE: Change SSN in textbox

    Eric's original solution did not address multiple instances of the same SSN-matching pattern but he fixed that. The only problem is when an SSN appears at the beginning or end...

    "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

    July 7, 2017 at 1:28 pm

    #1950028

  • RE: Problem with using a field parameter, in a user defined function

    SqlServerCampbell - Thursday, July 6, 2017 10:28 AM

    ScottPletcher - Thursday, July 6, 2017 9:55 AM

    "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

    July 6, 2017 at 11:12 am

    #1949780

  • RE: Cross Join Issue

    I'm not an MDX guru but, what you posted is not the complete MDX code. The complete statement would include (at least) a SELECT and an ON statement. The "Average...

    "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 28, 2017 at 1:26 pm

    #1948622

  • RE: How Can I Write A Query That Sums the Number of Occurrences Of a Value and Groups Them Into Ranges

    Jeff Moden - Tuesday, June 27, 2017 7:15 PM

    Alan.B - Tuesday, June 27, 2017 2:45 PM
    "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 28, 2017 at 12:55 pm

    #1948614

  • RE: Replace Bad Characters in Table

    Luis Cazares - Wednesday, June 28, 2017 7:00 AM

    I agree with franz, this will be slow. I´m not sure about the performance...

    "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 28, 2017 at 11:20 am

    #1948592

  • RE: Replace Bad Characters in Table

    t.franz - Wednesday, June 28, 2017 2:58 AM

    I doubt, that this will be fast. It does not use an explicit cursor, but...

    "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 28, 2017 at 10:24 am

    #1948586

  • RE: How to add cost per hotel and flight in duration cost table

    This seams pretty simple; what have you tried so far? Where are you stuck?

    "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 27, 2017 at 6:10 pm

    #1948469

  • RE: How Can I Write A Query That Sums the Number of Occurrences Of a Value and Groups Them Into Ranges

    Dang! Ed beat me to it. 

    I would add - for optimal performance you want this index in place: 

    CREATE INDEX nc_poc_employees_level ON dbo.employees(OrganizationLevel);

    "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 27, 2017 at 2:45 pm

    #1948450

  • RE: Good Book for SQL Server Reporting Services

    I dont know of any great SSRS books but The Microsoft Press book, SSRS Reporting services is fine. For me SSRS is the kind of thing I learn more by...

    "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 27, 2017 at 7:53 am

    #1948370

  • RE: Today's Random Word!

    ManicStar - Tuesday, June 27, 2017 7:24 AM

    Ed Wagner - Monday, June 26, 2017 3:54 PM
    "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 27, 2017 at 7:46 am

    #1948367

  • RE: SUBSTRING and CHARINDEX query.... please help.

    chocthree - Thursday, June 22, 2017 10:23 AM

    Thanks for your replies.
    I'm at a basic level using SQL so forgive me for my...

    "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 22, 2017 at 12:10 pm

    #1947827

  • RE: SUBSTRING and CHARINDEX query.... please help.

    I created a function called SubstringBetween8K which was designed for exactly this type of problem. It uses NGrams8K. Here's the function:


    CREATE FUNCTION [dbo].[substringBetween8K]

    "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 22, 2017 at 9:57 am

    #1947801

  • RE: Are the posted questions getting worse?

    I've been away for awhile wrapping up a project with some hard deadlines but that's all done and I'm back.

    "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, 2017 at 9:37 pm

    #1946872

Viewing 15 posts - 241 through 255 (of 2,462 total)