Forum Replies Created

Viewing 15 posts - 41,686 through 41,700 (of 49,552 total)

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 12:32 pm

    #927623

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 12:25 pm

    #927621

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 12:22 pm

    #927619

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 11:57 am

    #927598

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 11:47 am

    #927593

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 11:41 am

    #927586

  • 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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 11:35 am

    #927580

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 11:27 am

    #927577

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 11:10 am

    #927561

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 10:40 am

    #927540

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 10:13 am

    #927512

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 8:42 am

    #927409

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 8:32 am

    #927388

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 8:29 am

    #927381

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2009 at 8:24 am

    #927375

Viewing 15 posts - 41,686 through 41,700 (of 49,552 total)