Forum Replies Created

Viewing 15 posts - 16,681 through 16,695 (of 39,970 total)

  • RE: How to tune my update from query.

    We do not have that. We have talked about it, but it's a double edged sword. what you get to work, and think is a good answer may not be...

  • RE: null vs IS NOT NULL

    Does this return something?

    select open

    from view_rpt

    where open = 'null'

    I suspect that application might be storing 'NULL' and not NULL.

  • RE: Create stored procedure

    Scott Arendt (3/16/2011)


    ronmoses (3/16/2011)


    paul s-306273 (3/16/2011)


    I don't really see the value of this question...

    The nearly 40% of respondents who got it wrong learned something today. That alone seems valuable...

  • RE: Why does this query only run in master?

    The select works for me, inside and outside of master.

    Not sure what's wrong for you.

  • RE: Are the posted questions getting worse?

    Nice job, Gail, and I didn't think you insulted Robert. I think sometimes they are asking to learn something (they don't know everything) and sometimes just giving you a hard...

  • RE: March Madness 2011

    I'll run the draft tomorrow, sending emails to everyone and asking for picks. You'll have to trust me to draw the numbers here for ordering.

    If we don't get more, we'll...

  • RE: null vs IS NOT NULL

    Please show the query, table DDL and sample data

  • RE: Are the posted questions getting worse?

    I also don't see the point in not offering downloads. Not like it couldn't require a login or a page view to get them.

    The Windows Media streaming sucks. Never seems...

  • RE: Job appears to run successfully, but doesn't.

    That's a stored procedure. The logic could be flawed.

  • RE: clustered index

    No, the conclusion is that a narrow clustered index is good, and that other non-clustered indexes, even on the same column, might help. However you have to look at the...

  • RE: Splitting of data files

    First, just to be clear, the clustered index isn't on the filegroup. You create a clustered index on a table, and place that in a filegroup to move the table...

  • RE: clustered index

    Doh!, yes, edited to to say what I meant.

    Narrow clustered key, not necessarily narrow non-clustered key.

  • RE: clustered index

    First, don't confuse clustered index with primary key. Not related in any way. By default the PK is clustered, but that's a setting. They have nothing to do with one...

  • RE: Why is my transaction log full?

    As long as you are sure you don't need point in time recovery, you did the right thing.

    I would argue that most people don't think they need point in time...

  • RE: Single Procedure To Update One Column in Any Table

    Here's what I'd do, especially as you might need this later.

    Get a sproc for every table that updates a field based on the PK.

    That's a lot of writing, but you...

Viewing 15 posts - 16,681 through 16,695 (of 39,970 total)