Forum Replies Created

Viewing 15 posts - 796 through 810 (of 5,502 total)

  • RE: Moving to a SAN, but the sizing concept doesn't sound right....

    ALZDBA (12/8/2011)

    Here's another great resource by Brent Ozar that may get you on track tackling potential problems with san configurations for sqlserver

    http://www.brentozar.com/sql/sql-server-san-best-practices/

    Yup, that's my first source. Now that Gail pointed...


    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]

    December 8, 2011 at 1:42 pm

    #1418955

  • RE: Moving to a SAN, but the sizing concept doesn't sound right....

    GilaMonster (12/8/2011)

    Whoever designed that is making the standard mistake of specing for space, not performance. Grab a copy of 'Troubleshooting SQL Server' by Jonathan Kehayias and check out chapter 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]

    December 8, 2011 at 1:06 pm

    #1418935

  • RE: Very Odd Query to Select Data

    Hi Andrew,

    I'm not sure if this would help you to get started:

    Instead of trying to select one at a time, you could use Row_Number() to place the rquired rows 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]

    December 7, 2011 at 5:16 pm

    #1418433

  • RE: 1:M - how to flatten into a single-view

    gerardquinn43 (12/7/2011)

    first class, thanks, really good stuff. Can't believe you gave me a few alternatives with precision coding also. Fantastic!!!

    Cheers,

    Gerry.

    Like I said before: if there are some ready...


    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]

    December 7, 2011 at 4:56 pm

    #1418430

  • RE: Moving to a SAN, but the sizing concept doesn't sound right....

    SQLRNNR (12/7/2011)

    Yes on the 64K, get them to format as 64K clusters. If filestreaming with larger files, you may want larger cluster sizes.

    The spindles seems off.

    The local drive 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]

    December 7, 2011 at 4:51 pm

    #1418429

  • RE: 1:M - how to flatten into a single-view

    Here are some code snippets based on some read to use sample data (do you recognize the data?)

    -- sample data in a ready to use format:

    DECLARE @tbl TABLE

    (

    fund_id INT,...


    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]

    December 7, 2011 at 4:36 pm

    #1418424

  • RE: 1:M - how to flatten into a single-view

    gerardquinn43 (12/7/2011)

    Thanks Lutz, reading your article now. very much appreciated.

    First time I used this site and very impressed.

    Cheers,

    Gerry.

    Glad I could help and welcome aboard!

    If you find the time, you...


    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]

    December 7, 2011 at 4:19 pm

    #1418418

  • RE: Moving to a SAN, but the sizing concept doesn't sound right....

    The SAN is provided by a 3rd party and a different group of our company is responsible for it.

    But I'll try to raise the 64k formatting you mentioned. Let's see...


    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]

    December 7, 2011 at 4:11 pm

    #1418416

  • RE: 1:M - build flat view with new 2008 features

    duplicate post. no replies please.

    Discussion already started 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]

    December 7, 2011 at 3:58 pm

    #1418412

  • RE: 1:M - how to flatten into a single-view

    Depending on the classification values being static or not, it's either a CrossTab or a DynamicCrossTab scenario. Both concepts are described in the related links in my signature.

    As a side...


    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]

    December 7, 2011 at 3:57 pm

    #1418410

  • RE: Moving to a SAN, but the sizing concept doesn't sound right....

    Thank you for the prompt response, Elliot. Much appreciated.

    I'm concerned, too. Especially, since all of our DBs now would have to share the same physical drives for logs and tempdb....


    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]

    December 7, 2011 at 3:53 pm

    #1418407

  • RE: Are the posted questions getting worse?

    GilaMonster (12/6/2011)

    ...

    We're not singled out, we're just not included.

    The only valid countries are USA (except a few states), Canada (except Quebec), UK (except North Ireland) and Australia. (maybe one or...


    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]

    December 6, 2011 at 3:47 pm

    #1417716

  • RE: Virtualise SQL 2005

    I hope you're aware of the following limitation of using SQL Server in a virtualized environment:

    "Virtualization Snapshots for Hyper-V or for any virtualization vendor are not supported to use 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]

    December 6, 2011 at 11:07 am

    #1417573

  • RE: Are the posted questions getting worse?

    Grant Fritchey (12/6/2011)

    LutzM (12/6/2011)

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

    ...

    Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! 😉

    I guess I know...


    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]

    December 6, 2011 at 10:45 am

    #1417553

  • RE: Are the posted questions getting worse?

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

    ...

    Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! 😉

    I guess I know why neither Gail...


    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]

    December 6, 2011 at 10:29 am

    #1417534

Viewing 15 posts - 796 through 810 (of 5,502 total)