Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 5,502 total)

  • RE: Count with inner joins

    On the other side: why bother calling a function in the first place instead of hardcoding the values in a subquery?

    INNER JOIN

    (SELECT 'AM' as [str] UNION ALL

    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]

    July 13, 2011 at 3:41 pm

    #1352505

  • RE: Count with inner joins

    table valued yes, but not in-line...

    I expected a string delimiter function.... 😉

    Search this site for DelimitedSplit8K to find a much better performing solution.


    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]

    July 13, 2011 at 3:24 pm

    #1352498

  • RE: Count with inner joins

    Ask the dev to change the function into an iTvF and use the CROSS APPLY approach.


    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]

    July 13, 2011 at 3:08 pm

    #1352493

  • RE: insert into problem

    Did you consider using the IDENTITY(1,1) option for the column?

    (please note that there might be gaps due to invalid inserts or deleted rows).

    If you need to have the values 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]

    July 13, 2011 at 2:43 pm

    #1352476

  • RE: Week Grand Total not equal to sum across 7 days

    How is a week defined? And is it the same definition that you use for verification?

    It might be an issue where NumberOfUsers of a Sunday is assigned to the wrong...


    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]

    July 13, 2011 at 10:46 am

    #1352295

  • RE: Is computed column more rapid than selects in select?

    Please don't call us "dudes" since this is not a low level chat room. It is a forum for professionals. I kindly ask you to respect it.

    Regarding the query itself:

    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]

    July 13, 2011 at 5:27 am

    #1352070

  • RE: Help! Migrated from Access to SQL Server 2005 - Can't see newly inserted records

    If you open a table using SSMS, the rows (usually) are ordered by the clusterd index. It's highly recommended to add an ORDER BY clause to the SQL string returned...


    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]

    July 13, 2011 at 12:50 am

    #1351970

  • RE: Variable causes extreme slowness - why

    Frankie-464050 (7/12/2011)

    Thanks for the link. Any way to get around this via hints or ?

    Yes. Read the article Gail pointed you 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]

    July 13, 2011 at 12:47 am

    #1351968

  • RE: How to print message after Update command in Stored procedure...

    Something like this?

    ALTER PROCEDURE [dbo].[Userupdate]

    @OldName varchar(256),

    @NewName varchar(256)

    AS

    Begin

    declare @rows varchar(38),

    @msg varchar(2000)

    update master set name1=@Newname where cstatus='Y' and name1=@Oldname

    set @rows = @@rowcount

    set @msg='No. of rows updated in name1 table is ' +@rows...


    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]

    July 13, 2011 at 12:46 am

    #1351967

  • RE: export all table to excel with header using bcp

    "is not working" is just not enough information...

    Would you mind posting the error message?


    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]

    July 13, 2011 at 12:41 am

    #1351965

  • RE: Need help optimizing the performance of a query

    Please provide all index definitions and thte actual execution plan of the query you're strugglnig with.


    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]

    July 12, 2011 at 10:43 am

    #1351762

  • RE: Storing multiple result sets from stored porcedure

    You could create two temp tables in the outer procedure (assuming there is one) and then insert the results into those tables in your testing sproc.


    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]

    July 12, 2011 at 3:29 am

    #1351469

  • RE: SQLMail Profile Error

    Do you really receive this message from SQL Server?

    Loks like an Outlook error message...


    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]

    July 11, 2011 at 2:52 pm

    #1351335

  • RE: loops

    ghanshyam.kundu (7/11/2011)

    u can use while loop instead of cursors, as cursors are always costlier.

    use a temporary table get all the values to temporary table process one by one using variable.

    ...


    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]

    July 11, 2011 at 6:58 am

    #1351053

  • RE: SQL Fast Track Data Warehousing

    Did you try a Google search? It seems like there are quite some articles out 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]

    July 11, 2011 at 4:24 am

    #1350984

Viewing 15 posts - 1,276 through 1,290 (of 5,502 total)