Viewing 15 posts - 46 through 60 (of 1,341 total)
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
Hi all,
I need to create a job to dynamically script out indexes and some other objects from Server A and apply them on Server B. They are linked through...
October 26, 2020 at 2:49 am
Will give that a shot and update the forum. Thank you!
Hope the Listener did the trick for you.
The listener act as a single name to both the nodes. Use...
October 26, 2020 at 2:46 am
I am having the same problem. my sql 2016 cluster is on azure. i have opened 1433 tcp and 1434 udp ports in firewall and in azure network security...
October 26, 2020 at 2:43 am
We have identified a query which was running on a huge table . The query was selecting the whole table (*) without an index on where clause and the values...
October 25, 2020 at 5:37 am
Viewing 15 posts - 46 through 60 (of 1,341 total)