The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
34 views

Optimize UNION query in MYSQL

I have a problem with a UNION query in MySQL. We have 10 millions players on our website and we would like to select players with a multi-criterias system. For exemple, selecting US people, men, > 35 ...
2
votes
0answers
173 views

SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled

I have two SQL Server instances in an availability group. They are not mirrored. I'm trying to connect to the AG using the MS JDBC drivers (4.0) with a connection string including ...
1
vote
0answers
22 views

DPM and AlwaysOn - Can they work

How does AlwaysOn tie into DPM for SQL Server 2012? Can we use one or the other for High Availability ? Can they work together or must they be used separately. Thanks
1
vote
0answers
43 views

dropping and adding subscription only picking up new article on some subscribers

I have used the following script to drop aand re-add a table from a subscription so I could move replace the ntext fields with nvarchar(max) columns. the script worked fine, but when I ran the ...
1
vote
0answers
271 views

SQL Server Database Mirroring : strange client application behavior upon failover

I am putting a HA SQL server environment up based on three SQL Server 2008R2 machines and database mirroring. I'll name them : principal.company.intra mirror.company.intra witness.company.intra ...
0
votes
0answers
14 views

PowerPivot doesn't install in SharePoint mode on an Active/Passive Cluster

We a provisioning a new SQL Failover Cluster. We have successfully configured the SQL instance, and have moved on to configuration of the PowerPivot for SharePoint instance. We run the configuration ...
0
votes
0answers
18 views

Table partionning problem

I need your help for a partionning problem. We are using a "log_event" table which log a lot of events sent by our players (subscription, connection, play, share, etc...). We insert 5,000 row / s in ...
0
votes
0answers
123 views

Oracle Data Guard Fast-Start Failover Questions

Here is the setup in question: Fast-Start Failover: ENABLED Threshold: 30 seconds Target: dbabc Observer: (none) Lag Limit: 30 seconds (not in use) Shutdown Primary: FALSE ...
0
votes
0answers
304 views

JBoss / Alfresco : No operations allowed after connection closed

I'm trying to set up an high available MySQL "cluster", using a Master / Slave Replication configuration. I want to the slave become master (e.g. not read-only but writeable) if the first node come ...