Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 5,502 total)

  • RE: How to calculate open trade exposure?

    I tried to find the data in the tables used in your verbal description. But I couldn't.

    You should start offering a voucher for the person that would provide 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]

    January 27, 2011 at 11:55 am

    #1279283

  • RE: Input data with mulit records for a parameter.

    Please don't crosspost.

    No further replies please.

    Discussion already started 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]

    January 27, 2011 at 11:37 am

    #1279274

  • RE: Input data with mulit records for a parameter.

    edit: duplicate post reply moved to the "twin post"


    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 27, 2011 at 11:36 am

    #1279273

  • RE: Input data with mulit records for a parameter.

    Edit: double post


    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 27, 2011 at 11:35 am

    #1279270

  • RE: Stump on why this statement ever performs well 1 day 5 minutes next day a second.

    Carlton B Ramsey (1/27/2011)

    Please see the attached actual execution plans. One useing the address search and the other useing a taxid search.

    The address search tool around 5 minutes the taxid...


    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 27, 2011 at 11:00 am

    #1279244

  • RE: Get data from a string

    @PSB:

    Did you actually read my previous reply? My comment stands as it is. Reposting it won't change 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 27, 2011 at 10:51 am

    #1279236

  • RE: Get Date,Month from varchar dates

    PSB (1/26/2011)

    I will confirm that if I can add persisted columns. Can you please explain how to do that ?

    Here's one way how to do it.

    You could also search 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]

    January 27, 2011 at 10:38 am

    #1279223

  • RE: Performance difference between different users calling the same stored procedure?

    First of all: you did an excellent job setting up the test scenario and collecting the data!

    What I would do as a next step is to compare the actual execution...


    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 26, 2011 at 4:19 pm

    #1278853

  • RE: Get Date,Month from varchar dates

    PSB (1/26/2011)

    I was not the one to create the tables.

    "It wasn't me" is not a valid answer. 😉

    The question is: can you change it? If not the column data type,...


    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 26, 2011 at 3:50 pm

    #1278842

  • RE: Quick For XML Path Question

    At a first glance there should be an easier solution.

    But, like others, I prefer to test my solution before posting.

    So, please provide table def, sample data and expected result as...


    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 26, 2011 at 3:38 pm

    #1278831

  • RE: Is there a simipler way of filtering by current month

    SQL Iron Chef (1/26/2011)

    you are a genius.

    i forgot my code won't be using an index with that datepart.

    thanks!

    :blush:

    Naah... I'm just trying to return what I've learned over the years hanging...


    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 26, 2011 at 3:30 pm

    #1278829

  • RE: Get Date,Month from varchar dates

    I'm sorry but I have to ask: since you posted on a SS2K8 version, why don't you use the DATE and TIME data type to store the info you need?

    If...


    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 26, 2011 at 3:26 pm

    #1278826

  • RE: Is there a simipler way of filtering by current month

    Here's how I'd do it:

    SELECT something

    FROM someentity

    WHERE somedate>= DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)

    Please note that I removed the datepart function from the source column to make it SARG-able (= to allow for an index...


    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 26, 2011 at 3:17 pm

    #1278822

  • RE: Get data from a string

    PSB (1/26/2011)

    It fails with string

    5305 ...


    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 26, 2011 at 3:10 pm

    #1278819

  • RE: How to determine if one timespan crosses another

    Here's one solution including a complete test setup:

    You'd need to decide how to deal with timespans that end/begin exactly at the beginning/end of the previous/next timespan. Adjust the < 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]

    January 26, 2011 at 2:45 pm

    #1278807

Viewing 15 posts - 1,996 through 2,010 (of 5,502 total)