Forum Replies Created

Viewing 15 posts - 211 through 225 (of 2,458 total)

  • RE: How to find SSIS MetaData information ?

    subratnayak09 - Thursday, August 24, 2017 12:27 AM

    Hi Team I need to fetch SSIS MetaData information from sql server database .
    Please provide...

    "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

    August 24, 2017 at 9:56 am

    #1956656

  • RE: SQL 2008 - Extract parts of a string

    As pietlinden said, delimitedsplit8K is the way to go.  You could do something like this: 

    DECLARE @FieldName VARCHAR(50)
    SET @FieldName='#1550000#2099#14400#154006#15400#0#10#';

    SELECT
      Mon...

    "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

    August 23, 2017 at 7:33 pm

    #1956533

  • RE: SQL 2008 - Extract parts of a string

    Joe Torre - Wednesday, August 23, 2017 3:01 PM

    DECLARE
         @FieldName VARCHAR(50) = '#14400#14400#14400#14400#14400#0#0#' ;
    SELECT @FieldName;
    SELECT
         Substring(@FieldName, 2, 5) Monday
      ...

    "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

    August 23, 2017 at 7:25 pm

    #1956532

  • RE: Interactive sorting by calculated column percentage

    LAs Jeff zaid - your value is being sorted as text. You need to change the column data type to a percentage for that column.

    "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

    August 23, 2017 at 6:14 pm

    #1956527

  • RE: Optimize WHERE predicate

    vsamantha35 - Wednesday, August 23, 2017 1:55 PM

    Attaching Actual Execution plan executed from SQL Sentry plan explorer.

    For those of us without SQL...

    "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

    August 23, 2017 at 2:31 pm

    #1956500

  • RE: Optimize query that is using like statements

    John Mitchell-245523 - Tuesday, August 22, 2017 2:04 AM

    ollyjolly - Monday, August 21, 2017 10:04 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

    August 23, 2017 at 1:12 pm

    #1956479

  • RE: Optimize query that is using like statements

    ollyjolly - Monday, August 21, 2017 9:21 AM

    I currently have a large query which is taking over an hour to run, 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

    August 21, 2017 at 9:03 pm

    #1956076

  • RE: Speeding up Cross Apply on XML

    The best thing you can do is, if possible, lose the XML column, get this data into 3NF then index accordingly. If this is not an option then consider adding...

    "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

    August 14, 2017 at 11:36 am

    #1955205

  • RE: SQL Server Management Studio Tips

    Well done - great collection of useful info. 

    I will advise, however, developers avoid using GO for inserting sample data as it would be horrifically slow. 

    For example,...

    "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

    August 14, 2017 at 8:29 am

    #1955162

  • RE: INFORMATION_SCHEMA views

    I started using IS with SQL Server 2005 because I was told, or read somewhere, that they were better; I don't believe this anymore. I use them now more often...

    "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

    August 9, 2017 at 11:05 am

    #1954674

  • RE: What Department should Data teams fall under?

    This will differ from company to company based on the size of the company, it's governance and size. Often I've seen the database people (e.g. DBA, SQL/BI Developers/Data Scientists) as...

    "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

    August 9, 2017 at 8:55 am

    #1954654

  • RE: Fuzzy Search

    I always enjoy seeing different approaches to handling fuzzy matching in SQL Server. That said, there are many issues with this approach that I don't want to dive into that...

    "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

    August 7, 2017 at 10:00 am

    #1954335

  • RE: Why Scalar Functions Can Be Costly

    TheSQLGuru - Monday, January 4, 2016 7:02 PM

    Not even for Check Constraints since you can get bad data. Search for sql server...

    "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 26, 2017 at 8:38 am

    #1952791

  • RE: Why Scalar Functions Can Be Costly

    Jeff Moden - Saturday, June 3, 2017 8:44 AM

    Alan.B - Monday, January 4, 2016 11:16 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 26, 2017 at 8:28 am

    #1952785

  • RE: How to change existing column to a computed column

    Phil Parkin - Friday, July 21, 2017 9:00 AM

    binutb - Friday, July 21, 2017 7:54 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 21, 2017 at 9:38 am

    #1952132

Viewing 15 posts - 211 through 225 (of 2,458 total)