Forum Replies Created

Viewing 15 posts - 211 through 225 (of 5,502 total)

  • RE: Replace code in SP

    Can you please explain why you neither want to use the view nor the underlying code itself?

    Also, what you've posted is not a sp but single SELECT statement.

    There's no simple...


    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, 2014 at 5:55 am

    #1709029

  • RE: Replace code in SP

    Something like this?

    SELECT TOP (@topval) dbo.bigtb.fire, dbo.maingroup.maingroup, dbo.bigtb.subgroup, dbo.maingroup.groupnamefa, dbo.subgroup.subgroupfa, dbo.bigtb.title1,

    ...


    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, 2014 at 5:01 am

    #1709026

  • RE: Adding parameters to SQL in Excel

    ...

    Design the query using msquery (in excel tools-> data -> get external data then select the dsn/odbc link).

    Any criteria fields in the msquery should have a value of []. 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]

    April 27, 2014 at 4:59 am

    #1709025

  • RE: Avoid Loading the same Excel File twice to a OLE DB Destination

    What do you mean by "loading twice"?

    Does the current loop perform the "double load" or does it happen when the SSIS package is restarted?

    There are several options to avoid 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]

    April 27, 2014 at 3:14 am

    #1709024

  • RE: how to setup SQL instance

    If you have SSMS (SQL Server Management Studio) installed, you can connect to a SQL Server instance on another machine if the machine allows access (SQL port open, usually port...


    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, 2014 at 3:04 am

    #1709022

  • RE: Need to mingle different select statements into one (Stored procedure)

    How about using UNION ALL to merge the three results into one?


    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, 2014 at 1:47 pm

    #1708998

  • RE: Distribution of data, percentile curve.

    What do you mean by

    I am disappointed in the performance

    ?

    Would you please post some sample data (table def and sample data) together with your actual execution plan so 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 26, 2014 at 1:46 pm

    #1708997

  • RE: Broker_Receive_Waitfor

    The WAITFOR has a parameter @p2 for a timeout. What's the value of this parameter?

    The process did wait for 15+ seconds to get new data.

    Without knowing what is triggered by...


    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, 2014 at 1:40 pm

    #1708995

  • RE: SysAdmin server role and Active Directory Groups

    Usually, AD group memberships is controlled without the need for confirmation from a DBA - for a very good reason, since the SBA should not be concerned about a member...


    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, 2014 at 1:17 pm

    #1708993

  • RE: Find rows in table A which do not exist in table B.

    By definition, there is no "first row" in a table. It all depends on the columns in the ORDER BY section of the SELECT statement, what row will be presented...


    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, 2014 at 6:21 am

    #1708741

  • RE: Optimizing Query

    I'm still waiting for a description of the business rule how to sort the rows (without the term "priority").


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

    #1708206

  • RE: Replacing UNION in TSQL 2012

    Did you try the solution I provided?

    If the league table can have duplicates, keep the UNION ALL and change the league query to

    SELECT L.LeagueID as PlayerID, L.LeagueName as PlayerName

    FROM #league...


    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, 2014 at 2:33 am

    #1707989

  • RE: Replacing UNION in TSQL 2012

    Here's an approach using the OUTER APPLY operator available since SQL 2008 (so, it's nothing new in 2012 ...).

    Please note that I changed UNION to UNION ALL for the query...


    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 22, 2014 at 4:37 pm

    #1707928

  • RE: Pulling incorrect records using date range in where clause

    The AND operator has a higher precedence than the OR operator leading to the following logic:

    where (ath_postype = 'NTC') or (ath_postype='NTD' and

    ath_postdate >= '2013-01-01 00:00:00' and

    ath_postdate <= '2013-01-05 23:59:59')

    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]

    April 22, 2014 at 3:22 pm

    #1707923

  • RE: Optimization not enough

    The View [DML].[ExtOLSMachineEntitlement] refers to a table DML.ExtOLSMachine.

    You might want to take the effort to have a look at your execution plan... -> The table is indeed referenced.

    I guess...


    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 22, 2014 at 2:49 pm

    #1707918

Viewing 15 posts - 211 through 225 (of 5,502 total)