0
votes
0answers
3 views
New to mySQL Relationships
I'm new to mySQL relastionships and I'm wondering if you can help me out.
This is what I want to do:
Users Table
user_id
user_name
pass_word
permission_id
Permissions Table
p_id
...
0
votes
1answer
11 views
MySQL dynamically optimize innodb tables without “file per table” setting
We are getting a “too many connections” error once a week the same time a mysql procedure runs. The procedure runs “optimize table” on hundreds of tables and takes nearly ten hours to finish, taking ...
3
votes
2answers
39 views
Best high availability solution to avoid maintenance downtime?
We currently only have one production SQL Server 2008 server. Anytime we need to perform maintenance or install patches, it causes downtime as the server reboots. In addition, if the server ever ...
0
votes
0answers
15 views
Having an issue updating the cost field in my db according to the rules of a specific telecoms tariff
Our organization is running an OpenSuSe 11 enviroment with MySQL,
I'm currently trying to take all the calls in our calls table and cost them using the duration multiplied by 0.00504, then from that ...
1
vote
1answer
32 views
Running pt-table-checksum on a table in different databases
I'm using filters for replication:
replicate-wild-do-table = test_slave.%
replicate-rewrite-db = test->test_slave
Is there an option to specify different DB name on slave for "pt-table-checksum"
...
3
votes
0answers
43 views
Can I tell SQL Server to “do something” when a connection is closed?
Can I tell SQL Server to "do something" (e.g. release an application-level lock) when the connection is closed for whatever reason?
Background: I want to lock a record on the application level, not ...
3
votes
0answers
16 views
Full-text search with german umlauts
I created a table using German (Germany) as the Full-text language, in the settings I tried setting accent sensitivity to both sensitive and insensitive. I, however, get following odd results.
The ...
0
votes
0answers
40 views
Query should yield result but doesn't
I need to get data from a remote SQL 2000 server and store it in a new MySQL server. I am using the FreeTSD module for php 5.3 to connect to the SQL 2000 server. I can connect without problems.
...
0
votes
1answer
16 views
Is there an advantage to moving to 'real' date partitions on MySQL 5.5?
We are using partitions per day for some our tables. We started with MySQL 5.1, so we had to partition using the to_days (end_time is a datetime column):
ENGINE=InnoDB DEFAULT CHARSET=utf8 ...
0
votes
0answers
5 views
What are the source tables for report MB52 in ECC?
I need to validate the data that is showing up in the t-code MB52 report. Have searched a lot of SAP documentation but nothing gives me an answer. Here are a couple of things I am trying to find out ...
0
votes
1answer
14 views
Export table with arabic data
I am usin wamp 2.2e
I am trying to export a table having collation utf_general_ci. I have arabic data in mytable but in exported file arabic data is encoded. I can not get it fixed. I am exporting ...
0
votes
0answers
22 views
InnoDB data back in 3 months after OS shutdown
I've got an interesting issue last week that after shutting down an instance of mine, all data were back in 3 months (like a big rollback), even though there is no sign of crashing, recovery crash ...
3
votes
3answers
40 views
Backup not creating a new file
I run a daily backup of my database through command prompt:
c:\sqlcmd -H localhost -Q "BACKUP DATABASE test TO DISK='c:\test.bak'"
But the new backup replaces the previous backup. Please tell me ...
0
votes
0answers
16 views
What Has To Be Considered In Order To Keep A Database Consistent?
I have developed a Winforms application which handles database requests, with the database lying on a local network server. Therefor I used LINQ to SQL.
Now I read about how to use LINQ's support for ...
1
vote
1answer
18 views
Sorting Result state taking very long time
I am using a MySQL 5.1.69-log DB for analysis purpose.
I've designed my database in a star schema. All tables are using InnoDB.
My innodb_buffer_pool_size=2Gb
This is the query I am running :
...
3
votes
0answers
70 views
select top x works, but x+1 runs endlessly
Something happened to a table, that results in an endless executing select and I'm trying to figure out the reason.
What I tried and found out:
This runs endlessly:
select * from dbo.MyTable
As ...
5
votes
2answers
42 views
Permission required to view a database diagram
I have recently set up SSDT for our developers to use. We enforce changes to our dev databases are made through SSDT by limiting the permissions that each developers has when connected to the server ...
1
vote
1answer
37 views
Does SQL Server have a reference partitioning equivalent?
Oracle 11g has introduced a new feature that is called Reference Partition.
Using reference partitioning, a child table can inherit the partitioning characteristics from a parent table.
...
-1
votes
1answer
23 views
performance problem with MySQL database [closed]
i'm working on the second version of a project which used a MySQL database.
i dont have the code of this first version but this version encountered a problem of slowness of about 30 second in queries ...
0
votes
2answers
14 views
MySQL Continue Handler Problems inside a Function
I am in process of writing a simple MySQL function that looks up a value in a table and returns it. In case there is not value found it returns null. However, even with a continue handler defined I ...
1
vote
1answer
21 views
How to run recurring tasks on a Postgresql database without a cron-like tool?
I would like to call a stored procedure on a regular basis. On Oracle, I would create a job for this. I have found that Postgresql can mimic this well by using an external tool (cron etc) and PgAgent.
...
0
votes
0answers
11 views
Table is marked as crashed and should be repaired
I have MySQL and Nagios installed Linux PC (Centos5.5)
I have wrote some script to fetch the data from Nagios to Mysql DB (Exactly fetch data in Table)
The data fetching working properly (confirmed ...
3
votes
1answer
54 views
DBCC SHRINKFILE works with file_id but not with logical name
I am trying to shrink a database file but am running into errors.
Using the file_id from sys.database_files works, but using the logical file name yields an error.
The logical file name is the same ...
0
votes
0answers
9 views
Install Oracle Database 11g Release 2 on Windows 8
I am trying to install Oracle Database 11g Release 2 in my Windows 8 Laptop.
I have downloaded both zip file from Oracle website and unzip both in a common folder as directed.
But when trying to run ...
0
votes
1answer
23 views
Databse Mail sending functionality not working on local system
I am using Database Mail functionality to send mail in Sql Server 2008 database via following sp:
EXEC sp_send_dbmail @profile_name='MyProfile', @recipients='[email protected]', @subject='Test ...
0
votes
0answers
13 views
Data Sharing between Client and Server Two Way [duplicate]
Please solve my query
One of my Silverlight application is running.
This Application is using one central database (sql server 2008) and three other client databases (sql server 2008) at other server ...
2
votes
1answer
21 views
Data sharing between client and server two ways
One of my Silverlight applications is running. This Application is using one central database (SQL-Server 2008) and three other client databases (SQL-Server 2008) in server other locations.
Our ...
0
votes
0answers
9 views
Getting 'error establishing database connection' with Wordpress and MySQL
I have an Amazon EC2 server with MySQL running, supporting databases for
Three copies of WordPress
One copy of Sendy
Various odds and ends I have been experimenting with.
After some time, ranging ...
0
votes
1answer
18 views
In the Vertica database, what is a namespace?
In the Vertica database, what does the term "namespace" mean?
I have reviewed the entire Vertica documentation and cannot find what this means.
1
vote
1answer
10 views
Why does `pg_lsclusters` not list my Postgres cluster?
I apt-get installed Postgres 9.2.4 (using PPA).
I used pg_dropcluster --stop 9.2 main to remove the default database cluster, because I intended on creating a new cluster on a separate SSD volume (a ...
1
vote
1answer
45 views
Need to replace only first occurrence of string
I hope I worded the question right. Here are the specifics:
This is regarding a MySQL database. I've inherited several hundred posts with custom fields and a unique excerpt. At this point I think I ...
0
votes
0answers
13 views
SQL Server 2012 linked server to SQL Server 2000
I am trying to select through an linked server from SQL Server 2012 to SQL Server 2000.
The linked server has been setup and I can browser the target database through the linked server which ...
0
votes
1answer
20 views
Keeping version history of functions in PostgreSQL
For many of my tables, I've added auditing triggers (based on this wiki page). It works very well and has helped me several times figure out who changed what in the system. We have a Python/Django ...
2
votes
0answers
34 views
Insert into table from a query to a linked database hangs
I have a schema with some database links to other schemas that we use to pull data from. We pull the data into a staging table, massage it, and then do some merges into our schema/database.
The data ...
2
votes
2answers
49 views
Reset IDENTITY value
I have a table with an IDENTITY column. While developing I delete the rows from time to time and add them again. But the IDENTITY values always kept increasing and didn't start from 1 when I added ...
0
votes
0answers
18 views
What are some good packages to install before configuring postgres on Ubuntu?
I can find a hundred examples of compiling Postgres 9.2 from source. None of them make mention of any options to pass to ./configure that are a good idea to always include. The only packages I have to ...
0
votes
0answers
10 views
Having trouble connecting tungsten replicator from EC2 to RDS
I am testing using Tungsten Replicator to help migrate large databases to RDS. I have no trouble setting up the service on the EC2 "master". I am using a second EC2 instance as a kind of relay server ...
1
vote
1answer
16 views
In creating view use SQL Security definer or invoker?
CREATE VIEW syntax is
CREATE
[OR REPLACE]
[ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
[DEFINER = { user | CURRENT_USER }]
[SQL SECURITY { DEFINER | INVOKER }]
VIEW view_name ...
0
votes
0answers
18 views
SQL Server 2008 log file growing and wont shrink. Hard Drive Space running out [duplicate]
I have a SQL Server 2008 database which has a log file (.ldf) with a size of 360GB and growing every day.
The .mdf file is only 25GB. The hard drive is 950 GB and has 150GB free space. I want to ...
0
votes
2answers
30 views
Too Many database connections on Amazon RDS
We are having problems with users running queries/views in Drupal that occasionally cause our site to freeze. The freeze occurs because the query causes the number of database connections to go up to ...
0
votes
1answer
43 views
Relational database primary key requirements
I am trying to put together an ER Diagram to design a fairly simple asset tag tracking/inventory management system for our servers/switches/UPS/etc. The top-level entity corresponds to the business ...
0
votes
1answer
26 views
mysql replication goes out of sync for some tables
We are running mysql 5.1.61 on redhat systems and have the following setup
One master and four slaves replicating from the master, we recently added a new slave for replication and over a few days we ...
2
votes
1answer
26 views
SQL Server Many-to-One replication
I have 8 individual SQL Server 2008 R2 machines, each hosting 1 database. Each database has an identical table structure and schema, and entirely unique data.
I would like to establish a reporting ...
1
vote
0answers
15 views
rman 'delete archivelog all’ very slow
On our automated test system we use flashback all the time to reset our Oracle 11g database to a state before a testrun. We noticed some of the scripts involved started to become slower and slower. In ...
0
votes
0answers
9 views
IIS difference: Remove and Deploy -> Delete Site and Content [migrated]
One can remove a site from IIS by the right mouse menu.
However this gives you two options:
"Remove"
"Deploy -> Delete Web Site and Content"
What is the difference?
5
votes
5answers
241 views
Find procedures that haven't been called in <n> days
We are deleting old stored procedures and tables.
How can I know what procedures haven't been called recently?
dm_exec_procedure_stats and dm_exec_query_stats aren't reliable, since they only return ...
2
votes
0answers
12 views
Cannot Delete FileStream Group from Sql Server 2008
We have migrated all our varbinary(max) column data to Azure Blob Storage and so we want to remove the old filestream columns that remain in our Sql 2008 database and the filestream filegroup but when ...
0
votes
1answer
60 views
Move database files if database runs
is possible, is there internal procedure to moving with database files if database runs, is not detached on Sql Server 2012/2008, .... EDIT.... database is online, accesible for users, services ...
-1
votes
0answers
35 views
Optimize SQL Select Command [closed]
Is there anyway to speed this up by optimizing/condensing the code?
SELECT fullName, email_address, pos_desc, EXT
FROM dbo.BTC_WEB_EMPLOYEE_VIEW
WHERE grp_cde = 'STAFF'
OR grp_cde = 'PROF'
OR ...
2
votes
1answer
36 views
Force View's query plan to update?
I have a View whose query plan appears to be cached, is there a way to force the View's plan to be recalculated on each access?
