Forum Replies Created

Viewing 15 posts - 3,316 through 3,330 (of 5,502 total)

  • RE: Query Performance on huge view

    Günter,

    did you try using an EXISTS query to see if there are any data in your view?

    Something like

    IF EXISTS (select 1 from dbo.VWFaktSensitivitaetAggregation where DatumID=2010053100) ...

    Since all you want...


    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]

    June 15, 2010 at 12:17 pm

    #1180624

  • RE: Beginning Stored Procedure question

    The WITH statement is part of a CTE (common table expression).

    A cte (at least the type you're using) is nothing but a subquery, just easier to read (for some of...


    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]

    June 15, 2010 at 10:50 am

    #1180578

  • RE: Backfilling a table based on percentage obtained from query

    It's getting late over here in Europe...

    So, instead of a coded version here's a brief description of how I'd do it:

    Store the results of the query you just posted 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]

    June 14, 2010 at 5:25 pm

    #1180153

  • RE: Find and Replace xml node

    Ok, what you're basically trying to do is an UPSERT (Update or Insert) based on existence of a customer ID. Right?

    Why do you need to do it against XML files?...


    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]

    June 14, 2010 at 4:00 pm

    #1180138

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (6/14/2010)

    GilaMonster (6/14/2010)

    The Dixie Flatline (6/14/2010)

    I'm hearing vuvuzelas in my sleep.

    Me too.

    I haven't seen any matches yet, but tonight they're playing Italy vs. Paraguay.

    Vuvuzelas will get soon into my...


    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]

    June 14, 2010 at 2:47 pm

    #1180110

  • RE: Best storage strategy XML typed or varchar(max)

    Did you consider using SSAS? It might be helpful for the "blob" scenario while still allowing you to shred the data.

    The other issue I'd be worried about: when dealing 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]

    June 14, 2010 at 2:35 pm

    #1180105

  • RE: Backfilling a table based on percentage obtained from query

    What would be the sorting order to get the "top x" to apply the new events?

    What is the business rule in case of non-integer results? (e.g. 10% of 5 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]

    June 14, 2010 at 2:27 pm

    #1180101

  • RE: Find and Replace xml node

    Usually, it helps a lot if you'd post something like

    "here's what I have: ...

    here's my desired result:...

    those are the business rules to follow...

    and here's what I've tried so far:...

    "

    For more...


    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]

    June 14, 2010 at 2:03 pm

    #1180091

  • RE: Using OutPut Parameters in SP calls

    Based on BOL there is no restriction. So, in theory, it shouldn't matter.

    Did you try it using a simple sproc? Wouldn't such a test be easier than asking a theoretical...


    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]

    June 14, 2010 at 2:00 pm

    #1180086

  • RE: Backfilling a table based on percentage obtained from query

    How are you planning to deal with tie values?

    Eg. 20% = 1 and 20% =2?


    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]

    June 14, 2010 at 1:56 pm

    #1180084

  • RE: Running Multiple instance of the same stored procedure

    I'd also recommend you change the structure of your procedure names:

    it's considered as bad practice to start your stored procedures with sp_ since SQL server will try to find 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]

    June 14, 2010 at 1:43 pm

    #1180076

  • RE: Best storage strategy XML typed or varchar(max)

    Most common answer: "it depends" 😀

    The major question is: What are you going to do with the data (= Why do you have to store it in XML format)? Wouldn't...


    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]

    June 14, 2010 at 1:21 pm

    #1180066

  • RE: how to secure the database

    If you literally mean "nobody" than the only way I can think of is "DROP DATABASE".

    Other than that: AFAIK at least all persons with admin permission on that particular server...


    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]

    June 13, 2010 at 8:25 am

    #1179605

  • RE: Issue with Ordering of Location names in table

    Sanchit297 (6/13/2010)

    Thanks for the suggestion Lutz, but it is not possible for me to edit the EXE as numerous other reports are produced from the SQL Server 2000 box 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]

    June 13, 2010 at 7:23 am

    #1179601

  • RE: Issue with Ordering of Location names in table

    As Gail already pointed out: you need to add the ORDER BY to your select statement that is used to export the data.

    To use the related section of your original...


    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]

    June 13, 2010 at 5:53 am

    #1179594

Viewing 15 posts - 3,316 through 3,330 (of 5,502 total)