Forum Replies Created

Viewing 15 posts - 41,701 through 41,715 (of 49,562 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/15/2009)


    We don't train with a wakizashi at my dojo and I've never tried it.

    Neither do we. I have a couple books and I'm seeing if I can figure...

  • RE: CROSS APPLY VERSUS INNER JOIN

    Jack Corbett (1/15/2009)


    The APPLY operator is designed for use against table valued functions

    Or (I believe) correlated subqueries in the FROM clause

  • RE: Conistency Errors on SQL 7.0 DB

    Paul Randal (1/15/2009)


    I admittedly only looked through the thread quickly - was there anything else to look at?

    He wanted to know if there were any options other than repair with...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/15/2009)


    Steve Jones - Editor (1/15/2009)


    Got to play with sticks last night, Filipino style last night. Luckily didn't hit anyone's hands or get my own hit.

    I crack a knuckle...

  • RE: Partitions, SANS and Logical Drives Setup

    SQLH (1/15/2009)


    So if I used a SANS, I should only have one drive and stored all the data in that one drive with multiple filegroups? And I should also include...

  • RE: Non-Cluster Index Bad Performance

    You didn't mention that you're using SQL 2000. Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get...

  • RE: DBCC won't even run

    -- Cranfield (1/15/2009)


    SCSI bus fault occurred on Storage Box box 0, , Port 1 of

    Array Controller in slot 1.

    This may result in a "downshift" in transfer rate...

  • RE: I/O requests taking more than 15 seconds

    Sandra Skaar (1/15/2009)


    Avg. Disk sec/Write: Last(.001), Average(.252), Minimum (0.000), Maximum(2.500)

    Avg. Disk sec/Read: Last(.000), Average(.020), Minimum (0.534), Maximum(11.141)

    That is bad!

    The sec/read and sec/write should be below 10ms. You've got...

  • RE: Common Mistakes in T-SQL

    RBarryYoung (1/15/2009)


    Can you use those Plan Guide thingys? Or do you need something more stable for that?

    That's exactly what we're looking at.

  • RE: Partitions, SANS and Logical Drives Setup

    SQLH (1/15/2009)


    Would this setup gain performance from having does logical drive setup? Why or why not?

    No. It's still the same physical drive. It may even decrease performance by requiring the...

  • RE: DBCC CHECKDB doing nothing

    Is it blocked by another query? Is there a wait type, and if so, what is it? (check sysprocesses)

    Are there any entries in the error log? That sometimes happens when...

  • RE: Are the posted questions getting worse?

    Chris Morris (1/15/2009)


    They take a few moments to string, speshly in the dark, so if Mr Catburglar comes visiting then your best move would be to pin him to the...

  • RE: Index is not used (but it is, after editing something....)

    By rebuilding the index you have updated statistics and removed fragmentation. Both can make SQL pick an index it previously ignored. My bet's on the statistics.

  • RE: deciphering the erroelog code.

    There's nothing there that makes any sense and certainly nothing that points to a cause for a deadlock. I've never heard of a deadlock on a communication buffer before.

    Maybe give...

  • RE: Common Mistakes in T-SQL

    Kent Waldrop (1/15/2009)


    And veto power can stop many problems before they ever happen.

    I officially had veto rights at my last company. I say officially, because the CIO tended...

Viewing 15 posts - 41,701 through 41,715 (of 49,562 total)