Forum Replies Created

Viewing 15 posts - 15,046 through 15,060 (of 49,552 total)

  • RE: how to find resource database location

    It's whereever the SQL Server binary files (exe and dlls) are.

    Why?

    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

    December 29, 2012 at 2:13 am

    #1572308

  • RE: Why Allow Heaps at All?

    You may be interested to know that SQL Azure (or whatever it's called this week), does not allow heaps.

    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

    December 29, 2012 at 2:11 am

    #1572307

  • RE: Why Allow Heaps at All?

    hakim.ali (12/28/2012)

    If it were an index, then why would the database scan every record in a heap when you were searching for something?

    SQL only scans if you haven't got...

    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

    December 28, 2012 at 12:48 pm

    #1572210

  • RE: Why Allow Heaps at All?

    patrickmcginnis59 (12/28/2012)

    GilaMonster (12/28/2012)

    patrickmcginnis59 (12/28/2012)

    I suspect theres a mechanism already in place to efficiently index a heap, ie., whatever passes for the row id.

    The RID is nothing more than an...

    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

    December 28, 2012 at 12:47 pm

    #1572209

  • RE: Why Allow Heaps at All?

    patrickmcginnis59 (12/28/2012)

    I suspect theres a mechanism already in place to efficiently index a heap, ie., whatever passes for the row id.

    The RID is nothing more than an 8-byte combination...

    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

    December 28, 2012 at 12:10 pm

    #1572191

  • RE: Performance of a Query : which one is giving good performace

    Test them and see?

    Alternately, maybe ask on an Oracle forum where you're more likely to get an answer.

    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

    December 28, 2012 at 3:50 am

    #1572065

  • RE: DBCC Commands

    sqlnaive (12/28/2012)

    Apart from that I've used DBCC SHOWCONTIG and DBCC INDEXDEFRAG as and when required.

    Both of those were deprecated 7 years ago, are included only for backward compatibility with SQL...

    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

    December 28, 2012 at 3:39 am

    #1572062

  • RE: how to use all the pages of extent for the same table

    Don't fuss with the way SQL stores data. It's not your decision, it's up to the database engine (its one of the requirements of a relational database system)

    With larger tables,...

    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

    December 28, 2012 at 2:20 am

    #1572048

  • RE: Stored Procedure looses execution plan.

    Bhuvnesh (12/28/2012)

    So here the chosen plan is the stored plan (stored at the time of previous runs) ?

    Huh? I already said that the optimiser will not return the previous cached...

    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

    December 28, 2012 at 2:17 am

    #1572047

  • RE: i want to add column in exiting view

    Error's pretty clear. When using a union, intersect or except all the queries must have the same number of columns

    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

    December 27, 2012 at 11:06 am

    #1571946

  • RE: Can a Table Really Have a Clustered Index?

    hakim.ali (12/27/2012)

    Just so I understand this right: are you saying that if you took a heap and added a clustered index to it with a fill factor of 5%, 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

    December 27, 2012 at 10:30 am

    #1571937

  • RE: How implement object orientation features in sql server?

    tz.bahrami (12/27/2012)

    How about polymorphism in sql? Could we use stored procedures for polymorphism?

    And for nested relationships can we define an attribute as OId and use it in a select query...

    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

    December 27, 2012 at 10:08 am

    #1571930

  • RE: i want to add column in exiting view

    ALTER VIEW <view name>

    AS

    <select statement here>

    GO

    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

    December 27, 2012 at 10:05 am

    #1571929

  • RE: Can a Table Really Have a Clustered Index?

    hakkie42 (12/24/2012)

    Ok, so in other words you're saying a clustered index means that the physical data is stored in index order, so e.g. binary searches are possible.

    Actually not. That's not...

    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

    December 27, 2012 at 5:44 am

    #1571831

  • RE: Stored Procedure looses execution plan.

    Bhuvnesh (12/27/2012)

    will this option also return value when first time exec plan get created ?

    Yes

    is this option gives the value of 'reason for early termination' when query...

    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

    December 27, 2012 at 5:13 am

    #1571822

Viewing 15 posts - 15,046 through 15,060 (of 49,552 total)