Forum Replies Created

Viewing 15 posts - 16,591 through 16,605 (of 49,552 total)

  • RE: DBCC CHECKDB with Data_Purity consistency errors

    Take a look at this article. http://www.sqlservercentral.com/articles/65804/

    There's a section in there on data purity errors.

    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 17, 2012 at 9:56 am

    #1538691

  • RE: How do I fix Damaged allocation pages

    First idea, that's not a way to fix corruption...

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Full output.

    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 17, 2012 at 9:22 am

    #1538669

  • RE: IN Vs INNER JOIN

    Grant Fritchey (9/17/2012)

    yuvipoy (9/17/2012)

    An inner join between two tables does a complete join, it checks for matches and returns rows. This means, if there are multiple matching rows 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

    September 17, 2012 at 6:13 am

    #1538546

  • RE: unrestored log?

    The unrestored log is the portion of the log at the mirror server that has not yet been replayed against the mirror database. Everything's been send across (it is synchronised...

    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 17, 2012 at 5:20 am

    #1538524

  • RE: 2012 SSMS differential restore or log restore gui bug?

    dt2 (9/17/2012)

    but what am i supposed to do now?

    You can start by adjusting your attitude. We're volunteers, we post in our spare time and insulting someone who's trying to help...

    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 17, 2012 at 5:15 am

    #1538521

  • RE: Database going into suspected mode !!! Urgent

    Open up the SQL error log and post all errors that you see relating to the suspect database.

    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 17, 2012 at 5:09 am

    #1538520

  • RE: Adjust how Data is Returned in Table

    Read up on the PIVOT keyword.

    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 16, 2012 at 2:06 pm

    #1538352

  • RE: out of memory

    As I said when you first posted...

    GilaMonster (8/1/2012)

    The workaround is to use the -g flag to increase the mem_to_leave that's reserved and restart SQL when the symptoms start (I've seen...

    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 16, 2012 at 4:22 am

    #1538325

  • RE: NOLOCK/Isoloatin Level for READONLY database

    If you are not doing any data modifications, then you will not be experiencing blocking and therefore there's little point in changing or fiddling with the isolation level.

    Identify the badly...

    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 15, 2012 at 6:58 pm

    #1538311

  • RE: NOLOCK/Isoloatin Level for READONLY database

    If the database is read only, you won't be seeing any blocking (because nothing can ever write to the tables), so there will be no gain from read uncommitted 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

    September 15, 2012 at 5:25 pm

    #1538309

  • RE: Exam 70-463

    Err, Books Online as in the SQL manual...

    It definitely does have sections that cover the exam requirements, it's what I used to study for the beta.

    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 15, 2012 at 11:58 am

    #1538293

  • RE: how to explore/ retrieve SQL Server Transaction Log information

    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/Topic1359769-146-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

    September 15, 2012 at 10:31 am

    #1538287

  • RE: Can we Prioritize which index to be used first in a Select query ?

    The optimiser chooses the best index for a query based on its knowledge of the data distribution, rows involved and a few other factors.

    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 15, 2012 at 10:30 am

    #1538286

  • RE: Exam 70-463

    Books Online?

    It's what I had to use. (wrote the exam when it was in beta)

    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 15, 2012 at 6:55 am

    #1538270

  • RE: how to explore/ retrieve SQL Server Transaction Log information

    The undocumented function to read the log is fn_dblog. It's a table-valued function (hence used in a select statement), takes two parameters, start LSN and end LSN, both can 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

    September 15, 2012 at 3:02 am

    #1538263

Viewing 15 posts - 16,591 through 16,605 (of 49,552 total)