Forum Replies Created

Viewing 15 posts - 1,561 through 1,575 (of 5,502 total)

  • RE: Are both these select statements same?

    Please provide the actual execution plan as an attached sqlplan file. Maybe additional/different indexing will 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]

    May 15, 2011 at 2:46 pm

    #1324775

  • RE: Are both these select statements same?

    Which one provides the correct results?


    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]

    May 15, 2011 at 1:31 pm

    #1324756

  • RE: select from Local Temporary tables: Invalid object name

    Welsh Corgi (5/15/2011)

    Marc Bizzar (5/15/2011)

    "I'd guess the connection is closed and reopened leading to the temp table getting deleted in between."

    Perhaps I'm not understanding you correctly but the issue...


    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]

    May 15, 2011 at 11:58 am

    #1324738

  • RE: Problem please help me ?

    Sounds like mirroring with a dedicated witness server (see BOL, section "Overview of Database Mirroring").


    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]

    May 15, 2011 at 11:48 am

    #1324733

  • RE: Need right direction to load monthly data

    Like I said before: I recommend to get a consultant in for a day or two. It'll be much more efficient than using a forum. Based on the information currently...


    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]

    May 15, 2011 at 7:51 am

    #1324694

  • RE: select from Local Temporary tables: Invalid object name

    A local temp table is valid as long as the original connection exists and is visible to their creator. It is also possible to apply DML statements as long 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]

    May 15, 2011 at 7:46 am

    #1324693

  • RE: How to Schedule a Job in SQL Server Database Creation Script

    You could use a WINDOWS scheduled task calling a bcp out command with a trusted connection.

    Regarding details for bcp please see BOL (BooksOnLine, the SQL Server help syste usually installed...


    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]

    May 15, 2011 at 5:31 am

    #1324679

  • RE: Are both these select statements same?

    No.

    The first one will return more rows since you'll get rows returned on the left side of your join regardless whether t2.col2 is null or not.

    The second query will exclude...


    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]

    May 15, 2011 at 5:22 am

    #1324678

  • RE: After Update Trigger Only Fired for the first record in the IN close

    The issue is caused by your variable assignment. This will only affect rows that meet one criteria.

    Try the following instead:

    CREATE TRIGGER [dbo].[trg_LogStatus]

    ON [dbo].[Waybills]

    AFTER INSERT,UPDATE

    AS

    BEGIN

    SET NOCOUNT ON;

    INSERT INTO [dbo].[WaybillStatuses]

    ([WaybillId] ,[StatusId] ,[StatusDate]...


    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]

    May 15, 2011 at 4:56 am

    #1324675

  • RE: Need right direction to load monthly data

    If you don't know the relationship of the data, ask the person providing it or ask someone in your organization to explain the business case you're dealing with. It might...


    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]

    May 15, 2011 at 3:42 am

    #1324671

  • RE: Help please. SQL 2005 express sp1, sqlservr.exe high CPU usage

    Even if Because of he's your best friend you should not jeopardize his business software. Friendship is a personal relationship. Changing software his business might rely on is purely 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]

    May 14, 2011 at 4:54 am

    #1324614

  • RE: Issue With IF ELSE Statement, Possible Looping Error

    Please provide table def a nd sample data in a ready to use format together with your expected results (see the first link in my signature for an example).

    I'm sure...


    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]

    May 13, 2011 at 1:13 pm

    #1324537

  • RE: Cursor killing my server

    chandan_jha18 (5/13/2011)

    ...

    Thanks. I started with backup and restores and then moved on high end DBA tasks. Gradually i started to read and understand t-sql but not on a level...


    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]

    May 13, 2011 at 11:55 am

    #1324494

  • RE: Need Help on performance Improvement

    Without knowing what the functions used in the query actually look like it's close to impossible to help you any further...

    All I can say is: maybe the good old divide'n'conquer...


    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]

    May 12, 2011 at 2:58 pm

    #1323980

  • RE: Cursor killing my server

    Here are a few steps I would take to kill that *cough* c.u.r.s.o.r.:

    1) store the result of Declare OPIS_Cursor Cursor ... in a temp table since it'll be used 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]

    May 12, 2011 at 12:59 pm

    #1323922

Viewing 15 posts - 1,561 through 1,575 (of 5,502 total)