Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 5,685 total)

  • RE: Query Cost 27%

    Jeff Moden (5/15/2012)


    Gosh... if all that were true, it wouldn't be worth having things like calendar tables.

    Alright, I'll bite into that one... there's nothing in there I see as being...

  • RE: Where are the good Senior Level DBA's?

    C64DBA (5/15/2012)


    Not sure if I get your meaning Evil, if that is your real name :P. Why would you get someone in if their resume doesn't even contain recent experience...

  • RE: Where are the good Senior Level DBA's?

    C64DBA (5/15/2012)


    So instead of going for the tech questions, I just started relating stories of what I had experienced in the role over the previous 5 years. No holds barred,...

  • RE: Self Service SQL

    I have to lean towards Jeff's view on this one. For example, I've been teaching one of my business users basic querying fundamentals and how to effeciently get data...

  • RE: Trim String

    bpowers (5/15/2012)


    Worked perfect, just had to adjust the -4. Thanks Kraig!

    Can you explain to me how this is working? I assume the 3 is where it will start in...

  • RE: Trim String

    bpowers (5/15/2012)


    The problem I am trying to code out, is that the length of the string will grow over time. However, as it grows I want strip off the first...

  • RE: Trim String

    bpowers (5/15/2012)


    What would the syntax be for trimming a string on both ends? I want to remove the first two and last to characters in a string. Any ideas?

    Trimming a...

  • RE: Need help creating case statements from a query.

    andy 56206 (5/13/2012)


    Hi all -

    Let me try and be more specific in my question as well as formatting the code a little nicer.

    I am trying to automatically generate a case...

  • RE: Distributed Service Broker questions

    jagadish1978 (5/15/2012)


    Basically we are going to configure a load balancing configuration as mentioned your book.

    Who's book?

    All the data generated as a result of processing service broker applications are saved locally...

  • RE: Real world examples of staging data - your experiences please...

    MartyRocco (5/15/2012)


    The transactional system the data are coming from can't provide us an indicator of which data has been added, updated or deleted. I appreciate this is fairly common...

  • RE: Database Tuning Advisor not giving recommendations for large query

    Elizabeth.Block (5/15/2012)


    Thanks, that sounds possible. I have added some new indexes so maybe there's nothing to find. I just found it disconcerting to see a monster query that the DTA...

  • RE: Query Cost 27%

    Alone (5/15/2012)


    How to change non clustered index scan to non clustered index seek?The concerned tables already have non clustered index configured.

    Typically? You don't. A seek happens when...

  • RE: Are the posted questions getting worse?

    EU Data protection law is a bit fierce, but yeah, we're the opposite. I know a few smaller companies who have boxes upon boxes upon boxes of stuff stored...

  • RE: an integrated reporting/business solution within Word utilizing TAQL and other technologies

    polkadot (5/11/2012)


    I am going the SSRS route. If anyone still wants to pipe up about SSRS (specifically) I would appreciate. SSRS will take me a dedicated week to learn...

  • RE: Are the posted questions getting worse?

    GilaMonster (5/11/2012)


    WayneS (5/11/2012)


    GilaMonster (5/11/2012)


    Aaah, nerves. The wait is killing me...

    Must be... London?

    No.

    First Date then! Good luck!

Viewing 15 posts - 1,546 through 1,560 (of 5,685 total)