Forum Replies Created

Viewing 15 posts - 28,216 through 28,230 (of 49,552 total)

  • RE: Check Catalog Msg 3854...

    Derrick Smith (1/24/2011)

    Script out the table in SSMS and recreate it with a new name, migrate data, delete old table, rename new table to old name.

    It's a system table. (or...

    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 24, 2011 at 4:01 pm

    #1277510

  • RE: Check Catalog Msg 3854...

    Odd...

    I seem to recall a thread on exactly this error a while back. Maybe search sround, see if you can find it. I can't remember what the final recommendation was...

    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 24, 2011 at 1:32 pm

    #1277450

  • RE: Is this a Proper Backup?

    fnostro (1/24/2011)

    I make no claim to be a DBA in any way, so it very possible i'm missing a LOT. Be that as is may, the transaction do grow,...

    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 24, 2011 at 1:22 pm

    #1277444

  • RE: Database relocation

    To recreate the database on SQL 2005 you'll have to remove/change any SQL 2008-specific features (spatial, date, time, etc) otherwise the creation scripts won't run on 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

    January 24, 2011 at 11:41 am

    #1277398

  • RE: Lookups on Clustered Indexes

    Grizzly Bear (1/24/2011)

    Then this begs the next question -- how do I know which NON_CLUSTERED index used this CLUSTERED index for "lookups" and how many times each did ?

    You don't....

    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 24, 2011 at 11:20 am

    #1277385

  • RE: Lookups on Clustered Indexes

    It's not a lookup from that index. It's a lookup to that index. Typically it will be 0 for nonclustered indexes (because key lookups aren't done to nonclustered indexes) and...

    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 24, 2011 at 11:03 am

    #1277370

  • RE: Check Catalog Msg 3854...

    Attach it to a SQL 2000 instance (NB SQL 2000!) and run DBCC CheckCatalog

    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 24, 2011 at 11:01 am

    #1277368

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/24/2011)

    Threadizens not on Twitter might not have heard the word. I just took a job with Red Gate. It's up on the blog.

    Congrats (again). Glad it all came...

    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 24, 2011 at 10:40 am

    #1277352

  • RE: Need to track the Database changes

    Elliott Whitlow (1/24/2011)

    Give a tool and a fair amount of time and ALL the transaction log dumps, he MIGHT be able to, but out of the box he's already done.

    Except...

    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 24, 2011 at 10:35 am

    #1277346

  • RE: Corruption Detection

    Steve Jones - SSC Editor (1/24/2011)

    You calculate a checksum across the page. When you read the page, you recalculate the checksum. If it doesn't match the value stored in 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 24, 2011 at 10:28 am

    #1277336

  • RE: Corruption Detection

    SanDroid (1/24/2011)

    What caused this to happen? How did you discover and recover from it?

    Errr...??? I'm saying how it behaves, not describing a situation I encountered. I can manufacture an 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

    January 24, 2011 at 7:05 am

    #1277178

  • RE: password for sa login got lost

    Could you please post the new question in a new thread? Thanks

    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 24, 2011 at 6:54 am

    #1277171

  • RE: How to identify the problem with the transaction log

    Please read through this: http://www.sqlservercentral.com/articles/64582/

    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 24, 2011 at 6:19 am

    #1277161

  • RE: Number of TempDbs for certain types of processors.

    Duran (1/24/2011)

    I understand that it is good practice to create the same number of Tempdb's as you have processors

    Not necessarily.

    http://sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281230%29-tempdb-should-always-have-one-data-file-per-processor-core.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

    January 24, 2011 at 5:59 am

    #1277154

  • RE: Returning Login for SessionID

    If you're seeing the ASP login, it means that the actual user never logged into SQL, just the ASP process. Hence SQL will have no knowledge of who originated 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 24, 2011 at 5:58 am

    #1277153

Viewing 15 posts - 28,216 through 28,230 (of 49,552 total)