Forum Replies Created

Viewing 15 posts - 5,101 through 5,115 (of 5,502 total)

  • RE: Importing data from flat file to SQL Table

    Is there any specific reason you have to use flat files (e.g. large amount of data using the performance gain of bcp)?

    Would it be possible to add the Cache database...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2009 at 11:32 am

    #1025812

  • RE: Is This The Best Way to Remove Duplicate Records ?

    ifila (7/15/2009)

    ...

    I ran the above code and am missing some records, when i do some before and after testing:(

    Thanks

    Isn't that an expected effect when running a DELETE statement? :ermm:

    If this...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 15, 2009 at 3:24 pm

    #1025396

  • RE: Tricky SQL Query Question

    Hi,

    attached please find a SQL2000 compliant solution. As far as I can see you need to use a subquery to get the order of the names...

    Just out of curiosity: What's...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 15, 2009 at 2:53 pm

    #1025368

  • RE: Help on how to shred, Xquery a docx in SQL 2005 SP2

    Would you mind to provide some sample data as an attachment so we can test if a solution someone may think of actually works and is giving the expected result?

    20...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 15, 2009 at 2:19 pm

    #1025352

  • RE: Temp DB Best Practices

    Please don't cross post.

    Answers please here .


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 14, 2009 at 4:21 pm

    #1024763

  • RE: Join with group by?

    You're welcome. Glad I could help. 🙂


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 14, 2009 at 4:13 pm

    #1024758

  • RE: Join with group by?

    Would something along those lines help?

    SELECT ar.ArchiveID,

    PublishedPosition,

    MAX(ar.SequenceID) AS SequenceID

    FROM dbo.tblArchiveRecords ar

    INNER JOIN dbo.tblPublishPosition pp

    ON ar.ArchiveID=pp.ArchiveId

    GROUP BY ar.ArchiveID,pp.PublishedPosition

    /*

    ArchiveIDPublishedPositionSequenceID

    1-9223372036854775808-9223372036854775806

    2-9223372036854775808-9223372036854775803

    3-9223372036854775808-9223372036854775800

    */


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 14, 2009 at 3:55 pm

    #1024752

  • RE: Is This The Best Way to Remove Duplicate Records ?

    As always, the answer is "it depends".

    If you refer to the first option in the article for deleting just one row I would agree that this is the best way.

    What...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 14, 2009 at 3:46 pm

    #1024747

  • RE: Join with group by?

    Hi,

    in addition to your DDL statements please provide sample data together with expected results and what you've tried so far.

    For details on how to post sample data please see the...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 14, 2009 at 3:24 pm

    #1024735

  • RE: Are the posted questions getting worse?

    GilaMonster (7/13/2009)

    Dave Ballantyne (7/13/2009)

    You can lead a horse to water but you cant force him to drink

    http://www.sqlservercentral.com/Forums/Topic751918-8-2.aspx?Update=1

    On second thoughts, I think I'm leaving that thread alone...

    tatcalltype ='null'

    Why.....

    He's back... ->...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 14, 2009 at 10:33 am

    #1024556

  • RE: slow update (primary key)

    You might have a missing index issue (probably missing for your temp table).

    We can't tell for sure since there is no more information available from your site.

    Please read and follow...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 14, 2009 at 10:29 am

    #1024553

  • RE: Sql query terminator(;)

    triple post.

    please see here and here . All posts have one answer so far, making it hard to tell where to continue if required...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 14, 2009 at 9:06 am

    #1024470

  • RE: Restrict user to use (;) in queries

    triple post.

    please see here and here . All posts have one answer so far, making it hard to tell where to continue if required...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 14, 2009 at 9:05 am

    #1024466

  • RE: Problem while executing Query batch

    triple post.

    please see here and here . All posts have one answer so far, making it hard to tell where to continue if required...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 14, 2009 at 9:04 am

    #1024463

  • RE: Querying huge amount of XML data hits performance

    How is the xml variable stored originally?

    Do you get it from an xml column, a flat file or anything else?

    Is there any known filter you could apply within your openquery...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 14, 2009 at 8:44 am

    #1024441

Viewing 15 posts - 5,101 through 5,115 (of 5,502 total)