Forum Replies Created

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

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

    Sandra Skaar (1/15/2009)


    I talked with the SAN team some more today. There are no errors to correlate. The network backups run from 6PM to 4AM, which is when many of...

  • RE: Managing the Transaction Log size growth during an index rebuild

    Marker (1/15/2009)


    GilaMonster: it does not backup up the TRN log during the index rebuild.

    As in it runs for the duration of the index rebuild (and if that's the...

  • RE: tables data changes question

    Paresh Prajapati (1/15/2009)


    Create DDL trigger to change track and send mail notification.

    Um...

    DDL triggers fire when there's a change to the table structure, not the table's data (which is what foxjazz...

  • RE: Fully justified text

    george (1/15/2009)


    I've simply posted in the wrong forum.

    No prob.

    All of these forums here are dedicated to SQL server. We have no .net forums. I'd recommend you a good .net...

  • RE: Fully justified text

    george (1/15/2009)


    Would like to fully justify a section of text.

    At present I just have a simple text box like so . . .

    Forgive me for my confusion, but what does...

  • RE: Managing the Transaction Log size growth during an index rebuild

    Marker (1/15/2009)


    I noticed that the 15min TRN backup starts 15min before the index rebuild but does not backup the TRN log during the index rebuild.

    Doesn't back it...

  • RE: Are the posted questions getting worse?

    RBarryYoung (1/15/2009)


    You might have more luck looking for Kendo instructors. There's a whole Kendo Federation in SA, so I would think that there were a few instructors.

    There's a school...

  • RE: CROSS APPLY VERSUS INNER JOIN

    -- normal query

    select o.name, c.name

    FROM sys.objects o

    inner join sys.columns c on o.object_id = c.object_id

    -- noncorrelated subquery with inner join

    select o.name, c.name...

  • RE: CROSS APPLY VERSUS INNER JOIN

    leonp (1/15/2009)


    ok gila now that confuses me

    What confuses you? There's no other way to correlate a subquery in the from clause than to use one of the APPLY operators....

  • 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...

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