Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 5,502 total)

  • RE: Yeah! my first real corrupt DB

    Exactly the same results on my (test) instances (both on the same machine):

    Microsoft SQL Server 2005 - 9.00.4060.00 (Intel X86) Developer Edition, (Build 2600: Service Pack 3)

    Microsoft SQL...


    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]

    August 19, 2011 at 10:19 am

    #1370880

  • RE: Space used by a table

    sunny.tjk (8/17/2011)

    Is there a way to figure out the space used by a table in the last month?

    You'll need to be more precise what you're looking for.

    "Table space 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]

    August 17, 2011 at 11:40 am

    #1369765

  • RE: Turn integer into time of day

    @tim-2:

    Varchar without any length specification woud use a default of 30, which is oversize for the given task. Depending on the requirement how to display more than 24hrs (or 100hrs...


    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]

    August 16, 2011 at 4:28 pm

    #1369362

  • RE: Turn integer into time of day

    something like this?

    SELECT DATEADD(mi,yourColumn,'19000101')


    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]

    August 16, 2011 at 4:07 pm

    #1369355

  • RE: How To Implement DML Queue – A queue that stores DML Commands and executes them asynchronously

    I'm not sure if I'd go that route and update the original BankDepositNumber. I'd rather either add another column to the original table or even a separate table that 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]

    August 16, 2011 at 4:02 pm

    #1369352

  • RE: Display estimate execution plan: Missing index (Impact 91.xx)

    It seems like the index in stage is totally fragmented. This leads the query optimizer to the conclusion that the index (being good enough in test) is not good enough...


    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]

    August 16, 2011 at 3:21 pm

    #1369340

  • RE: stored procedure inserts into temp table 2 different select statements

    Based on your description, the code does exactly what you're looking for: "two distinct query's and i want to insert the results into one temp table".

    Separate INSERT statements will add...


    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]

    August 16, 2011 at 3:04 pm

    #1369332

  • RE: Problems to transcript a Oracle SQL Script

    Please don't hijack a thread.

    The issue you describe is not even related to the subject discussed in the original thread.

    Ask your question using a new thread in the SSIS section....


    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]

    August 16, 2011 at 7:13 am

    #1369057

  • RE: Identificar de que objeto habla el waitresource

    Aiello DBA (8/16/2011)

    Completo articulo para entender el waitresource y poder identificar de que objeto se trata.

    http://aiellodba.blogspot.com/2011/08/entendiendo-el-waitresource.html

    Ich habe keine Ahnung, ob dieser Link einen Bezug zum Thema dieser Web-Seite hat. Auf...


    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]

    August 16, 2011 at 7:07 am

    #1369048

  • RE: Creating nested xml tree

    sauraviit-689328 (8/14/2011)

    IN my case i have to create this much xml data . My i am getting this error "XML operation resulted an XML data type exceeding 2GB in size....


    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]

    August 15, 2011 at 1:12 am

    #1368460

  • RE: Read XML file

    To expand on Flo's solution, performance is usually much better when using the CROSS APPLY approach if there's the need to return values from different node levels.

    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]

    August 14, 2011 at 2:44 am

    #1368360

  • RE: Granting rights

    Sachin Nandanwar (8/14/2011)

    ...

    Just because you define it as a "Best Practice" and it gives me an overhead in maintenance then surely I am better off in not using those...


    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]

    August 14, 2011 at 2:32 am

    #1368359

  • RE: stored proc calls another sp --Can both run parallelly ???

    kumar1 (8/12/2011)

    @ninja's_RGR'us: Thanks very much for this solution. I am working closer with this solution.

    @Kurt W. Zimmerman: You are obsoltely right.I have done similarly before but used waitfor delay option.

    Thank...


    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]

    August 12, 2011 at 3:34 pm

    #1368246

  • RE: stored proc calls another sp --Can both run parallelly ???

    Ninja's_RGR'us (8/12/2011)

    You use sp_startjob to start something async

    or SQL Service Broker as an alternative. Then you don't even have to wait until the job finished. It all depends on 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]

    August 12, 2011 at 1:41 pm

    #1368190

  • RE: Join in where statement of delete query

    The error message indicate the problem quite clear:

    Try DELETE CovElig.* FROM ...


    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]

    August 12, 2011 at 12:13 pm

    #1368143

Viewing 15 posts - 1,111 through 1,125 (of 5,502 total)