Forum Replies Created

Viewing 15 posts - 631 through 645 (of 5,502 total)

  • RE: PERFORMANCE Tuning

    You could try to run the two statements in reverse order.

    I'm confident "all of a sudden" the query running "fast" in the beginning will be the "slow" one.

    What is 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]

    February 9, 2012 at 3:06 pm

    #1445331

  • RE: Ideal C: for SQL Server

    Depending on the layout of your SAN it might be an option to move tempdb to a LUN based on more than one spindle dedicated to tempdb only. Or maybe...


    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]

    February 9, 2012 at 1:06 pm

    #1445256

  • RE: sql query execution time & rowcount, without results

    I'm not sure if I understand correctly what you're looking for.

    If it's just to avoid to display the data in SSMS, you could use the following approach:

    open a new query...


    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]

    February 9, 2012 at 12:28 pm

    #1445238

  • RE: Securing data from internal theft

    As per my knowledge there's no way to "ensure data are secure". You could allow dev to only access views instead of tables and use "TOP x" inthe view definition....


    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]

    February 8, 2012 at 1:07 pm

    #1444741

  • RE: update statements

    Something like this?

    Update mytable

    Set [A-Name]=CASE WHEN [A-ID] IS Null THEN null ELSE [A-Name] END,

    [B-Name]=CASE WHEN [B-ID] IS Null THEN null ELSE [B-Name] END

    ...

    As a side note: Ihope the column names...


    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]

    February 8, 2012 at 12:42 pm

    #1444729

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (2/7/2012)

    Evil Kraig F (2/7/2012)

    Koen Verbeeck (2/7/2012)

    Lynn Pettis (2/7/2012)

    Now that it is officially posted on facebook, I can start telling everyone.

    Kassondra gave birth to a healthy baby boy yesterday...


    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]

    February 7, 2012 at 3:03 pm

    #1444162

  • RE: Help with Grouped Datediff (I think??)

    First of all, I'm very sorry it took me so long to understand what you're looking for. :blush:

    I guess I got it now.

    the adjustment I made to my previous code...


    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]

    February 7, 2012 at 1:07 pm

    #1444082

  • RE: Help with Grouped Datediff (I think??)

    I'm still not sure how the expected results can be calculated (e.g. 07/01/2012 WC 1).

    So I post what I have so far:

    ;

    WITH cte_range AS

    (

    SELECT

    CAST (MIN(datewardchange_dte) AS date) min_datewardchange_dte,

    DATEDIFF(dd,MIN(datewardchange_dte),Max(datewardchange_dte))...


    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]

    February 6, 2012 at 3:00 pm

    #1443470

  • RE: Help with Grouped Datediff (I think??)

    Why does CCU has a count of 1 for Jan'08 but WC doesn't show 1 for Jan'06?


    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]

    February 6, 2012 at 2:24 pm

    #1443440

  • RE: Help with Grouped Datediff (I think??)

    Can you please verify that your expected results are based on the sample data?

    Example:

    I find only one row for ward='BB' that would match Jan'06. Why does your expected result needs...


    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]

    February 6, 2012 at 1:54 pm

    #1443425

  • RE: Extract field containing XML file and load results into a datatable

    Joe Contreras-290946 (2/4/2012)

    I figured it out. Using a type of Extract functionality to retrieve nodes

    Thanks,

    Would you mind sharing your solution so others may benefit?


    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]

    February 4, 2012 at 6:15 am

    #1442742

  • RE: Script to find parent procedure

    Duplicate post. No replies please.

    Original post: http://www.sqlservercentral.com/Forums/FindPost1245459.aspx

    @deepikamm: Is there any specific reason for starting a new thread with the very same question?


    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]

    February 4, 2012 at 4:42 am

    #1442738

  • RE: sql tricky query

    What would be your expected result based on the sample data?

    What do you want to achieve by "fetching" the ProdId?


    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]

    February 4, 2012 at 4:35 am

    #1442736

  • RE: Job duration

    Have a look at sp_help_jobactivity.


    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]

    February 4, 2012 at 4:33 am

    #1442735

  • RE: Are the posted questions getting worse?

    Revenant (2/3/2012)

    GilaMonster (2/3/2012)

    Summer, glorious summer (and lots of rain)

    Members in Central Europe will be green with envy -- Germany and the Czech Republic broke the low temperature records earlier today.

    Here...


    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]

    February 3, 2012 at 12:29 pm

    #1442598

Viewing 15 posts - 631 through 645 (of 5,502 total)