Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 2,462 total)

  • RE: Help on Performance issue on Recursive CTE

    haiao2000 (10/10/2012)

    XMLSQLNinja (10/10/2012)

    You should post the actual DDL.

    From what I see you could make this faster using the Local Updateable Variable approach (e.g. the 'Quirky Update')... See http://www.sqlservercentral.com/articles/T-SQL/68467/

    Alen,

    I updated...

    "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 10, 2012 at 3:57 pm

    #1547838

  • RE: Help on Performance issue on Recursive CTE

    Homersdonut (10/10/2012)

    A co-worker analyzed CTE performance in SQL Server 2005 and determined it begins to degrade after, if I recall, 100,000 records.

    As we encounter performance related issues in production which...

    "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 10, 2012 at 3:56 pm

    #1547837

  • RE: Re-creating users after database restore

    SQL Guy 1 (10/10/2012)

    Thanks for quick replies.

    Alan: I cannot create a real table, because this db will be restored, and the table will be gone. About SSIS, frankly...

    "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 10, 2012 at 3:45 pm

    #1547834

  • RE: Help on Performance issue on Recursive CTE

    You should post the actual DDL.

    From what I see you could make this faster using the Local Updateable Variable approach (e.g. the 'Quirky Update')... See http://www.sqlservercentral.com/articles/T-SQL/68467/

    "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 10, 2012 at 3:20 pm

    #1547828

  • RE: Re-creating users after database restore

    SQL Guy 1 (10/10/2012)

    Here is my scenario: I backup a production database and restore it to dev environment. But after the database is restored, I don't want to have...

    "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 10, 2012 at 3:09 pm

    #1547824

  • RE: Query Help

    yogi123 (10/10/2012)

    Hello Everyone

    I Have one task, in that there are two tables,

    one has student testing dates

    and other has student enrollment dates.

    CREATE TABLE #TestDates

    (

    iSchoolYearCode int NOT NULL,

    dtStartDate DATETIME NOT NULL

    )

    insert into...

    "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 10, 2012 at 2:52 pm

    #1547815

  • RE: Regular expression in T-sql

    Jeff Moden (10/3/2012)

    XMLSQLNinja (10/3/2012)

    In the same article he does recommend, for example, using a CLR for regexs (he includes a couple in the article). He tests the regex CLR vs...

    "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, 2012 at 8:45 pm

    #1545306

  • RE: Regular expression in T-sql

    p.s. thanks jeff for the link... I am still reading that (very long) thread. Great stuff.

    "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, 2012 at 4:23 pm

    #1545261

  • RE: Regular expression in T-sql

    bteraberry (10/3/2012)

    The Dictionary.com definition of kludge:

    a software or hardware configuration that, while inelegant, inefficient, clumsy, or patched together, succeeds in solving a specific problem or performing a particular task

    I would...

    "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, 2012 at 4:20 pm

    #1545257

  • RE: Replication ISSUES

    deebabat (10/3/2012)

    Ok. We're getting somewhere.

    Re: missing tables-You will need to create a subscription to the second publication to get those tables. Each subscription can only subscribe to one publication.

    Re:...

    "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, 2012 at 2:13 pm

    #1545205

  • RE: Replication ISSUES

    deebabat (10/3/2012)

    I am getting the table from one publication but some of the tables are empty, I'M NOT getting any table from the second publication at all.

    ... one other...

    "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, 2012 at 1:20 pm

    #1545183

  • RE: Replication ISSUES

    deebabat (10/3/2012)

    I am getting the table from one publication but some of the tables are empty, I'M NOT getting any table from the second publication at all.

    Ok. We're getting...

    "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, 2012 at 1:18 pm

    #1545179

  • RE: Replication ISSUES

    deebabat (10/3/2012)

    I have two publications but one subcription

    Are you getting all the tables from one publication and not the other?

    "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, 2012 at 1:02 pm

    #1545170

  • RE: Regular expression in T-sql

    Eugene Elutin (10/1/2012)

    A couple of us just went through all of this on another thread a couple of months ago and the LIKE expressions blew the doors off the RegEx...

    "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, 2012 at 6:02 am

    #1543934

  • RE: Regular expression in T-sql

    Jeff Moden (9/28/2012)

    XMLSQLNinja (9/28/2012)

    bteraberry (9/28/2012)

    Microsoft invested a huge amount of effort/time/money into CLR to give us tremendous capabilities. I have been told by someone close to the SQL dev...

    "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 29, 2012 at 9:09 am

    #1543697

Viewing 15 posts - 2,371 through 2,385 (of 2,462 total)