0
votes
0answers
6 views
Storing history of full/partial tables in MySQL
I'm building a web-application with Django and MySQL (InnoDB) and am currently pondering over how to manage historical changes on various tables.
I wonder if it's efficient to store a lot of rows ...
0
votes
0answers
14 views
Data Migration from Oracle to SQL Server
If you need to do a data migration from an Oracle database to SQL server, what approaches and technical solutions are the best practice?
Our database has about 100 million rows and a total of 52 ...
0
votes
0answers
13 views
How to make continues cluster in postgres?
I have a report table with the following index:
providerid,date
The table is around 30M records and its grow on a daily basis based on provider actions (100K grow for a day).
I want to use in the ...
0
votes
1answer
15 views
help with best practice of merging sql databases
Bad news, our website server (windows 2003) crashed because of dead RAID controller.
Luckily few hours later our backup server was up and website was live again.
Hopefully tomorrow our original ...
1
vote
1answer
11 views
mysql-5.5 errors while creating multiple instances
i have installed 3rd mysql instance on my testing server.
2 instances already running without any issues.
when i installed 3rd instance by mysql-5.5.30 zip source, it installed successfully but when i ...
-3
votes
0answers
26 views
How do I create rows of test data in each table?
I am currently working on an assignment. Part of the assignment states "create a minimum of 15 rows of test data in each table and create at least 3 queries that joins two tables and returnes values ...
0
votes
1answer
14 views
3nf but waste more storage space
I have a table which has three columns: account, idNumber, and position. The account and idNumber are unique.
Here is my thought to analyze and I don't know whether it is right or not.
account is ...
0
votes
1answer
24 views
Database structure for tags?
I posted a thread on Stack Overflow and one person pointed out that my database structure wasn't the best so now I'm here to ask how to do this in a good and proper way.
Currently I have one table ...
0
votes
0answers
10 views
Percona Xtradb cluster only replicating DDL statements
I'm having a hard time with percona xtradb cluster. The cluster has 3 nodes, and is up and running (all tip top according to wsrep status indicators).
It did the SST perfectly fine from one node to ...
1
vote
1answer
22 views
Table restraints to limit value insertions based off of other values in a row
Using SQL Server 2008 R2
Is it possible to limit what values are allowed in a coulumn based off of other values in the row.
Ex:
myTable:
ID, Test_mode, Active
1 , 1 , Null
2 , 0 , 1
...
1
vote
1answer
15 views
MySQL Insert Row With Foreign Key Equal to ID - Circular Reference
In MySQL database I have an events table which has a circular reference to itself with the following columns.
id (PK) | user_id (FK) | event_id (FK) | title
Each new row inserted has a circular ...
0
votes
0answers
14 views
packages that php need to connect to mysql
I want to know minimum packages that php need to connect to mysql?
I know some packages such as php5-mysql, mysql-common, mysql-client,...
Also I want to know a short description about architecture of ...
0
votes
1answer
9 views
MySQL Master/Slave without populating tables
So I have some Zabbix instances which are using MySQL for their backends. What I would like to do is, for DR purposes, backup the DBs for each instance using a Master/Slave configuration, with the ...
1
vote
0answers
12 views
Add new shard - always best?
In our setup, we currently have 3 shard set sharded cluster, each shard being a replica set of 3. Our writes are about to go up significantly to implement a new feature, and we know the extra data ...
4
votes
0answers
34 views
Sudden increase in log_file_sync waits
I'm on Oracle 11gR2 with a 2 node RAC system. It's shared fiber storage to an EMC Clariion.
Last friday things went bad..fast. All of the sudden processes that normally ran fine for years became ...
0
votes
1answer
21 views
“relation does not exist” trying to import mysql dump into postgres
environment:
ubuntu 10.04
mysql server 5.1.69
postgres 9.2
Here's the sequence of steps:
created a new postgres database, myDatabase
executed this command: mysqldump -u root -p ...
-3
votes
0answers
23 views
How do I add a index column to a database with non unique columns [closed]
I have a database with non unique data in columns, How do I add a index column or add a primairy key column?
0
votes
1answer
17 views
Candidate key = Key = Minimal Superkey?
I got a little confused by all these keys. As I understand
A key of a relational schema =
The minimal subset of a superkey that is still a key =
A candidate key
Is this correct or not?
0
votes
0answers
10 views
import openoffice .ods file with specific structure like date and value fields
How I can import with keeping the structure of the data like date fields and numiric fields the rest of the fields is text.
With import into mysql with import function from phpmyadmin from an .ods ...
0
votes
0answers
17 views
Gathering data from independent databases to a central one
I need to do the following. In a LAN there are 4 postgres boxes each having a small postgres database. These servers are gathering data from the internet and insert them as records in a table in their ...
0
votes
0answers
16 views
Performance of large queries on low bandwidth connections
I've been running some measurements on bandwidth needs and the effects of latency on query performance against Postgres 8.3 (waiting for management to approve upgrade) on Windows. SELECTs of various ...
0
votes
0answers
20 views
Performance of database with transactional data
There are lots of row modifications (several thousands of rows per minute) in our PostgreSQL database that stores transactional data. We have a problem because PostgreSQL runs vacuuming process and ...
0
votes
0answers
21 views
Mysql 5.6 and install php5-mysql , mysql-common
I install Mysql 5.6 with this documentaion(in ubuntu 13.04) , now I need to install php5-mysql and mysql-common packages. can I install them with apt-get? I think they will install mysql5.5 ...
1
vote
0answers
18 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 ...
0
votes
1answer
42 views
using CASE with ISNULL
I have a select statement which is followed by a union. Inside the select, there is a where clause. I am trying to add in the following code to the where clause but I'm having an issue getting it to ...
0
votes
2answers
18 views
MySQL : Query WHERE clause and JOIN
I'm having an issue using a WHERE clause and JOIN.
SELECT * FROM `CallDetailRecord` WHERE `StartTime` >=1357102799000 AND `StartTime` <=1357880399000 JOIN `CallEvent` ON `EventID` = ...
0
votes
1answer
18 views
Understanding oracle SCN
I am currently working as junior Oracle DBA in a company.Now my team leads always tell me that I have to understand how SCN works and what I can do with the knowledge about SCN.So,are they really ...
1
vote
1answer
29 views
Database design: Two 1 to many relationships to the same table
I have to model a situation where I have a table Chequing_Account (which contains budget, iban number and other details of the account) which has to be related to two different tables Person and ...
0
votes
1answer
14 views
“Truncate” or “Delete/Vacuum Full” for deleting some of the table rows
I have a db which has 223 tables and I have to delete some of the records from 10 of them, each has apprx. 1.5million records. Those tables are storing the temperatures every 7seconds. We have decided ...
1
vote
2answers
16 views
MySQL Federated tables and Triggers
This is the scenario.
Have two MySQL servers (S1, S2) on different machines, with a database on each (DB1, DB2).
I have a table (T2) on DB2 that needs to "fectch" rows from another table (T1) on ...
1
vote
0answers
40 views
Re enable Windows Authentication [closed]
My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.
4
votes
2answers
74 views
Re enable Windows Authetication in SQL Server
My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.
I ...
0
votes
0answers
35 views
When to split a large table
I run the SQL Anywhere DBMS, and we have a table of about 10 columns(normal text, timestamps etc).
However, in my use-case, every single day, the table gets 2160000 new rows.
It's also crucial that ...
0
votes
1answer
13 views
Oracle DB 11gR2 netca installation failing
I am getting below error when I run netca from command line
cmd: /u01/app/oracle/product/11.2.0/db_1/bin/netca /silent /responsefile=/oracle_binaries/database/response/netca.rsp
[main] [ 2013-05-17 ...
0
votes
1answer
27 views
TokuDB/InnoDB Question
What's the faster scheme for insert data to TokuDB or InnoDB Engine? Over 200 Insert per second.
That's okay to answer of one engine.
TABLE: `game`
`gameId` bigint 20 (PK)
`gameMapId` int 4
...
0
votes
2answers
42 views
Can't use SQL Server database on a networkpath
I am working on a project for a very long time now. It's a .NET application which works with a SQL Server database (.mdf, LINQ to SQL). Now I am almost finished and wanted to run some tests.
But ...
0
votes
1answer
3 views
Simple MySQL table copy from one server to another?
this question has kindof been answered in a number of ways. Nothing that quite fits the bill (as far as I understand it).
I have MySQL Table X on Server A. I would like an exact copy of this table, ...
0
votes
1answer
30 views
Copy tables from a stand-by database
I want to explain the following. I have a database that is a recovery db from our main environment. This database is kept up-to-date through log shipping. However, I want to copy all tables from this ...
0
votes
2answers
17 views
copy package from schema B to schema C
I am in the next situation: I am using oracle 11g. I am connected to an user, lets say schema1, where are a lot of permissions. I want to create a script which will copy the Package1 (and its body) ...
2
votes
0answers
22 views
SQL Service Broker stops working
I'm new in using service broker. Our existing service broker suddenly stops working and I can't figure out why.
When I try to enable service broker (which is already enabled) I get this in SQL error ...
0
votes
1answer
35 views
convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112)
Which sql command is recommended to convert a date to yyyymmdd?
1) convert(varchar(8), getdate(), 112)
or
2) convert(varchar, getdate(), 112)
I notice that if I used I use the 2nd one, it seems ...
1
vote
1answer
39 views
SQL Server getting the 2nd and 3rd occurence or getting the 3rd value between two symbol in a string
I have the following table:
==========================================================
| Name_Level_Class_Section | Phone Num |
...
0
votes
2answers
38 views
MySQL Hierarchical Structure
Every single user has say, 3 of GROUP_A, 10 GROUP_B's per GROUP_A, and 20 GROUP_C's per GROUP_B. And each of the 20 GROUP_C's involve lots of inserts/deletes...
I'm not an expert, but I've done ...
2
votes
3answers
30 views
How to reduce network latency during mirroring?
We are using SQL Server 2008 R2 Standard edition for mirroring.
But we found out that network latency is too high. It takes nearly four times time to complete a transaction while mirroring is active. ...
0
votes
1answer
25 views
BI and Self Service Reporting Tools that Support Web (HTML) Interface? [closed]
Hopefully a simple question. What BI tools (commercial or OSS) support self-service reporting or self-service BI via an HTML web interface?
I specified HTML because I know of at least one that can ...
-3
votes
1answer
18 views
Microsoft Assessment and Planning Toolkit for Windows server 2003 [closed]
Can anyone please tell me where I can find Microsoft Assessment and Planning Toolkit for Windows server 2003?
I tried using version 8.0 but it fails to install on Windows server 2003.
thanks
0
votes
1answer
20 views
No way to set maximum retrieved rows in pgadmin query tool
I'm using version 1.16.1, and I can't find a "max(imum) rows" param to tweak. Any help would be appreciated.
0
votes
1answer
13 views
In SQL Server 2000 or greater is their a system primary key associated with each row
Does a system primary key or unique identifier for each row in a table exist? Like @@ROWID, @@IDENTIFER, or some other identifier that uniquely identifies each row regardless of how it was created. ...
2
votes
2answers
66 views
Is there a fast way to change column type without dropping the clustered index?
I have a large table that is clustered index on a bigint. We would like to change it to just an int to reduce the space and improve the performance. However, dropping the clustered index and recreate ...
0
votes
1answer
12 views
Table Design for user-specific and user-agnostic criteria
I want to design a table that is general enough to accommodate an increasing number of achievements as I come up with new accomplishments to reward. Initially, I thought to design the table as ...
