Forum Replies Created

Viewing 15 posts - 1,141 through 1,155 (of 5,502 total)

  • RE: SQL multiple key index query : How to find where a combined index contains a unique column on all tables in db

    kramaswamy (8/3/2011)

    Well, as sorta a general rule-of-thumb to apply to most of your tables, I'd say you could start by dropping any index on the RID column, and replacing 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]

    August 4, 2011 at 12:46 am

    #1363463

  • RE: Tuning a view to avoid pageIO_Latch_SH locks

    Another question would be: why are there only left outer joins?

    There's not a single inner join (as far as I see).

    I'm with Jeff here: it seems like this is...


    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 4, 2011 at 12:33 am

    #1363460

  • RE: SQL Server 2008 Convert Rows into INSERT statement

    please provide some sample data including the expected result.

    Will those columns be static or is a dynamic solution required? If so, please describe the dynamic scenario.


    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 3, 2011 at 4:03 pm

    #1363382

  • RE: SQL Server 2008 Convert Rows into INSERT statement

    duplicazr post. no replies please.

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


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

    #1363379

  • RE: Do DBA admins rather restore whole databases then restoring individual tables?

    Have a look at redgate's "SQL Virtual Restore". Seems to be exactly what you're looking 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]

    August 3, 2011 at 11:35 am

    #1363247

  • RE: Are the posted questions getting worse?

    Tom.Thomson (8/3/2011)

    ...

    Actually, if there were a world competition for the worst beers, no European country would come top - the worst European beers are comfortably outclassed for awfulness by many...


    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 3, 2011 at 8:57 am

    #1363129

  • RE: Are the posted questions getting worse?

    Kiara (8/3/2011)

    ...

    Now, thanks to The Thread, I have beer on the brain too...

    Applied from the outside or the inside?

    Imaginary type or the liquid form?


    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 3, 2011 at 8:49 am

    #1363118

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (8/3/2011)

    ...

    Not only excellent chocolate, also excellent beers 😉

    And I do need the diapers, just not for myself 🙂

    (I just found out I can order diapers from the German...


    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 3, 2011 at 1:56 am

    #1362852

  • RE: FULL OUTER JOIN or Stored Procedure to get desired result?

    The table holding the column CustomText01 needs to be on the left side of a LEFT OUTER JOIN and the join predicates might need to include an OR IS NULL...


    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 2, 2011 at 4:17 pm

    #1362749

  • RE: Are the posted questions getting worse?

    Changing subject:

    @Wayne:

    Did you notice you have a sibling? (at least in terms of your avatar...) 😀

    For a moment I was confused (more than usual)


    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 2, 2011 at 4:04 pm

    #1362740

  • RE: Problem Query

    jez.lisle (8/2/2011)

    All, Thanks for the help and advice... erm where to start with the replies 🙂

    ...

    LutzM - How can I tell if there are missing Indexes?

    ...

    Jez

    Here are some alternatives:

    If it's...


    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 2, 2011 at 3:58 pm

    #1362733

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (8/2/2011)

    ...

    I do! But not for myself. Yet. :w00t:

    My baby girl is on potty training. She pees everywhere but in the potty. She seems to like carpets best.

    Why don'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]

    August 2, 2011 at 3:28 pm

    #1362697

  • RE: Replication with MS Access 2007 and Sql Server

    E McNeill (8/2/2011)

    I have a client who currently uses MS Access 2007. His employees us a MS Access application on PDA’s to collect data and then once...


    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 2, 2011 at 3:24 pm

    #1362690

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (8/2/2011)

    ...

    16MB/s down and unlimited? For less than 60 euros?

    I wish I could speak German so I could live over there 😀

    (there are so many things cheaper in Germany...


    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 2, 2011 at 2:40 pm

    #1362645

  • RE: Are the posted questions getting worse?

    I'm not sure if I even should post the rates available over here....

    Oh, well ...

    45EUR wired flat (phone flat wired to wired and wired to mobile, unlimited internet flat 16MB/s...


    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 2, 2011 at 2:09 pm

    #1362608

Viewing 15 posts - 1,141 through 1,155 (of 5,502 total)