Tagged Questions
2
votes
1answer
69 views
Does READ UNCOMMITTED have the same effect as AUTOCOMMIT=1?
AFAIK running transactions as READ UNCOMMITTED means that there is no lock, so every change caused by a transaction is immediately visible to other transactions.
Is it correct to assume that this is ...
0
votes
4answers
240 views
Database/Storage engine suggestion for a project involving heavy inserts?
I am looking into a project which involves large number of inserts daily.I will have a list of user's (for example a user set of 500k ) , for which I need to monitor daily certain activities ...
1
vote
3answers
280 views
What's the most efficient UUID column type
For storing a 128 bits UUID there are multiple storage options:
a byte[16] column
two bigint/long(64 bits) columns
a CHAR(36) column - 32 hex digits + 4 dashes.
a UUID database specific column, if ...
0
votes
1answer
26 views
Please Identify this Export Format [duplicate]
I was sent this as a mysql dump, the file is labeled .sql, but it's clearly not a standard export. Is this something that can be used to reproduce a database and if so how?
Here is a small sample
...
0
votes
0answers
41 views
Openquery insert not working
I have a linked MySQL -server to MSSQL-server and I am trying to INSERT data to the table admin_user on the MySQL -server, but end up getting the error:
annot process the object "dbo.admin_user". ...
2
votes
2answers
208 views
Design of an application log database
We are generating logs like following example(this is a table no actual pipes):
2014-06-10 09:00:03.457 | Channel1 | Operation3 | Function15 | 15ms
2014-06-10 09:00:08.245 | Channel2 | Operation5 | ...
0
votes
0answers
13 views
Users_With_Messages Table normal form
I have the following tables in my database:
Above these tables (not pictured) is a Users table where the SendingUserId and ReceivingUserId are keyed onto (they are foreign keys).
Are these tables ...
0
votes
1answer
46 views
Is it good practice to keep 2 related tables (using auto_increment PK) to have the same Max of auto_increment ID when table1 got modified?
This question is about good design practice in database.
Let see this example, we have 2 interrelated tables:
Table1
textID - text
1 - love..
2 - men...
...
Table2
rID - textID
1 - 1
2 ...
1
vote
1answer
110 views
type recognition with MonetDB, *create* tables from CSVs
I am confused whether you can copy records into a new table in MonetDB.
The official documentation seems to talk only about copying into existing tables. I have quite a large universe of billions of ...
5
votes
2answers
151 views
'+' operator with one operand!
How does '+' operator behave in following statement?
select + 'taco'; --Result is 'taco'
Is it doing string concatenation with first string blank ('' + 'taco'), or does it mean something else?
0
votes
2answers
83 views
How to verify data dumps between two MS SQL and MySQL
I'm trying to verify data exported from MSSQL and imported into MySQL is 100% accurate using MD5 hash. On Linux, I'm using md5sum and WinMD5 on Windows. The encoding is the same: UTF8. I tried both ...
0
votes
0answers
42 views
DB2 manual asynchrounous real-time replication to NON-DB2 database
I have been given a Proof-of-Concept task to find out whether it is possible to set up manual (=no 3rd party tools allowed) asynchrounous real-time replication in DB2 that replicates all data changes ...
-4
votes
2answers
75 views
Performance with IN clause
Does indexed data affect query performance? means If I passed value as 1,2,3,4... in ordered form in any IN clause, can it improve query performance? and what happen in case I pass value randomly ...
0
votes
2answers
54 views
How to change the path of data during database restore + SQL Server 2008
I am trying to restore a big database in SQL Server 2008 R2. The database is about 700GB in size. My SQL Server is installed in C drive which has only 100GB of space left in it. I have the .bak file ...
0
votes
2answers
364 views
Join two subquery in hql
How can I write this sql query in as hql:
select count(distinct s.id) as prepaid, count(distinct ss.id) as postpaid
from (select * from subscriber where subscriber.ispostpaid=0) s
join (select * ...
-1
votes
1answer
87 views
MS Access + MS SQL Server for 1160+ users - Is it worth it? (Please Help!) [duplicate]
Our school in Delhi (India) wants to develop a professional and robust in-house database (SIS) that should handle vast amount of student information, including admissions, registration, re-enrollment, ...
0
votes
1answer
39 views
Migration of MYSQL to MS SQL Server
I need to migrate MySQL db to ms sql server 2012. Found enough information about it - looks like it can be done either with SSMA tool or via Data Import utility in SQL Server Management Studio. What ...
2
votes
2answers
1k views
How do I add a MySQL linked server to SQL Server?
I am trying to add a linked server on SQL Server to MySQL Server.
Note the SQL Server is installed on a separate machine with a different domain name.
The SQL Server is 10.0.1.1 on old_domain.com.
...
1
vote
2answers
239 views
Foreign key constraint based on conditional column
I'm trying to figure out the best way to handle this situation:
I have a table set up as follows:
LEARNING CONTEXT
================
LearningContextID - INT - Surrogate Primary Key
EntityID ...
1
vote
1answer
81 views
Mysql, sql server, oracle tables get too large [closed]
I hear a lot about things that, it is a lot cheaper to buy new harddisk than pay staff to come up with genius ideas how to save resources. But what I don't understand, is how these databases handle a ...
1
vote
0answers
78 views
MS SQL Server: Can Unicode columns include non-unicode values?
I need to convert UNICODE column values from UTF16-LE to UTF-8 to then import into MySQL. Is it safe to assume columns of NVARCHAR, NTEXT, NCHAR, BIT, INT, DECIMAL, FLOAT, and DATETIME all MUST be ...
0
votes
3answers
930 views
Do SQL Server or MYSQL contain JSON supporting functions?
Do SQL Server or MYSQL contain JSON supporting functions? If so, then please tell me the name of the functions or where else I can find it?
I am new in this stuff and I want to implement JSON with ...
1
vote
0answers
326 views
How do I convert unicode data from UTF-16LE to UTF-8 when migrating from SQL Server to MySQL?
Objective: Ensure existing Unicode (UTF-16LE) data is displayed the when moved to MySQL (UTF-8).
Background:
I'm migrating 1TB from SQL Server to MySQL. The current Collation in SS is ...
0
votes
0answers
55 views
Why should be Mysql considered over Mssql in a live working scenario? [closed]
Why should be Mysql considered over Mssql in a live working scenario?
I am working in a private software company and i am a fresher and i have been instructed to move from Mssql to Mysql. But i ...
3
votes
2answers
299 views
Equivalents to `ora_rowscn` in other databases?
Do other databases other than Oracle have ora_rowscn (http://docs.oracle.com/cd/B19306_01/server.102/b14200/pseudocolumns007.htm) equivalents, or do you have to implement them yourself in your fields, ...
-1
votes
1answer
344 views
How to create a mysqldump file automatically from SQL server database on a daily basis
I want to create a mysqldump file from a SQL Server database, I know its possible using MYSQL workBench, what i want is to make it completely automate. So the script runs on a daily or weekly basis ...
-6
votes
1answer
2k views
Using inner join to get data from multiple tables [closed]
I have 5 tables:
A(a_id, a1, a2);
B(b_id, b1, b2, a_id);
C(c_id, c1, c2, b_id);
D(d_id, d1, b_id);
E(e_id, e1, e2, d_id);
table b have a_id match with table a(a_id).
table c have b_id match ...
1
vote
1answer
93 views
Migration of create statement from SQL Server to MySQL
I have a table that have the following table structure
CREATE TABLE [dbo].[ASAT](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[ASATID] AS ('ASAT'+right('00000000000000000000'
...
1
vote
1answer
747 views
SQL Server-MySQL master-master replication
We are looking into setting up a master-master replicated MSSQL database and I am interested to hear of any potential pitfalls that we may run into along the way and generally any advice that you ...
0
votes
2answers
281 views
Generic SQL Job Scheduler for multiple RDBMS's?
I have been searching for an answer to this, but can't seem to find anything. So my problem is this - we have an environment with MS SQL Server 2008, MySQL, and RedShift, and have some complex ...
0
votes
0answers
382 views
best way to copy data from SQL Server db to MYSQL DB(remote)
I currently copy data between my local SQL Server to a remote MySQL database linking in SQL and doing a data transformation task but now I'm sending lots of data it is getting very slow.
Just after ...
1
vote
3answers
10k views
How to migrate SQL Server to MySQL
I'm trying to migrate a SQL Server db to MySQL, and I'm having a tough time. I've tried:
MySQLWorkbench -- migration tool fails because my login only shows views in SQL Server, not the tables ...
1
vote
1answer
983 views
SQL Server to MySQL migration - how can I remove UCS-2 surrogate pairs in SQL Server?
I have been tasked with migrating a SQL Server 2005 database to MySQL 5.6 (these are both database servers runnig locally) and would really appreciate some help.
-------Edit - Answered-------
This ...
2
votes
3answers
2k views
How to import table's data in MySql from Sql Server?
I am trying to export table from SQL Server 2008 R2 TO MySql 5.5. For this I am using SQL Server Import and Export Wizard of Sql Server 2008, but it is giving this error.
Here this error may be ...
4
votes
1answer
154 views
Worth investing in MS SQL? [closed]
Not trying to start a war here, but I would like some thoughts.
I work for a small nonprofit that is eligible for generous charity licensing from Microsoft. I am the database/web coder and my ...
1
vote
1answer
215 views
Efficient query plan for selecting all data duplicated on several columns
The flavour in question is PostgreSQL, but it is a generic enough query pattern that your techniques for optimising against other RDBMs should help as well.
The purpose of the query is to show all ...
0
votes
1answer
105 views
MS SQL and MYSQL [closed]
I was going through some theoretical concepts about SQL based databases. One thing that I found interesting was that MySql and MS SQL are Relational-SQL-Database Management-Systems.
Since they both ...
5
votes
1answer
420 views
SQL Server / MySQL to DTD (+XML)
Is there any way I can at least export a table schema from MSSQL or MySQL to a DTD file? Also the same for the data of the tables to XML.
I am really not getting how to write DTDs, so I badly need a ...
1
vote
4answers
136 views
Transfer selected information from a SQL Server business server to a MySQL web server?
I have a SQL Server dedicated server used for business information on service users etc, and a VPN with MySQL for the main website operation. I wish to transfer some selected tables from SQL Server to ...
3
votes
2answers
553 views
Save history editable data RDBMS
I want to make application like testing system. Every question has one or many variant of answers (and one or many can be right). I apologize that tutors and students use my testing system. It means ...
3
votes
2answers
568 views
SQL ANSI JOIN precedence
I have a query that looks like this:
SELECT *
FROM TBLA A
LEFT JOIN TBLB B ON A.Col1 = B.Col2
RIGHT JOIN TBLC C ON B.Col3 = C.Col4
JOIN TBLD D ON C.Col5 = D.Col6
In which order ...
1
vote
0answers
101 views
MS SQL to MySQL Conversion
Is there a tool available that converts queries written as triggers, stored procedures and functions written in MS SQL 2008 to MySql? We switched databases and now I need to rewrite a bunch of queries ...
8
votes
2answers
4k views
For absolute performance, is SUM faster or COUNT?
This relates to counting the number of records that match a certain condition, e.g. invoice amount > $100.
I tend to prefer
COUNT(CASE WHEN invoice_amount > 100 THEN 1 END)
However, this is ...
1
vote
1answer
821 views
How to restore a MySQL file to SQL Server 2008
I have a MySQL file (apple.sql) that I need to restore to a SQL server 2008 database or at least be able to access the database through mySQL. I have created a linked server mySQL, created an empty ...
5
votes
2answers
552 views
How to determine which SQL Server user or database overuses server resources
I have a Microsoft SQL Server instance on my server with more than 100 databases and users. Sometimes, the SQL Server process use 100% of server CPU and I want to know which query/user/database is ...
-1
votes
0answers
331 views
Synchronising SQL tables in two locations [closed]
We have a bit of a conundrum at the moment.
ANSI SQL solutions please.
We have two databases located at two different geographic locations and will be using the web for all traffic between the two ...
1
vote
2answers
596 views
SQL Partioning on date, how does it work for future records?
I am setting up a new system and I would like to partition the data for speed. Basically what I would like to do is have one database with all the latest information (e.g. last 3 months). then have ...
2
votes
2answers
3k views
MySQL Workbench copies Schema, but not data, from SQL Server 2008
I need to copy/migrate a database from MSSQL (SQL Server 2008) into MySQL. I am using the MySQL Workbench kit, and work through the process of the Migration. Each respective DB user has full access, ...
1
vote
2answers
1k views
Database table data transfer between different servers using bcp.exe and mysqldump
I have 2 servers, both are exact clones of another, one is PRODUCTION live use and the other is strictly for backend DATAENTRY.
Using MSSQL on two different servers I am using the following command ...
0
votes
6answers
7k views
How to recover deleted/updated record in sql server or mysql?
I want to know that is there any way that I can can recover the deleted or updated record in the sqlserver and mysql as well?
