Forum Replies Created

Viewing 15 posts - 1 through 15 (of 1,304 total)

  • Reply To: Space Error

    ScottPletcher wrote:

    Should use the new file just fine.  Make sure the new file is present, or you will have no space to write to.

    What's happening is this.  Your file has...

  • Reply To: Space Error

    ScottPletcher wrote:

    The first two are not full but don't have room to expand by the specified amount.

    Alter the first two files to have a maxsize of their current size.  That...

  • Reply To: Developer vs Enterprise

    Michael L John wrote:

    VastSQL wrote:

    Michael L John wrote:

    VastSQL wrote:

    Any difference wrt to performance?

    They code base is identical.  The only differences are the licensing.

    Curious, why would you think that there may be a performance difference?

    Thanks...

  • Reply To: MSDTC and Always On AG

    Michael L John wrote:

    If this is an availability group, why do you need shared storage?

    We configured it separately on each server.

     

    Thanks Michael. As per the link we need to configure the cluster...

  • Reply To: Developer vs Enterprise

    Michael L John wrote:

    VastSQL wrote:

    Any difference wrt to performance?

    They code base is identical.  The only differences are the licensing.

    Curious, why would you think that there may be a performance difference?

    Thanks Michael,

    Just to...

  • Reply To: Developer vs Enterprise

    DesNorton wrote:

    I have no idea about performance differences.  Although I cannot imagine that there will be a difference, as they are the same product installed from the same media.  In...

  • Reply To: Developer vs Enterprise

    DesNorton wrote:

    Developer edition is free to download, and has all the bells and whistles of all the versions, so that you can develop the features you require.  HOWEVER, you cannot...

  • Reply To: removing database from AG and putting it back in

    noobdba wrote:

    Lets say a database was removed from AG for maintenance purpose. The primary node would have the w/r copy of it and secondary would have it in restoring state....

  • Reply To: Windows Authentication for Applications

    Grant Fritchey wrote:

    At the most fundamental level, access to data & structures within a database, there are zero differences between a SQL login and a Windows login. You will map logins...

    • This reply was modified 4 months ago by  VastSQL.
  • Reply To: Windows Authentication for Applications

    Grant Fritchey wrote:

    OK, I'm a little confused by how the question is phrased. It sounds like you & the security team are hesitant to use Windows Authentication? Don't be. Use it....

  • Reply To: Staging or UAT Environment

    Jeff Moden wrote:

    VastSQL wrote:

    Jeff Moden wrote:

    If you stop calling it "Pre-Prod" and start calling it "UAT", there will be no question that it's not actually a production environment.  Of course, no part...

  • Reply To: SQLServer won't start?

    jbalbo wrote:

    Hi

    Not sure what happened, but hoping someone can point me in the right direction.

    sqlserver won't start, the event log has this error

    Faulting application name: sqlservr.exe, version: 2014.120.4100.1, time stamp:...

  • Reply To: Staging or UAT Environment

    Jeff Moden wrote:

    If you stop calling it "Pre-Prod" and start calling it "UAT", there will be no question that it's not actually a production environment.  Of course, no part of it...

  • Reply To: Index Lookup

    Grant Fritchey wrote:

    Looking at the plan, it's calculated columns or constraints. It has to retrieve the data in order to do the validations, so that's why you're seeing a lookup operation.

    Thanks...

  • Reply To: Index Lookup

    Grant Fritchey wrote:

    Without seeing the execution plan itself, I'm just guessing. However, it's likely that you're seeing lookups because of foreign keys. Modifying columns that don't contain any foreign keys will...

Viewing 15 posts - 1 through 15 (of 1,304 total)