Forum Replies Created

Viewing 15 posts - 23,146 through 23,160 (of 49,552 total)

  • RE: SQL Server Stack Dump

    MyDoggieJessie (9/30/2011)

    Do you know if there's a way to get around it? Without having to redo EVERYTHING?

    Without the checkDB output, no.

    You can drop a database involved in replication as...

    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 4:24 pm

    #1389051

  • RE: SQL Server Stack Dump

    If it is corrupt, it's an option.

    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 4:04 pm

    #1389044

  • RE: SQL Server Stack Dump

    In general, for any form of stack dump, call Microsoft Customer Support and open a case.

    This however looks like database corruption. Error 5242 is:

    An inconsistency was detected during an internal...

    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 3:51 pm

    #1389042

  • RE: Lock acquired/released infinite loop

    waxingsatirical (9/30/2011)

    I wasn't able to get an actual execution plan, as I could only get this behaviour when the statement is run as part of a stored procedure. I think...

    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 10:29 am

    #1388934

  • RE: Help with SQL query and Stored Procedure

    I wasn't talking about the stored procedure.

    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 9:56 am

    #1388922

  • RE: Help with SQL query and Stored Procedure

    While you're off on Google, may I suggest you read up on SQL Injection. Your code is vulnerable.

    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 9:45 am

    #1388918

  • RE: space used in transaction log during rebuild index

    At least the size of the index (in kB or MB), probably more because of the overhead of log header, log block header, 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 30, 2011 at 9:34 am

    #1388912

  • RE: MCITP without MCTS Certification

    CGSJohnson (9/30/2011)

    Hmmm...that's interesting, Gail. What would be the point of that scenario -- sitting the MCITP before the MCTS?

    I did it because I got beta invites 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

    September 30, 2011 at 9:01 am

    #1388888

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

    frfernan (9/30/2011)

    In this case I will order data by called number and calling date, and I will create an unique index using these two columns. I use this index 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

    September 30, 2011 at 8:33 am

    #1388880

  • RE: What to do about massive log file

    Pretty much the same as switching to simple recovery. Discards all log records that are no longer needed, breaks the log chain. Lets you shrink the log back to 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

    September 30, 2011 at 8:00 am

    #1388866

  • RE: Select more records and indexes

    For basic indexing, have a look at this series (3 parts): 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

    September 30, 2011 at 7:41 am

    #1388853

  • RE: Statistics debate

    GSquared (9/30/2011)

    Yeah. Soon as I asked the question, I went and researched it. Short schema lock at the end of the process for Online if I read it...

    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:37 am

    #1388848

  • RE: space used in transaction log during rebuild index

    At least the total size of all the indexes rebuilt between two log backups. Probably more.

    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:31 am

    #1388847

  • RE: What to do about massive log file

    Or switch the database to simple recovery

    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:30 am

    #1388846

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

    frfernan (9/30/2011)

    So my conclusion is that this index contains the primary key, even when it's not explicitly defined.

    Not the primary key. Nothing to do with the primary key. The clustered...

    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:27 am

    #1388843

Viewing 15 posts - 23,146 through 23,160 (of 49,552 total)