Forum Replies Created

Viewing 11 posts - 5,491 through 5,502 (of 5,502 total)

  • RE: XML Manipulation Problem

    Hello James,

    I'm sorry that I didn't include some more information about the Tally table in the first place...

    The article mentioned above is one of my favorites on how to use...


    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]

    March 11, 2009 at 10:12 am

    #957634

  • RE: XML Manipulation Problem

    Hi,

    based on the split function as stated in the following post

    http://www.sqlservercentral.com/Forums/FindPost451474.aspx (which requires a tally table)

    I did some modification to that function to cover the order of appearence in 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]

    March 10, 2009 at 7:55 am

    #956795

  • RE: Urgent : Sql server db tuning

    Hi Musheik,

    another option to consider could be the use of XML format to transfer the data. Maybe your JAVA folks will look into this easier than extract into a a...


    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]

    March 9, 2009 at 2:22 pm

    #956395

  • RE: Production security for developers - 'emergency' updates

    At your company, who is currently in charge for maintaining CIA (Confidentiality, Integrity, Availability of data) an who will be after granting production access to developers?

    If the DBA group is...


    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]

    March 7, 2009 at 3:56 pm

    #955588

  • RE: "Answered" Posts

    Isn't any kind of ranking a subjective decision unless there are ranking rules that are widely accepted?

    Based on that I think in a forum like this one there are at...


    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]

    March 6, 2009 at 1:57 pm

    #955262

  • RE: Are the posted questions getting worse?

    From my point of view any type of best (or recommended) practice does not need to be mentioned as an "entry requirement for requests" unless there is any "reward" for...


    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]

    February 25, 2009 at 10:49 am

    #950148

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/24/2009)

    Alvin Ramard (2/24/2009)

    Yesterday was an interesting day on here. I don't think any of the posters were picked on, except for a quick reference to a White.house...


    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]

    February 24, 2009 at 3:09 pm

    #949667

  • RE: Are the posted questions getting worse?

    "There have been times it has seemed pointless to continue, but it is those 1 or 2 threads where the OP finally gets it that truly makes it worth it...


    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]

    January 28, 2009 at 4:37 pm

    #934324

  • RE: Are the posted questions getting worse?

    Post #645325

    Hi folks,

    sorry to post my reply to Lynn's "RFS" (request for sainthood) that late but I had to do some research and also had to BABELate my thoughts...


    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]

    January 28, 2009 at 4:02 pm

    #934299

  • RE: 16 digit unique number

    I think it's time for Paresh to get a little more specific...

    Several possible solution were posted, each one depending on the circumstances of usage.

    E.g. Barry's solution in my opinion...


    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]

    January 22, 2009 at 1:46 am

    #930925

  • RE: 16 digit unique number

    Hi,

    using the current system time to get a unique value is dangerous if the underlying server follows DST (daylight saving time).

    What happens if you generate a key around the switch...


    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]

    January 21, 2009 at 10:01 am

    #930497

Viewing 11 posts - 5,491 through 5,502 (of 5,502 total)