Viewing 15 posts - 61 through 75 (of 1,366 total)
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,...
August 18, 2021 at 5:25 am
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...
April 4, 2021 at 8:48 am
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...
March 28, 2021 at 5:17 am
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...
March 6, 2021 at 7:39 pm
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...
March 6, 2021 at 7:38 pm
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...
February 28, 2021 at 4:39 am
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...
February 28, 2021 at 4:37 am
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...
February 25, 2021 at 10:53 am
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....
February 21, 2021 at 5:19 am
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...
February 11, 2021 at 11:31 am
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....
February 10, 2021 at 7:26 am
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...
January 21, 2021 at 5:03 am
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:...
January 20, 2021 at 5:28 am
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...
January 20, 2021 at 4:06 am
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...
January 7, 2021 at 6:32 am
Viewing 15 posts - 61 through 75 (of 1,366 total)