Forum Replies Created

Viewing 15 posts - 19,606 through 19,620 (of 49,552 total)

  • RE: Attempt to fetch logical page (1:229734) in database 24 failed. It belongs to allocation unit X not to Y.

    MyDoggieJessie (3/23/2012)

    Sweet. Bad index, I'll just drop and recreate it and hope for the best?

    No, index 1 is the clustered index, that's data damaged in the base table....

    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

    March 23, 2012 at 2:51 pm

    #1463817

  • RE: Attempt to fetch logical page (1:229734) in database 24 failed. It belongs to allocation unit X not to Y.

    MyDoggieJessie (3/23/2012)

    What I have difficult understanding is "how" this issue could have occurred when everyone's access to this DB is READ ONLY. How could the record no longer exist/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

    March 23, 2012 at 2:49 pm

    #1463812

  • RE: Are the posted questions getting worse?

    SQLRNNR (3/23/2012)

    GilaMonster (3/23/2012)

    Lynn Pettis (3/23/2012)

    Wants a primary key on fname and lname.

    You say that like it should be obvious it's a bad idea. I got so much flak from 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

    March 23, 2012 at 2:01 pm

    #1463775

  • RE: Clustered Index or Non Cluster Index?

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

    Also read through these:

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    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

    March 23, 2012 at 1:27 pm

    #1463749

  • RE: Primary key

    sandeep4testing (3/23/2012)

    FK- FName should be FK of Users.FName

    FK- LName should be FK of Users.LName

    Names as foreign keys? That's a weird design.

    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

    March 23, 2012 at 1:23 pm

    #1463745

  • RE: not getting rid of physical reads

    Unless the server has memory space > database size, there will always be physical reads. Physical read just means that the required page was not in the data cache.

    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

    March 23, 2012 at 1:10 pm

    #1463722

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/23/2012)

    GilaMonster (3/23/2012)

    Can I have some too?

    50 posts (or more) trying to explain index fragmentation. http://www.sqlservercentral.com/Forums/Topic1202104-1550-1.aspx Maybe I was assuming basic knowledge that doesn't exist...

    And if finally went...

    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

    March 23, 2012 at 1:06 pm

    #1463715

  • RE: Are the posted questions getting worse?

    Sean Lange (3/23/2012)

    GilaMonster (3/23/2012)

    Can I have some too?

    50 posts (or more) trying to explain index fragmentation. http://www.sqlservercentral.com/Forums/Topic1202104-1550-1.aspx Maybe I was assuming basic knowledge that doesn't exist...

    And if finally went...

    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

    March 23, 2012 at 1:06 pm

    #1463713

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/23/2012)

    Wants a primary key on fname and lname.

    You say that like it should be obvious it's a bad idea. I got so much flak from a client who...

    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

    March 23, 2012 at 1:02 pm

    #1463710

  • RE: Primary key

    ALTER TABLE usern ADD CONSTRAINT <constraint name> PRIMARY KEY (lname, fname)

    Problem is, names are not unique. Unless this is for a small group of people that you know have no...

    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

    March 23, 2012 at 12:58 pm

    #1463706

  • RE: Are the posted questions getting worse?

    Can I have some too?

    50 posts (or more) trying to explain index fragmentation. http://www.sqlservercentral.com/Forums/Topic1202104-1550-1.aspx Maybe I was assuming basic knowledge that doesn't exist...

    And if finally went full circle with...

    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

    March 23, 2012 at 12:52 pm

    #1463700

  • RE: How much memory should be allocated to SQL Server 2008 R2 64 Bit Enterprise

    It is strongly recommended to always set max server memory, especially when the server is not dedicated to SQL Server. 2.5 GB free is a little large, the usual recommendation...

    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

    March 23, 2012 at 10:19 am

    #1463555

  • RE: SQL 2012 AlwaysOn & Readable Copies

    They should simply use the primary because there is no read-only secondary available.

    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

    March 23, 2012 at 8:35 am

    #1463433

  • RE: Sequece to know which syntax execute first

    Google - logical query execution.

    Or get a copy of Inside SQL Server 2005: T-SQL Querying.

    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

    March 23, 2012 at 8:02 am

    #1463410

  • RE: How much memory should be allocated to SQL Server 2008 R2 64 Bit Enterprise

    If there is other stuff running on the server, then you need to account for that before setting SQL's memory. So if the app is using 1.5 GB memory (round...

    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

    March 23, 2012 at 7:57 am

    #1463407

Viewing 15 posts - 19,606 through 19,620 (of 49,552 total)