Forum Replies Created

Viewing 15 posts - 2,941 through 2,955 (of 5,685 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (6/21/2011)


    If you've never had to deal with connectors, sources, and destinations other that OLE DB, you may never actually use that task, actually. But I don't know many...

  • RE: Help Required Pleased: I don't even know how to pharase the question to search for an answer myself :-(...

    The code for this can get pretty complex, so if you can provide consumable sample data like you'll find in the first link of my signature, that'd help us present...

  • RE: Does anyone have a good reason to run xp_CmdShell?

    Jeff Moden (6/21/2011)


    The problem that I'm becoming more and more aware of is that people really don't know how to run procs that contain xp_CmdShell without giving the proverbial keys...

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (6/21/2011)


    So they haven't even memorized a list of SSIS interview questions and answers.

    Wait, maybe that's a good thing.:-D

    It might lighten up someone's day to share some of the...

  • RE: stored proc occasionally hangs?

    sqldba_icon (6/20/2011)


    Can someone please help in identifying as to where else should i look. This is so weird query is occasionally hung at a batch but runs perfectly normal through...

  • RE: How to optimize this query

    Going to need more information, such as the execution plans.

    Check out the second link down on the left in my signature, it'll walk you through what we'll need to effectively...

  • RE: Does anyone have a good reason to run xp_CmdShell?

    Jeff Moden (6/20/2011)


    That's one of the points I tried to make in my very first post on this thread.

    A recap for all from post #1: 😉

    As a precursor to the...

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/20/2011)


    Lynn Pettis (6/20/2011)


    Craig Farrell (6/20/2011)


    Lynn Pettis (6/20/2011)


    Craig,

    Is this a mandatory butts-in-chair position or is it something that could actually be done remotely (even during evening and weekend hours)? ...

  • RE: Query Help

    jared-709193 (6/20/2011)


    I'm sorry, maybe I was not clear... The default collation for SQL Server is not case-sensitive. I believe we are saying the same thing 🙂

    Thanks,

    Jared

    Nope, definately not clear....

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/20/2011)


    Craig,

    Is this a mandatory butts-in-chair position or is it something that could actually be done remotely (even during evening and weekend hours)? There may be qualified applicants...

  • RE: Query Help

    jared-709193 (6/20/2011)


    I want to make note here that collation may not the issue. Collation allows you to filter on case, not insert and return it.

    Incorrect, please test the following...

  • RE: Are the posted questions getting worse?

    Tom.Thomson (6/20/2011)


    But Craig, don't you realise that it is normal for all advertised jobs in computing that the majority of applicants come nowhere near the advertised requirement? It's...

  • RE: Need help using Tally Table for updates

    jarid.lawson (6/20/2011)


    The question I'm trying to understand is how to use tally table logic. Not specifically to solve this problem, but if this problem could be solved with it, then...

  • RE: Query Help

    C a z (6/20/2011)


    With only that information you have given me I am gonna put money on the select DISTINCT is the issue - SQL normally works top to bottom...

  • RE: Agile and Database design

    Hm, guess I should just run down these questions.

    Jayanth_Kurup (6/20/2011)


    How do you find designing databases without complete specs ?

    No different, really, then designing WITH specs, except that I can point...

Viewing 15 posts - 2,941 through 2,955 (of 5,685 total)