Forum Replies Created

Viewing 15 posts - 61 through 75 (of 1,366 total)

  • Reply To: Migrate On-prem DB

    Grant Fritchey wrote:

    Filestream just isn't supported on Azure SQL Database or Managed Instance. You just can't use it at all. I haven't tested this particular scenario with the Migration Service,...

  • 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 years, 6 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...

Viewing 15 posts - 61 through 75 (of 1,366 total)