Viewing 15 posts - 31 through 45 (of 1,330 total)
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
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...
January 6, 2021 at 5:15 pm
I am seeing a lot of PAGEIOLATCH_SH wait types when the sp runs.
Can you share your execution plan here?
October 27, 2020 at 7:30 am
Hi - I setup a new SQL FCI in Azure. Two newly created VMs with SQL 2019 installed. Cluster validates successfully and i configured the Load Balancer per the...
October 26, 2020 at 3:30 am
If that is the case..how do I know the exact reason for the slowness?
Thank you
How many records does the procedure return during both executions? Is the count same?
Are you...
October 26, 2020 at 2:56 am
Sounds like a dangerous thing to do in production
Is this part of migration, a one time task or will you want your monster script to run regularly?
This is a...
October 26, 2020 at 2:51 am
Viewing 15 posts - 31 through 45 (of 1,330 total)