Your search for "always on" returned 100 results:
Question for the group. We just setup a new SQL 2014 SP1 system with two servers and have all of the databases setup in AlwaysOn. My question is when it comes time to apply a service pack or a CU do you have to take all of the databases out of the AG, apply the […]
2016-02-04
2,191 reads
Hello everyone! I would glad to know, what is the difference in Always on between Standard and Enterprise edition? And also there is something that change in 2012 and above? Thanks!
2019-12-09
7,084 reads
Hi all, We have SQL 2017 on windows physical host. This is with Always on set up with 20 databases. We are facing high cpu usage. Previously the usage is below 85% and suddenly started 90% and above. It’s fluctuating be 80-99%. We did the statics update on all databases. We have index defragmentation job […]
2023-03-02
525 reads
Greetings,The DB environment that I work in is primarily data warehousing. Copies of data imported through SSIS packages, etc. and stored for reporting purposes. Not a high availability environment, so the most we've done with replication type things has involved saving/restoring backups. We've been asked by another department to take a nightly (at minimum) copy […]
2018-04-25
3,843 reads
Hi All, I am planing to change the sql server service account in two node always-on setup. Need to know the steps that needs to be taken which is a recommended way. Also, what are the minimum permission required to give this new service account on the domain. I know we need to give certain […]
2018-01-29
2,336 reads
Hi I couldn't seem to find a forum for this, so picked this one as seemed to be the closest. I've been looking round for a while on this but I'm either looking in the wrong places or there is not much out there. I am looking at a partitioning a large table with millions […]
2013-08-01
499 reads
Hi all, I have read the stairways to alwayson series. I have also understood alwayson does not need any shared storage resource. But Alwayson sit on WSFC (assume it is a 2 node WSFC) - surely WSFC would need a shared disk (voting/witness) for maintaining quorum ? So a shared disk is needed after all […]
2016-08-22
3,099 reads
Suppose I have the following two node cluster configured with an AG. All are on the same domain, use the same service account, and have named instance SQLInstance. SQLA and SQLB run on port 123 and SQLC (listener) runs on port 789 Node1 - SQLA Nodel2 - SQLB AG Name - TestAG AG Listener - […]
2020-08-28
6,299 reads
SQL Server 2016 standard edition, with primary databases and one other server set up as secondary failover with always on availability group. There were some issues over the weekend with an application that accesses the databases on this server, unbeknownst to me, they decided just to reboot the database server, which seemed to clear things […]
2019-12-09
3,924 reads
Looking to upgrade from SQL Server 2014 to SQL 2016 which has always on AG on SQL 2014. Is there a better approach to do this upgrade with Always on AG. Thinking to upgrade first from SQL 2014 to SQL 2016 and then reconfigure always on AG on SQL 2016. If it's just service pack […]
2019-06-17
1,026 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
I have had a hard time to understand how to use EXISTS. I Always...
Dears, We are using Azure Data factory pipes to run some stored procedures against...
Hi, I have SQL Server 2019 installed and when go the Clear Trace database...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers