Forum Replies Created

Viewing 15 posts - 1,621 through 1,635 (of 5,502 total)

  • RE: freebcp and Named FIFO.

    opc.three (4/27/2011)

    FreeBCP? Are you on Linux or Unix?

    And if so, how did you manage to install SQL Server???


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

    #1316945

  • RE: Using TABLE VARIABLES TO perform this task

    Is there any specific reason to open a new thread every few hours for the same conceptual issue?

    For example http://www.sqlservercentral.com/Forums/FindPost1099849.aspx

    or http://www.sqlservercentral.com/Forums/FindPost1098387.aspx

    You're just wasting other resources since we might answer in...


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

    #1316943

  • RE: Find number of months in a span where record exists

    my pleasure!


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

    #1316939

  • RE: See the query in sp_execute

    Ninja's_RGR'us (4/27/2011)

    While we're at it... is there any way (other than a trace) to see all the queries run by a session between 2 dates?

    Or plan A.2 Is there 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]

    April 27, 2011 at 3:28 pm

    #1316935

  • RE: How to optimize Query

    I'd use a "slightly" different approach:

    Instead of HAVING(COUNT(*)>0) I'd use a CTE and the ROW_NUMBER() OVER(PARTITION BY CHAR_1 ORDER BY <insert_preferred_column> DESC) AS Row approach and query for Row>1.

    I'd insert...


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

    #1316930

  • RE: Custom Aggregate for statistical use

    Why using a CLR in the first place?

    Wouldn't something along those lines do the job, too?

    WITH sample_data AS

    (

    SELECT 0 AS n UNION ALL

    SELECT 2 UNION ALL

    SELECT 1

    ), cte AS

    (

    SELECT ...


    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 27, 2011 at 2:46 pm

    #1316909

  • RE: See the query in sp_execute

    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]

    April 27, 2011 at 2:26 pm

    #1316896

  • RE: Find number of months in a span where record exists

    Glad I could help 😀

    I'm not sure if the addtl. subquery to the sourcxe table is required.

    Couldn't you just use another condition like

    WHEN min(effdate)<=@startdate and max(termdate)<=dateadd(mm,-1,@enddate)...


    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 27, 2011 at 2:24 pm

    #1316895

  • RE: See the query in sp_execute

    Would the following script help?

    SELECT DEST.TEXT

    FROM sys.[dm_exec_connections] SDEC

    CROSS APPLY sys.[dm_exec_sql_text](SDEC.[most_recent_sql_handle]) AS DEST

    --WHERE SDEC.[most_recent_session_id] = 57

    Source: http://www.mssqltips.com/tip.asp?tip=1799


    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 27, 2011 at 1:56 pm

    #1316875

  • RE: Find number of months in a span where record exists

    Are you looking for something like this?

    SELECT

    carriermemid,

    CASE WHEN

    DATEDIFF(

    mm,

    CASE...


    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 27, 2011 at 1:27 pm

    #1316851

  • RE: Best way to normalize

    I don't think that a triangle. It's basically covering the range of values between two categories.

    I tried a similar approach in parallel but Lamprey13 did post his solution earlier. And...


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

    #1316319

  • RE: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

    Quite possible.

    That's one of the reasons I suggested to replace the trigger with a computed column (based on the requirement posted in the other thread). The INSTEAD OF option 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 26, 2011 at 4:14 pm

    #1316306

  • RE: Stored proc eating bandwidth on server!

    Query plan and index stats don't seem to indicate an issue with the sproc itself.

    Did you try a profiler trace on that specific sproc to verify if the pattern Craig...


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

    #1316304

  • RE: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

    Is this thread anyhow connected to your previous thread?

    If so, why do you post in a SQL2000 forum as well as in a SQ2005 forum? What version do you use?

    Would...


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

    #1316295

  • RE: Stored proc eating bandwidth on server!

    Please add the index definition for each table as well as the actual execution plan (as sqlplan file) of the sproc for each of the two conditions.


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

    #1316281

Viewing 15 posts - 1,621 through 1,635 (of 5,502 total)