Forum Replies Created

Viewing 15 posts - 35,311 through 35,325 (of 49,552 total)

  • RE: link or website for Performance tuning and optimizing query

    Start with this two-part series. Finding the problem is more than half the battle.

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    I doubt there's a single, comprehensive site that covers everything. The links given earlier are good but...

    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

    December 14, 2009 at 9:22 am

    #1092040

  • RE: Table inaccessible during rebuild of index

    Try ALTER INDEX ... REORGANISE

    It does less that rebuild does, but it's an online operation.

    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

    December 14, 2009 at 9:15 am

    #1092031

  • RE: Dbcc Checkdb error

    Looks like the server went off the network or shut down. Check that the server's running, check that SQL's running and try running checkDB again. This is not a checkDB...

    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

    December 14, 2009 at 9:14 am

    #1092029

  • RE: Have to use force recompile to get the SP to use indexes

    Table definitions, index definitions and execution plans please.

    Does sound like parameter sniffing. There's a 3-part series on my blog (http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/) on parameter sniffing. It may be worth a read.

    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

    December 14, 2009 at 9:13 am

    #1092026

  • RE: Stored Procedure

    That's Oracle, not MS SQL Server. You're probably better off asking on an Oracle forum what it 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

    December 14, 2009 at 9:11 am

    #1092025

  • RE: Rebuilding indexes online isn't working?

    Do you have autoshrink on? Are you doing a manual database shrink after the index rebuild?

    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

    December 14, 2009 at 9:11 am

    #1092024

  • RE: Indexing nvarchar or varchar larger than 900 bytes

    This may be of use to you. http://www.sqlservercentral.com/articles/Indexing/68439/

    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

    December 14, 2009 at 1:05 am

    #1091782

  • RE: Creating a job using a package?

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic833628-148-1.aspx

    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

    December 14, 2009 at 1:02 am

    #1091781

  • RE: Which Exam to Take 2005 or 2008

    Which one are you working with? 2005 or 2008? I'd go for the one that you're activly working with, that you ave experience with.

    As for admin vs dev, well, which...

    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

    December 14, 2009 at 1:02 am

    #1091780

  • RE: Indexing nvarchar or varchar larger than 900 bytes

    ducon (12/13/2009)

    I'm in the process of indexing a few columns in a few tables, most of which are of type nvarchar(515). This means that the byte size if over 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

    December 13, 2009 at 3:48 pm

    #1091711

  • RE: Index

    Those are big enough that there should be a reduction in fragmentation after a rebuild. Small ones often don't show much if any change.

    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

    December 13, 2009 at 12:37 pm

    #1091695

  • RE: need article on clustering

    sanketahir1985 (12/13/2009)

    Each & everything about clustering if possible.

    Everything? There have been entire books written on clustering that still don't cover everything. I don't think that anyone's going to give 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

    December 13, 2009 at 8:22 am

    #1091665

  • RE: SQL Server 2005 MCITP Business Intelligence Cert.

    For all certification details, see the MS learning site - http://www.microsoft.com/learning/mcp/certifications.mspx

    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

    December 13, 2009 at 8:19 am

    #1091664

  • RE: Are the posted questions getting worse?

    Bru Medishetty (12/13/2009)

    Hey Gail, do you follow cricket too? I am a die hard fan of the Proteas.

    I don't really. Not much of a sports fan.

    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

    December 13, 2009 at 8:17 am

    #1091662

  • RE: Index

    How big are those indexes? How many pages?

    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

    December 13, 2009 at 6:35 am

    #1091636

Viewing 15 posts - 35,311 through 35,325 (of 49,552 total)