Unanswered Questions
27
votes
2answers
7k views
MySQL 5.1.66 SSL connection error ERROR 2026 (HY000)
UPDATE2
Using WireShark I found out the problem string (I hope I did):
28 | 9.582638 | 192.168.18.128 | 192.168.18.129 | MySQL Response Error 1043
And the error is (according to docs):
Error: 1043 ...
17
votes
0answers
326 views
Service broker was backed up, now receiving, but doesn't seem to be processing
Having a problem with Event Notifications. On the machine/drive/database that the messages are sent to (receiver), the drive filled up when nobody was looking, so it's been backed up all day.
Now ...
14
votes
1answer
344 views
Can I tell when and who updated my database from v11 to v12 on Azure?
Earlier today I noticed that all my Azure SQL database servers where updated from v11 to v12. I am the only one in my company that should be touching those dials, but not the only person in my company ...
13
votes
1answer
614 views
SQL Deadlock on the same exclusively locked clustered Key (with NHibernate) on delete / insert
I have been working on this deadlock issue for quite a few days now and no matter what I do, it persists in one way or another.
First, the general premise:
We have Visits with VisitItems in a one to ...
11
votes
0answers
478 views
How to reload a linked server?
I am using Microsoft SQL Server 2014 Enterprise Edition. A problem occurs with the linked servers where it is necessary to restart the server, or to stop the MSSQLSERVER service. When the server is ...
11
votes
1answer
306 views
stats_column_id and index_column_id do not update with physical order of clustered index is changed
Unless I'm misunderstanding the purpose of the column, the following code indicates that a change of the structure of the clustered index does not change the ordinal position (stats_column_id)of the ...
11
votes
4answers
1k views
Update all rows
I want to know the most efficient manner to update every row in an extremely large Oracle table for a single column. For example:
update mytable set mycolumn=null;
or:
update mytable set mycolumn=...
10
votes
0answers
244 views
SQL Server - Handling localization of strings in nested non-deterministic view stacks
While profiling a database I came across a view that is referencing some non-deterministic functions that get accessed 1000-2500 times per minute for each connection in this application's pool. A ...
10
votes
0answers
586 views
PostgreSQL Transaction Committing for hours
I'm running into an issue whereby I have two connections from a user to my PostgreSQL server which have been running for about 4 hours and have been in a commit state for quite some time (at least 1 ...
10
votes
0answers
252 views
9i streams capture doesn't evaluate rules
I have a streams replication set up between two oracle 9.2.0.8 instances as sources and an 11g instance as a destination, processing a small subset of data from each database (let it be one table ...
9
votes
1answer
666 views
CouchDB and document versioning
I'm currently working on a wiki-esque application using CouchDB and am trying to implement a document versioning scheme. The way I see it there are two ways of doing this:
Store each version as a ...
9
votes
1answer
3k views
Use LDAP for name look up with Oracle Instant Client
Partly as a result of having problems with conflicting versions or bitness with the full installation of Oracle client, my development team (of which I'm a member) has been moving towards using Oracle ...
9
votes
2answers
317 views
How to configure SSRS (SQL Server 2012) to run on a different instance, but same server as SharePoint
I have an instance of SQL Server 2012 running on Windows 2008R2 along side another instance of SQL Server 2012 that is running SharePoint (I think it is SharePoint 2010).
When I try to access the ...
9
votes
1answer
11k views
How to use SUBSTRING using REGEXP in MySQL
I have the following situation. I have to substring regular expression from description using MySQL.
Description:
Lorem D9801 ipsum dolor sit amet
Where D9801 is REGEXP. Every strong text ...
8
votes
0answers
146 views
insufficient history for index
In MySql log, there is one error `InnoDB: insufficient history for index 0'
I don't know why its occur.
I have done google and found following http://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-...
