1
vote
0answers
11 views
Statistical Analysis of Data that has to be done in an order?
Bear with me - that is the first time try that in SQL Server, normally I have been doing that on the front end ;)
I a implementing some analysis on time coded data series. This is not super ...
0
votes
1answer
12 views
Cannot see Green Button with white arrow in object explorer; DTC config problems?
I have SQL Servers across locations setup for replication. One of the SQL Server instances that I installed, running locally I can see the green button with the white arrow in the object explorer when ...
0
votes
1answer
13 views
SQL Server Memory for Backup Buffer
In SQL Server 2012 memory for backup buffer comes from buffer pool or non buffer pool (VAS)? Is this behavior changed between SQL server 2008 R2 and SQL 2012?
EDIT: Does MAX Server Memory ...
0
votes
0answers
4 views
UTF8 vs ASCII or custom binary format: high-performance optimization on very big tables
The summary of my question is whether there are advantages, even if minimal, to use ASCII, or even a smaller format designed yet created specifically for the situation, instead of UTF-8 for strings.
...
0
votes
1answer
20 views
Can I limit an index to only contain the newest relevant row?
I have a table in PostgreSQL 9.2 that records login sessions called user_login_session. This table contains a user_id, start_timestamp and end_timestamp columns, amongst others. This table has started ...
0
votes
1answer
10 views
Exadata exachk.sh
I would like to run exachk.sh on regular basis.
Now I have to interact with the script and answer all kinds of password questions before the script starts to extract exadata information.
I want to ...
4
votes
1answer
56 views
Optimum configuration for 4 SSD drives
I would like to move a SQL Server database from a shared configuration with the web-server to it's own dedicated box. My current budget will allow me to put 4 disks together in an array with a single ...
0
votes
0answers
8 views
Migrating oracle to sybase using insert into fails due to missing functions
I generated the DDL from oracle to sybase, created the tables with no issues even migrated most tables into sybase using insert into, however when came to the time functions I get errors:
Function ...
2
votes
0answers
37 views
Why does GO affect my SELECT?
I am experiencing a very weird behaviour from the Management Studio GO.
I am following the full-Text Search tutorial and I run the following query over adventure works
SELECT ...
1
vote
0answers
17 views
Relation to original tables or to existing linking table
In my database I have a table with different settings for my app. Each setting is in relation to a guest (table guests) and an event (table events). So basically each guest has specific settings for ...
1
vote
1answer
17 views
Is there any way to Restore a Database from newer version to an Older Version of SQL Server?
I am having a database backup file from SQL SERVER 2012 and i wanted to restore it on SQL SERVER 2008R2 .
If we can’t restore a SQL Server 2012 database to earlier version what is the next best ...
0
votes
0answers
18 views
Data deleted from replicated table
I have two servers (one publisher and other is subscriber). The replication is succesfully running for a long time. I am using transactional replication with updateable subscription.
Couple of days ...
0
votes
1answer
18 views
MySQL cannot create foreign key, errors 1005, 150
I'm trying to add a foreign key to a MySQL InnoDB table, linking a BIGINT with a table within the same database. I'm using MySQL Workbench to do this. It generates a script:
ALTER TABLE ...
0
votes
0answers
13 views
Data Type that automatically stores the DateTime of the last transaction done, SQL Server 2008 [migrated]
I need to add a new column to an existing table, so that whenever a new row is added, or an existing row is edited, this column will be filled with the exact date and time of the transaction. I tried ...
2
votes
1answer
21 views
MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3
I upgraded my installation of MySQL on my Mac OS X 10.8.3 using homebrew
brew install mysql
Everything seemed to go smoothly, but...not really, as it turns out.
I cannot add a new user (neither ...
0
votes
1answer
25 views
Multiple junction tables?
I am working on a system where you have users, and you have Fields of Study or 'fos' for short. Each user can have many fos and each fos can have many users. So we are dealing with a many to many ...
0
votes
1answer
14 views
MySql - set my.cnf location at server start
I want to have two MySql servers running on the same system (for master-slave replication tests purposes).
To be able to do this I need both servers read different my.cnf files.
As I see at startup ...
0
votes
2answers
56 views
How can I increase performance for select in select statement
The item table is like this
id category_id name registered
I have to show total number of items from the beginning. Suppose between 2013-05-01 to 20-05--05, I have to count all the items ...
-5
votes
0answers
21 views
How do I create a database+tablespace+user in Oracle 11gR2? 1
I keep getting database not open error whenever I try committing anything with the user \ as sysdba how do I get started, create a table, create a tablespace and a user?
0
votes
2answers
5 views
Database model: doubly linked list
I am not sure if I get this right. I'm designing a database model for use in an application, and I'm stuck at a doubly linked list (model first; there is no code yet).
There's an order. An order has ...
0
votes
0answers
24 views
MySql Database Design for Bollywood Movies (India) [closed]
I'm trying to get my head round this mind boggling stuff they call Database Design without much success, so I'll try to illustrate my problem with an example.
I am using MySQL and here is my ...
1
vote
0answers
40 views
Database hangs randomly
My database works fine but suddenly it stops responding to queries and I get only timeout errors on my website then after about 10-30 minutues it starts responding again on it's own but queries take ...
1
vote
1answer
22 views
Stopping SQL Server Agent: Effect on runnings jobs
On a server with MS SQL Server 2008 installed, we use the SQL Server Agent to schedule a large amount of SSIS-packages, all with unique schedules throughout the day.
Now and then, the server needs to ...
-2
votes
0answers
65 views
Stored procedure in SQL Server [closed]
I have 3 drop-down list. The 3 drop-down lists maping some values. I have create a new option in the 3 drop-down lists.
I will click new option and displayed text box and enter the value to store it ...
0
votes
0answers
22 views
Find the partition where data lives in MySQL
Is there a way to select the partition name where a specified record actually lives in? The idea is something like:
SELECT <PARTITION_NAME> FROM mytable WHERE <where_condition>
I found ...
0
votes
0answers
22 views
Why does mysql show Primary key constraint on a View?
As far as I know views cannot have a primary key.
However the result of
SELECT FROM KEY_COLUMN_USAGE
says differ.
PRIMARY | S_MOBILE_ITEM_VIEW | ID |
...
0
votes
0answers
15 views
What is the easiest way to convert the Wordnet prolog .pl file into the Mysql table?
is Anyone used to convert the Prolog database format WordNet files into Mysql table?
There is a website http://www.androidtech.com/html/wordnet-mysql-20.php which did the similar thing. However, it ...
1
vote
0answers
18 views
Should xp_logevent and RAISERROR … WITH LOG work on LocalDB?
I need to run a script to configure a LocalDB (v11.0.3000) instance and database (from a .NET 4.5 program) and I want to record results at various stages. Someone suggested xp_logevent but it doesn't ...
0
votes
1answer
6 views
Recover PostgreSQL password with admin access to host
Good day.
I have a PostgreSQL server.
Once i had admin login and password, then i created a new login for web application (with low permissions like select form some tables etc). And i just lost my ...
0
votes
0answers
13 views
I want to change ORACLE level#2 to log archiving mode instead of the current mode
I want to make that change to the archive log mode to use the redo log files to use it to make replication to database to another server.
This is easy and possible when the server is single not ...
2
votes
2answers
21 views
Can stable (or immutable) functions call volatile functions?
The PostgreSQL documentation states:
Any function with side-effects must be labeled VOLATILE...
Consider the following function:
CREATE OR REPLACE FUNCTION count_items()
RETURNS integer AS
...
0
votes
0answers
21 views
How to use Python and XML for distributed DBMS [closed]
I have a project where 3 VMs (say VM1 VM2 and VM3) are given to me. Each with 4 GB ram, and 50 GB space. They have known static IPs.
All 3 VMs are installed with ubuntu 10.04 and MySQL. VM2 and VM3 ...
1
vote
1answer
25 views
How to repair Microsoft.SqlServer.Types assembly
When I run a checkdb('mydb') this is the only error message printed.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3857, State 1: The attribute (clr_name=NULL) is required but is missing for ...
0
votes
1answer
13 views
Unable to connect to Amazon RDS instance
I recently created an oracle instance on Amazon RDS. Unfortunately, I'm not able to connect to the instance using Oracle SQL Developer.
The (relevant) information I have from Amazon;
Endpoint - The ...
1
vote
2answers
35 views
how to change a user password while checking the current password in oracle?
In my application i have a change password form which users enter their current password and the new password. then i change their password using the following command:
alter user user_name ...
2
votes
1answer
17 views
Table optimize command crashed MySQL server
I have a large 5GB table on one of my MySQL databases that I wanted to optimize.
I went into the console and ran the optimize command and since it's an InnoDB database it cloned the table to a ...
0
votes
0answers
9 views
exported .SQL file won't import completely in mySQL
I am running MySQL on an Apple server OS X 10.6 (and am a complete newbie to SQL). I am trying to import a .SQL export file that was generated by an application called MailSteward Pro. The .SQL file ...
0
votes
2answers
27 views
Linked Servers pointing to same server (localhost) causing “Transaction context in use by another session” error
We are using SQL Server 2008. Normally our app that is using different databases distributed over the network and some of the stored procedures we call therefore make use of linked servers.
Now I ...
0
votes
1answer
26 views
Communication between two database servers
I have 2 databases running on different virtual servers. I have some database processes running on one node. These processes connect to Database Gateway (PG4MQ) and process the messages.
I need to ...
0
votes
1answer
31 views
Is it possible to change the MySQL server-id during a SQL session?
I have a MySQL 5.5 server with a server-id of 20. I want to execute a few queries on that server, but have them write to the binlog as a different server-id than 20. Is this possible?
I am aware set ...
0
votes
4answers
43 views
How do I deal with FK constraints when importing data using DTS Import/Export Wizard?
I am trying to use the SQL Server Import and Export Wizard to copy data from my production db to my dev db but when I do it fails with the error "The INSERT statment conflicted with the FOREIGN KEY ...
-4
votes
1answer
38 views
What should be Performance Tuning Approach? [closed]
As a DBA when the client reports a performance slowness issue what should be the Approach in solving the issue.
Meaning that we can not always suspect the Database for performance slowness, many a ...
0
votes
1answer
38 views
Is it possible to force drop of mysql tables with FK?
For dropping a table in which a Foreign Key is used in other tables, it is necessary to drop all other tables having FK connection with the corresponding table.
Is there a short way to drop a table, ...
7
votes
0answers
128 views
More CPU cores vs faster disks
I'm part of a small company so as usual covering a number of different roles. The latest of which is procuring a dedicated SQL Server box for our .NET web app. We've been quoted on a dual Xeon E5-2620 ...
1
vote
1answer
34 views
Setting mysql slow query to less than 1 second
I have a heavily loaded LAMP system serving about 40 requests per second and doing about 300 mysql queries per second. Here is the output of mysqladmin status
Uptime: 5051 Threads: 1 Questions: ...
4
votes
2answers
81 views
When should tables NOT be compressed
We have two servers. One we just compressed, but I took over this little project and this guy says some tables are not good candidates. As with many others, performance is -critical-.
Is it accurate ...
1
vote
1answer
42 views
Combining data from two databases with same structure into one database
I have five SQL Server databases with the same schema in five different geographical locations. These locations send periodic backups to the central server which I restore in the five respective ...
0
votes
2answers
40 views
Migrating a database from SQL Server 2012 to the cloud
I have a sample SQL Server database which is running on my computer. I have a cloud database account on AWS (free account). I want to migrate the database, with all tables, to the cloud.
How can I do ...
1
vote
2answers
32 views
Label data according to percentile
I have a table name temp with column customer_id , sum and I need to add extra column customer_label (may be on view) which is 1 if customer lies in top 10% according to value of sum, 2 if lies within ...
1
vote
0answers
25 views
MySQL Partitioning Performance
I have a MyISAM table with billions of rows that is still causing me problems because the indexes, even after I shortened them as much as possible, do not fit in my 64GB of RAM.
I am unable to index ...
