Forum Replies Created

Viewing 15 posts - 31,231 through 31,245 (of 49,552 total)

  • RE: stopping index generation

    teutales (8/16/2010)

    because of duration... I thought this is a big brake...

    It might, it might not. Test and see. If you're not updating a significant part of the table, the recreation...

    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

    August 16, 2010 at 5:35 am

    #1207278

  • RE: stopping index generation

    teutales (8/16/2010)

    I want to disable updating index for one batch, the index should be online for other batches.

    Can't be done. Either you disable the index, meaning you drop the index...

    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

    August 16, 2010 at 4:14 am

    #1207249

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/14/2010)

    I believe I'll submit the whole grass roots gambit next year... Triangular Joins, Tally Table, Cross Tabs, Quirky Update (and other ways to avoid cursors), and Into to...

    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

    August 16, 2010 at 2:18 am

    #1207200

  • RE: index_usage_stats dmv

    SQL Iron Chef (8/15/2010)

    The second made me wonder if an index scan is the same as a table scan because it's going through every rows in a table. How is...

    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

    August 15, 2010 at 11:32 pm

    #1207154

  • RE: Join questions

    PHXHoward (8/15/2010)

    This is how I have been writing my joins:

    select A.LastName, A.FirstName, B.JobTitle

    from people A

    inner join employees B

    on A.userID = B.userID

    An Oracle DBA told me that she does it like...

    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

    August 15, 2010 at 2:12 pm

    #1207101

  • RE: SQL LOGFILE- how much is committed and uncommitted?

    iqtedar (8/14/2010)

    thanks. Gail but the reason why we are shrinking the logfile is because sometimes the logfile is huge and takes lot of time to copy for logshipping.

    Shrinking 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

    August 15, 2010 at 2:24 am

    #1207080

  • RE: index fragmentation

    Join in the sys.indexes view. It joins on object_id and index_id and the index name is a column in there.

    p.s. His third query does just that.

    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

    August 15, 2010 at 2:22 am

    #1207079

  • RE: 'Operand type clash: uniqueidentifier is incompatible with int'

    Please post definitions of all affected tables. Is there a line number listed for that error?

    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

    August 14, 2010 at 4:35 pm

    #1207061

  • RE: System failed to flush data to the transaction log

    What's backupassist?

    That error indicates there was some problem writing to the tran log. Investigate the windows event log, any and all RAID/SAN logs and do a CheckDB on 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

    August 14, 2010 at 4:33 pm

    #1207060

  • RE: Table defintion SQL query

    EXEC sp_help 'Table 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

    August 14, 2010 at 9:44 am

    #1207039

  • RE: index fragmentation

    What's not clear?

    Ron (bitbucket) showed you how to check index fragmentation. His queries are correct and detailed.

    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

    August 14, 2010 at 9:43 am

    #1207038

  • RE: sysadmin

    Please post new questions in a new thread. Thank you.

    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

    August 14, 2010 at 7:03 am

    #1207035

  • RE: What kinds of queries may have a database-level lock?

    All queries take a shared database lock, to ensure that the DB doesn't disappear out from underneath them. Exclusive DB lock? That should be limited to db reconfigurations & setting...

    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

    August 14, 2010 at 3:40 am

    #1207022

  • RE: index fragmentation

    js_0505 (8/13/2010)

    Author: Michelle Ufford, http://sqlfool.com

    You know, it's polite to attribute ownership if you're posting other people's code....

    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

    August 14, 2010 at 3:40 am

    #1207021

  • RE: Can I use a saved execution plan?

    Twinsoft SME (8/13/2010)

    I wish I could go to some conferences...... !!!!!!!!!!!!

    Start saving up. I've been paying for myself the last 2 years.

    By speaking at the conference, the conference fee is...

    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

    August 14, 2010 at 3:27 am

    #1207020

Viewing 15 posts - 31,231 through 31,245 (of 49,552 total)