Forum Replies Created

Viewing 15 posts - 23,161 through 23,175 (of 49,552 total)

  • RE: How to avoid sort warnings?

    Hands off unless you are 120% certain that you know better than the optimiser for all possible parameter values and all possible data changes and you know exactly what 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

    September 30, 2011 at 7:26 am

    #1388841

  • RE: If table is Clustered on RID, will index1 = [col2,col3] work the same as index2 = [col2,col3,RID]

    frfernan (9/30/2011)

    in an OLTP system, when you create an index to show data on the screen in an ordered fashion, you will need an unique index to properly scroll up...

    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

    September 30, 2011 at 7:24 am

    #1388838

  • RE: Closing Out Replies

    Matthew Joughin (9/29/2011)

    They have a api called StackExchange which allows anyone to set up the same type of site, perhaps that should be looked into...

    You mean like this: http://ask.sqlservercentral.com/

    The problem...

    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

    September 30, 2011 at 12:17 am

    #1388689

  • RE: Are the posted questions getting worse?

    WayneS (9/29/2011)

    Gail / Grant - are the sessions that you'll are doing during the 3-day portion of the summit going to be covered during your precon?

    No, different material, different topic....

    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

    September 29, 2011 at 11:39 pm

    #1388684

  • RE: option of pinning the tables in memory

    CarpenterBob (9/29/2011)

    http://msdn.microsoft.com/en-us/library/ms143729.aspx

    The list of deprecated engine features?

    If you were referring to DBCC PinTable, then...

    DBCC PINTABLE Has no effect.

    It was removed because misused it could cause poor...

    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

    September 29, 2011 at 2:47 pm

    #1388635

  • RE: DTCXact - Log File growing.

    Have you investigated who, what, when and how of SPID 73?

    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

    September 29, 2011 at 1:38 pm

    #1388616

  • RE: SQL error while create very big table and inserting data into table

    GSquared (9/29/2011)

    SQL 2005 can allow data outside the 8k limit. Are you on SQL 2000? (Gail already asked, but I thought I'd clarify why.) It tends 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

    September 29, 2011 at 1:18 pm

    #1388611

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/29/2011)

    Grant Fritchey (9/29/2011)

    Evil Kraig F (9/29/2011)

    GilaMonster (9/29/2011)

    Wooooooooot!!!!!!!!!!!!!!!!!!

    2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did),...

    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

    September 29, 2011 at 1:13 pm

    #1388605

  • RE: Statistics debate

    GSquared (9/29/2011)

    Is online Index rebuilding Enterprise-only, and does rebuilding an index lock the table outside of that? I seem to remember it does, but I could easily be delusional...

    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

    September 29, 2011 at 1:11 pm

    #1388604

  • RE: Statistics debate

    timscronin (9/29/2011)

    I have a script that does rebuilds on only indexes that are needed, need one for stats that does the same

    I'd love one of those too....

    Problem with stats 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

    September 29, 2011 at 1:09 pm

    #1388602

  • RE: Database Size increasing

    @SQLFRNDZ (9/29/2011)

    take a log backup to make avilable log file for other queries that clears the log space in first then see any free space released then again shrink...

    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

    September 29, 2011 at 1:07 pm

    #1388600

  • RE: Statistics debate

    GSquared (9/29/2011)

    ... because of locking/blocking/deadlocking.

    Unlikely to cause any of those, as stats updates run in READ UNCOMMITTED, but can cause extra IO load, extra CPU, memory churn, etc.

    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

    September 29, 2011 at 12:32 pm

    #1388573

  • RE: Are the posted questions getting worse?

    Evil Kraig F (9/29/2011)

    GilaMonster (9/29/2011)

    Wooooooooot!!!!!!!!!!!!!!!!!!

    2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here

    http://www.sqlservercentral.com/articles/books/76296/

    Awesome Gail,...

    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

    September 29, 2011 at 12:22 pm

    #1388565

  • RE: Statistics debate

    No. 😀

    If you can afford the time, go ahead.

    It may not be enough. I've seen cases where specific stats have to be updated daily. I've heard of cases where...

    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

    September 29, 2011 at 12:20 pm

    #1388564

  • RE: SQL error while create very big table and inserting data into table

    You can have 1024 columns in a table, but the row size is 8060 bytes.

    p.s. SQL 2000 or SQL 2005?

    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

    September 29, 2011 at 11:53 am

    #1388553

Viewing 15 posts - 23,161 through 23,175 (of 49,552 total)