Forum Replies Created

Viewing 15 posts - 19,291 through 19,305 (of 49,552 total)

  • RE: RESTORE detected an error on page (0:0)

    I can pretty much tell you that it is not a corrupt page in the source DB. There is no page 0:0 in a database, and if page 1:0 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

    April 6, 2012 at 2:33 pm

    #1470288

  • RE: Table Partition

    Sourav-657741 (4/6/2012)

    If I am wrong I believe partitioning the table helps in improving the performance because we are placing the ranges of the data in individual File groups....so instead of...

    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

    April 6, 2012 at 1:38 pm

    #1470262

  • RE: Table Partition

    Sure you can. It quite likely won't do a thing for performance, but you can partition it if you really want to.

    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

    April 6, 2012 at 12:21 pm

    #1470223

  • RE: Table Partition

    First question: Why is the table to be partitioned? What's the goal here?

    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

    April 6, 2012 at 11:23 am

    #1470202

  • RE: Doubt on Index

    The index key is LastName and FirstName columns. Nothing more complex than that. The 'bookmark' will be the clustered index key (if there's a clustered index) or the RID (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

    April 6, 2012 at 6:55 am

    #1470075

  • RE: Doubt on Index

    Why do you want to see it, and what do you want to see?

    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

    April 6, 2012 at 6:37 am

    #1470065

  • RE: Doubt on Index

    You can't directly see the index, but then there's no reason to need to most of the time.

    If you create an index on LastName,FirstName, then the index rows will have...

    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

    April 6, 2012 at 5:56 am

    #1470044

  • RE: License vs physical cores

    LutzM (4/6/2012)

    GilaMonster (4/6/2012)

    LutzM (4/6/2012)

    Another option would be to buy SQL2008R2. The license terms were much more customer friendly (you'd need two processor licenses for the two sockets when using 2008...

    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

    April 6, 2012 at 5:51 am

    #1470041

  • RE: Object Id in inputbuf element of <blocked-process-report>

    Then the object has been dropped since that blocking report was created.

    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

    April 6, 2012 at 5:33 am

    #1470037

  • RE: License vs physical cores

    LutzM (4/6/2012)

    Another option would be to buy SQL2008R2. The license terms were much more customer friendly (you'd need two processor licenses for the two sockets when using 2008 or 2008R2).

    Two...

    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

    April 6, 2012 at 5:33 am

    #1470036

  • RE: drop index took 3 hours!maybe disk's files fragmentation?

    ALL nonclustered indexes have the clustered index key in them. All of them, whether you put it in the index key or include or not. All nonclustered indexes on 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

    April 6, 2012 at 5:32 am

    #1470034

  • RE: drop index took 3 hours!maybe disk's files fragmentation?

    Yes.

    And all nonclustered indexes contain the clustered index key.

    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

    April 6, 2012 at 3:38 am

    #1470002

  • RE: What is the difference between SubQuery and Joins in terms of Performance

    That 'best practice' is nothing of the sort. Subqueries are very useful and usually very well performing.

    The type that you should avoid is the type that have (SELECT TOP (1)...

    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

    April 6, 2012 at 3:35 am

    #1470001

  • RE: drop index took 3 hours!maybe disk's files fragmentation?

    den_sidr (4/6/2012)

    hi Lynn,

    are you sure that any nonclusted indexes are engaged in this process consequently?any links/docs?

    Yes, absolutely sure.

    All nonclustered indexes contain the clustered index key as a row locator. When...

    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

    April 6, 2012 at 3:12 am

    #1469990

  • RE: Object Id in inputbuf element of <blocked-process-report>

    No way to tell from the object ID what object it is. Query sys.objects in the database that has an ID of 151.

    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

    April 6, 2012 at 3:10 am

    #1469989

Viewing 15 posts - 19,291 through 19,305 (of 49,552 total)