Forum Replies Created

Viewing 15 posts - 1,726 through 1,740 (of 5,502 total)

  • RE: OpenRowSet issues

    Is it possible the Excel file is still open (= in use by another application)?


    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 29, 2011 at 12:44 pm

    #1305091

  • RE: how to join to another table when you need to see the data from the second tables column without increaseing the record count when the tables have a 1 to many relationship

    You could use

    Select DISTINCT a.*,b.SubmissionBatchID

    If you still get more than 2219944 then you have more than one distinct value of b.SubmissionBatchID per submissionID.

    As a side note: I...


    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 29, 2011 at 12:34 pm

    #1305086

  • RE: Database connection

    Would you please be a little more specific? What error message (exactly) do you get?


    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 29, 2011 at 12:18 pm

    #1305076

  • RE: Backup and Recovery - What are two options to validate whether or not a SQL Server backup will restore successfully?

    @SUPER SQL STAR:

    May I kindly ask you to change your avatar?

    The avatar you're using at the moment is connected to WayneS since "ages"...


    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 29, 2011 at 11:58 am

    #1305064

  • RE: Need Some Help with Basics

    Ninja's_RGR'us (3/29/2011)

    LutzM (3/29/2011)

    20. How to sum a column and make rename is something?

    Please ask your tutor to rephrase this question. It will make it easier for you to google 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]

    March 29, 2011 at 10:57 am

    #1305035

  • RE: Need Some Help with Basics

    20. How to sum a column and make rename is something?

    Please ask your tutor to rephrase this question. It will make it easier for you to google for an answer...

    [SET...


    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 29, 2011 at 10:50 am

    #1305026

  • RE: Weird behavior with stored proc with two output parameters

    Are you sure this qustion belongs to a SQL forum? :ermm:

    Probably better to ask in a C# forum...


    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 29, 2011 at 10:42 am

    #1305024

  • RE: Indexed Computed Column Not Used to Perform Seek

    Wouldn't it be also an option just to remove the redundant CASE expression?

    Something like

    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]

    March 29, 2011 at 10:35 am

    #1305011

  • RE: Select query taking time

    Did you try the good old Divide'n'Conquer approach?

    As far as I see each subquery is limited by at least the TaskId = @TaskId condition, so you'd end up with smaller...


    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 28, 2011 at 10:33 am

    #1304471

  • RE: How to do proper tuning

    mattias 58533 (3/28/2011)

    Hi all experts!

    I have a machine that needs to be tuned perfectly.

    My questions: Are there any good sources/ebooks how to do this from the start?

    We don't have any...


    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 28, 2011 at 10:10 am

    #1304463

  • RE: Performance Problems

    You don't really expect us to analyze over 3000 lines in French(?), do you?

    It would be much more helpful if you could describe the kind of performance problems you're dealing...


    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 28, 2011 at 10:05 am

    #1304457

  • RE: Need to count Round date, URGENT!!

    That's just part of the stuff Wayne asked for...

    Please provide table def and sample data for dbo.MRec_Gather_Med_Reconcilation_1 as well as your expected output.


    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 28, 2011 at 9:49 am

    #1304449

  • RE: Need help in writing a query..Please help me out

    I would recommend to unpivot your table. While doing so, you should adjust the column size and/or data type (I don't think NVARCHAR(255) is an appropriate data type). Maybe even...


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

    #1304110

  • RE: HISTORIC SNAPSHOTS OF DATA - COUNT (*) - GROUP BY

    A conditional SUM() based on a calendar table should do 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]

    March 27, 2011 at 1:39 pm

    #1304105

  • RE: CTE vs Derived Tables

    Would you please post the query in total as well as some more test data (including expected result)?

    I'm confident it still can be done using a single CTE but I'd...


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

    #1303892

Viewing 15 posts - 1,726 through 1,740 (of 5,502 total)