Viewing 15 posts - 331 through 345 (of 2,495 total)
The main choices are Triggers, Merge Replication, Microsoft Replication Objects,, Service Broker, and Distributed Transactions.
Triggers have one advantage, in that you do not need to change any existing code and...
December 21, 2015 at 6:49 am
What if you can't establish a remote session to SQL Server via SSMS
I can remember maybe less than 5 situations like this over more than 10 years. In these...
December 14, 2015 at 8:22 am
It seems to me that your management are confusing business and technical requirements. All this stuff about different synchronisation timescales sound like business-critical and non-critical tables.
My suggestion is to...
December 14, 2015 at 7:55 am
I have always tried to get an environment where my administration tools are on a separate Windows instance to the database servers. One of the main reasons is that...
December 14, 2015 at 7:12 am
I have installed many SQL instances using gMSA accounts. To use these with SQL 2012 or SQL 2014, the account name must end with a $ and be no...
November 30, 2015 at 2:18 pm
Going back to your original question - why there is only 1 tempdb in SQL Server.
I know that some other DBMS systems have multiple scratchpad areas. I understand Oracle...
October 17, 2015 at 4:50 am
It sounds like your users have a Stage 4 predicate in their query...
Stage 0: Data access is eliminated by the optimiser. Anything the optimiser can reduce to a WHERE...
October 17, 2015 at 4:18 am
I think IoT will lead to a significant change in Computer Misuse legislation all round the world. In order to counter the viruses that will go round infecting anything...
October 8, 2015 at 1:49 pm
Some commentators have already pointed out that as we move into IoT, some of the things on the internet will have working lives measured in decades and many will have...
October 7, 2015 at 10:25 am
Regarding SQL AGs, it is SQL Server that replicates data between servers, so no additional software is needed. They also give near-instantaneous failover.
Other solutions that do the replication for...
October 5, 2015 at 11:17 am
I noticed that all the people posting their experience with Zerto were very new users to this site. It would be good if some of the long-standing users of...
October 5, 2015 at 10:44 am
If you think that hiding objects will make your system more secure then you are wrong. At best it will give you a warm fuzzy feeling of security, but...
October 5, 2015 at 10:22 am
If you purchased your license after the release of SQL 2014 then you are bound by the restrictions that were new to SQL 2014 even if you are 'downgrading'...
October 5, 2015 at 10:09 am
When you look at tempdb you will often find a very high % of free space. This is normal, because you are looking at the current usage of tempdb,...
October 5, 2015 at 9:30 am
I have to provide few options. Then based on budget and resources, management will decide
You are right that technical staff need to supply the options and that management will decide...
September 4, 2015 at 12:39 am
Viewing 15 posts - 331 through 345 (of 2,495 total)