Forum Replies Created

Viewing 15 posts - 35,041 through 35,055 (of 49,552 total)

  • RE: Can't Truncate Log Because of DB Error?

    I so wish I knew why this happened....

    Solution's simple, though far from obvious.

    Run DBCC OpenTran. There'll likely be a reference to replicated and unreplicated LSNs. The replicated will probably be...

    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 31, 2009 at 7:55 am

    #1097872

  • RE: A New Beginning

    I wrote up my goals and intentions on my blog. Post scheduled for midnight (my time). What I'm focusing on next year is not SQL Server though.

    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 31, 2009 at 3:21 am

    #1097805

  • RE: WHERE filter is killing my query against a SQL Server 2005 database

    This is insane. There's a nested loop join between thousands of rows. I cannot see why that loop join is there, it's the worst kind of join for those row...

    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 31, 2009 at 2:02 am

    #1097778

  • RE: update to [syscolumns].xtype

    You should not even be considering updating the system tables unless you are willing to deal with a corrupt and unusable database afterwards. Say you did update the xtype, now...

    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 31, 2009 at 12:57 am

    #1097768

  • RE: Why are user_lookups > 0 on Clustered Index?

    digitalox (12/30/2009)

    Seems to be it would be more useful if the user_lookup values were populated in each instance of the NC indexes instead so that you could identify the offending...

    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 31, 2009 at 12:47 am

    #1097765

  • RE: why does a db go into Recovery mode when restoring?

    Interesting. Same backup? Same time of day?

    Are you sure the state is 'recovering' not 'restoring'?

    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 31, 2009 at 12:46 am

    #1097764

  • RE: Can stats be auto-updated at less than 20%

    Lil SQL (12/30/2009)

    Gail - Part of the filter is absolutely looking at the two date columns to grab the latest records.

    Amazing insight! What does this mean to you?

    Not really...

    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 31, 2009 at 12:45 am

    #1097763

  • RE: Why are user_lookups > 0 on Clustered Index?

    digitalox (12/30/2009)

    snippet from script:

    CASE WHEN user_lookups > user_seeks AND type_desc IN ('CLUSTERED', 'HEAP', 'UNIQUE CLUSTERED') THEN 'REALIGN'

    I would really question the accuracy of that script. The only valid values for...

    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 30, 2009 at 2:09 pm

    #1097666

  • RE: Why are user_lookups > 0 on Clustered Index?

    digitalox (12/30/2009)

    This confused me because if the user_lookups represents the bookmarks by a NC without sufficient cover, then how can that column have any bearing on the effectiveness of 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 30, 2009 at 1:57 pm

    #1097663

  • RE: Disk expanded but does not show up correct in explorer

    SQL_Quest-825434 (12/30/2009)

    What does Mark as Active partition do ? (disk management -> point to the drive and rt click --> mark partition as active)

    Makes that the boot partition, ie 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 30, 2009 at 12:45 pm

    #1097634

  • RE: why does a db go into Recovery mode when restoring?

    Recovery (restart-recovery) goes through the logs, rolls back transactions that started but never committed and rolls forward transactions that did commit. The latter may not be so relevant for a...

    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 30, 2009 at 12:37 pm

    #1097628

  • RE: Can stats be auto-updated at less than 20%

    I'm going to guess...

    Ascending date column and the query's filtering for the latest records. Right?

    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 30, 2009 at 12:35 pm

    #1097624

  • RE: WHERE filter is killing my query against a SQL Server 2005 database

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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 30, 2009 at 12:32 pm

    #1097621

  • RE: Row modification error!

    Rather than using the table viewer (which can be a little glitchy), use the T-SQL commands.

    UPDATE <TableName>

    SET <Column name> = 'facebook'

    WHERE <Column Name> = 'acebook'

    This will update all...

    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 30, 2009 at 2:10 am

    #1097355

  • RE: Why are user_lookups > 0 on Clustered Index?

    That shows the lookup done to the clustered index. So whenever a NC index is not covering and there's a key lookup, that's a lookup to the clustered index.

    As far...

    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 30, 2009 at 1:40 am

    #1097352

Viewing 15 posts - 35,041 through 35,055 (of 49,552 total)