Forum Replies Created

Viewing 15 posts - 3,676 through 3,690 (of 5,502 total)

  • RE: How To Send Message To All Connected User On Insert In A Table

    Basically, the SB does the same like the job that did run every minute (data transfer across servers and email notification).

    I haven't had the need to call an external application...


    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]

    April 26, 2010 at 12:47 pm

    #1157808

  • RE: How To Send Message To All Connected User On Insert In A Table

    Lowell (4/26/2010)

    ...

    in the past, you used to be able to use NET SEND to all the machines on a network; however, because of someone adapting that to throw spam around,...


    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]

    April 26, 2010 at 12:10 pm

    #1157782

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/26/2010)

    The question is: is it still required to store the successful import into PermitsInserted?

    It is still required because not ALL of the records are getting converted. There were some...


    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]

    April 26, 2010 at 10:14 am

    #1157723

  • RE: secure database to application role

    antonio jv (4/23/2010)

    I have a book "Microsoft SQL Server 2005" but it does not cover all answers and more a read others opinions more confused it gets (SQL Server). I...


    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]

    April 25, 2010 at 7:37 am

    #1157384

  • RE: How to tune/speed up a procedure

    Hmmmm, .....

    It seems like there is not much more room for speeding the current query up...

    The question is: is it still required to store the successful import into PermitsInserted?

    Basically, we...


    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]

    April 24, 2010 at 4:52 pm

    #1157350

  • RE: Speed improvement help needed for large xml queries

    @jeff: it's not that I'm actually advertising XML, I'm sure not. 😉

    I just had to get used to it in order to get those "man in the middle" out of...


    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]

    April 24, 2010 at 3:46 pm

    #1157342

  • RE: Speed improvement help needed for large xml queries

    Jeff Moden (4/24/2010)

    ...

    Heh... I'll take that correction... thanks, Lutz. I should have said that both XML and CSV's are a form of denormalization that should be avoided in favor...


    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]

    April 24, 2010 at 10:20 am

    #1157284

  • RE: Speed improvement help needed for large xml queries

    Jeff Moden (4/23/2010)

    ...

    I agree. IMHO, storing raw XML is as bad or worse than storing CSV's. Both are denormalized... both require special handling... neither can be optimized.

    I believe...


    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]

    April 24, 2010 at 2:29 am

    #1157239

  • RE: CROSS TAB Query Question.

    Rob Schripsema (4/23/2010)

    As Imu92 said, you don't give us a lot of details about how the data will look, but assuming it is all consistent with your sample and there...


    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]

    April 23, 2010 at 5:21 pm

    #1157178

  • RE: Get summary count for multiple columns

    You could use UNPIVOT followed by a PIVOT statement. See BOL (BooksOnLine, the SQL Server help system usually installed together with SQL Server) for details or post some ready to...


    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]

    April 23, 2010 at 4:51 pm

    #1157173

  • RE: CROSS TAB Query Question.

    Assuming Amount_1 and Amount_2 will always be in a consistent order (ege. being able to sort it by and ID column which is unfortunately not present (or at least not...


    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]

    April 23, 2010 at 4:46 pm

    #1157170

  • RE: Speed improvement help needed for large xml queries

    Would it be possible for you to shred the xml files into relational table(s) (including proper indexing)? Maybe just with holding the values queried frequently?

    A question on top: Do you...


    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]

    April 23, 2010 at 2:51 pm

    #1157145

  • RE: Speed improvement help needed for large xml queries

    Is this thread related to your other recent one by any chance? 😉


    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]

    April 23, 2010 at 1:41 pm

    #1157115

  • RE: Are the posted questions getting worse?

    Tom.Thomson (4/23/2010)

    lmu92 (4/23/2010)

    This OP "really appreciates" help

    I looked at the thread Lutz, and to me it looks as if it's not lack of appreciatiuon it's standard American misuse...


    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]

    April 23, 2010 at 1:27 pm

    #1157112

  • RE: Speed improvement help needed for large xml queries

    I'm not sure if this will help performance... but it's worth a try 😉

    DECLARE @var INT

    SET @var = 100;

    WITH XMLNAMESPACES ('http://schemas.somedomain.com/infopath/2003/appname' AS my)

    SELECTc.value('../my:PECode[1]','varchar(20)') AS PECode

    FROM@tbl tbl

    CROSS APPLY

    tbl.DocumentXML.nodes('/my:myFields/my:SelectedProductID[text()=sql:variable("@var")]') T(c)

    WHERE

    ...


    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]

    April 23, 2010 at 1:11 pm

    #1157108

Viewing 15 posts - 3,676 through 3,690 (of 5,502 total)