All Questions
0
votes
0answers
11 views
How can I get my linked server working using Windows authentication?
I'm trying to get a linked server to ServerA created on another server, ServerB using "Be made using the login's current security context" in a domain environment. I read that I'd need to have SPNs ...
0
votes
0answers
18 views
MySQL multiple rows with same id meeting two different conditions at same time
I am using OTRS helpdesk ticket management system. When i execute following Query:
SELECT `ticket`.`id`,
`ticket_history`.`ticket_id`,
`ticket_history`.`id`,
`ticket_history`.`name`,
...
3
votes
2answers
33 views
What can I add to a server to make SQL restores faster?
I have a 2.8TB SQL database (mostly data files, some 400GB of log files) that currently takes around 9 hours to restore. This database is used for testing purposes and must be deleted and restored ...
-1
votes
2answers
41 views
How to write a query to find all tables in a db that have a specific column name
I've got a database with about 100 tables and I need to build a join query to get specific data from two of them. I know one but not the other. Basically I need something like:
select ...
8
votes
3answers
110 views
Trying to find the last time that a value has changed
I have a table that has an ID, a value, and a date. There are many IDs, Values, and dates in this table.
Records are inserted into this table periodically. The ID will always stay the same but ...
0
votes
1answer
26 views
Create primary keys based upon higher-level entity in access?
Is it possible to have access create primary keys for items by appending a string to the primary key one level above it?
I am trying to create an inventory management database for my company's server ...
0
votes
0answers
8 views
Cannot run pgAdmin from the terminal: No such file libwx_gtk2u
(Probably irrelevant) I'm using Puppet to setup/manage a class of computers that are equipped with PostgreSQL and PostGIS, and this implies that each computer goes through an unattended install:
...
0
votes
1answer
10 views
pgAdmin to display multiple result sets
With MS SQL Query Browser I can run multiple queries at the same time and each result set will display in it's own window.
Does PostgreSQL/pgAdmin have this functionality? Plugin perhaps?
1
vote
0answers
32 views
How do I maintain more audit history?
I created a SQL Server audit and when I view the audit logs I only see today’s audit. I am saving it to a file and I want to store audit for one year. Is there a way to store database and server audit ...
1
vote
0answers
23 views
DBCC SHOWCONTIG has results dm_db_index_physical_stats does not
Ok, reading Paul Randal's inside write-up of sys.dm_db_index_phsical_stats, the guy that wrote the DBCC SHOWCONTIG command, he states that using LIMITED with the DMV is equivalent of using WITH FAST ...
0
votes
1answer
11 views
Query mail logs for xp_sendmail
Using SQL Server 2008, I can query sysmail_log and other tables to see the results of sql emails.
Is anything remotely similar available for querying email logs in SQL Server 2000?
0
votes
1answer
19 views
CSV File Into MYSQL Merging - LOAD DATA on Duplicate Key?
Hey Dba Stack Exchange,
My question to you is with regards to mysql. Right now I have a medium to small sized csv with 25k lines I need imported into mysql for a client. Problem is, their is only ...
3
votes
1answer
52 views
Central stored procedure to execute in calling database context
I am working on a customized maintenance solution using the sys.dm_db_index_physical_stats view. I currently have it being referenced from a stored procedure. Now when that stored procedure runs on ...
2
votes
0answers
36 views
How to take partitions or filegroups out of service
I'm an experienced SQL Server DBA but new to partitioning, and I have a couple of questions. Using SQL Server 2008 R2 Enterprise Edition.
I've inherited a large customer metrics database that grows ...
1
vote
1answer
15 views
How to change a column type from SET to an ENUM
I have a table with a SET column type that need to be changed to ENUM type.
Can I do it with a simple ALTER or will this mess up my data?
NB: there are no multiple values (a,b,c) in the table.
0
votes
0answers
25 views
How to add column/alter structure to big table in MySQL [duplicate]
'm php developer so dont be strict. I have a big table ~5.5gb dump. Our PM decided to make new column in it to perform new feature. Table is InnoDB So what i tried:
Alter table in screen with table ...
0
votes
2answers
12 views
How to add column to big table in MySQL
I'm php developer so dont be strict. I have a big table ~5.5gb dump. Our PM decided to make new column in it to perform new feature. Table is InnoDB So what i tried:
Alter table in screen with table ...
0
votes
1answer
24 views
Create a trigger to update table data on another Server's database
I am creating a trigger in MySQL and I need a little help.
I have 2 websites, 2 databases (same name) on 2 different web servers, S1 & S2.
These databases have the same tables names.
I want ...
6
votes
1answer
111 views
How to make trigger code execute only for a specific application?
I was wondering if it is possible to enable a trigger just for my current application and not for any sql executed against the table.
The situation:
There are two applications working on the same ...
0
votes
0answers
11 views
MongoDB fast upsert
For non-incremental, but overlapping, imports, I worry about upserts to be very slow and locking the resources for hours.
From different sources, I receive 1 json dump per day per source for up to 3 ...
0
votes
1answer
17 views
How big can innodb_doublewrite_file grow?
When I use the enable innodb_doublewrite_file ...
How big can this file grow ?
How can I calculate the optimal disk size, if it would be used only for this file?
2
votes
2answers
26 views
How to change “tmpdir” on a running MySQL instance
Is there a way to change the tmpdir on a MySQL server without restarting it?
The issue is that I use a tmpfs mounted at /var/lib/mysqltmp but sometimes it's overflowing and causes issues. I don't want ...
1
vote
0answers
10 views
How to take partitions or filegroups out of service [migration] [duplicate]
I'm an experienced SQL Server DBA but new to partitioning, and a had a couple of questions. Using SQL Server 2008 R2 Enterprise Edition.
I've inherited a large customer metrics database that grows by ...
-1
votes
0answers
23 views
MongoDB Schema for Users and Admin
I'm new to schema design in MongoDB.
The web app allow users to create their account and login with their email address and password.
Also, there is an admin dashboard of the web app which can be ...
-1
votes
1answer
24 views
trigger is not working properly [closed]
I have create trigger for some condition but its through error.
Here is trigger code.
DELIMITER //
CREATE TRIGGER `getcrm`.`update_round_date` AFTER UPDATE ON `getcrm`.`vtiger_stockcheckcf`
FOR ...
1
vote
2answers
40 views
Which MySQL engine should i use where most operations are read operations
I want to develop an application for which i will need a database to store data. I am using MySQL as backend. My question is Which MySQL engine should i use?
Well, i have mentioned some important ...
0
votes
0answers
16 views
Advice on NoSQL (Google App Engine NDB) Schema?
Some background: I am very much a novice at anything database related, my knowledge caps at creating a very basic blog with MySQL. I am currently switching from PHP/MySQL to Python and as of now I am ...
0
votes
1answer
21 views
Need some good tutorial regarding Rman,datagaurd,rac and performance tuning [closed]
As i am very new in oracle database, i need some good tutorial,configuration file,book for ASM,omf(oracle managed file),data guard,Rac,troubleshhoting & performance tuning.Thanks.
1
vote
1answer
19 views
To select from all tables inside the schema in PostgreSQL
Is it possible to select from all tables inside the schema?
I got all the table names from
select table_name from information_schema.tables
but I am unable to use it to do my query.
0
votes
1answer
30 views
Error while opening Oracle 11g Database
I have a problem with oracle 11g database,
I have shutdown my computer this morning normally, but in the evening when I tried to connect to my database I fond a problem. I cannot connect as normal ...
0
votes
1answer
42 views
What are the basic job functions required of a remote DBA for Oracle and SQL Server? [closed]
When looking for a remote DBA to manage and support your database infrastructure what are the basic job functions that should be expected?
On the flip side what would be considered out side the core ...
0
votes
1answer
31 views
Hazards of Upgrading SQL Server Express 2008 to R2
A client of mine reached the 4GB database limit on a SQL Server 2008 Express.
As a test I installed the R2 version on another machine and restored a backup of the database.
I'd like to upgrade the ...
0
votes
2answers
21 views
Error while restoring a Database from an SQL dump
I am extremely new to MySQL and am running it on Windows. I am trying to restore a Database from a dumpfile in MySQL, but I get the following error:
$ >mysql -u root -p -h localhost -D database ...
0
votes
1answer
13 views
Is it possible for heroku postgres follower database to follow non-heroku postgres master?
I am considering to move our site's database from our dedicated db server to heroku postgres. as we have a few gigs of data in the db and don't want to take it down for a long migration downtime it ...
2
votes
3answers
30 views
SSIS Rollback Package
I have several data flow tasks in my package that depend on other data flow tasks. For testing reasons I want to run the entire package and then roll it back after it completes. How do I do it?
4
votes
1answer
87 views
Does Detach/Attach or Offline/Online Clear the Buffer Cache for a Particular Database?
A buddy of mine told me today that instead of bouncing SQL Server, I could simply detach and then re-attach a database and this action would clear the given database's pages and plans from cache. I ...
2
votes
1answer
25 views
MySQL, optimize and replication
I have two MySQL (MariaDB actually) servers, a master and a slave with standard replication.
Two times already in less than a month I've had my slave become unusable.
This is what I experienced:
...
1
vote
1answer
17 views
MyISAM key buffer
Good evening,
I want to know how can I use informations about MyISAM to calculate :
size of buffer,
size of buffer used,
Write ratio,
Read ratio,
and MyISAM key cache hit rate
and thank you.
1
vote
1answer
17 views
Optimizing disk space for MyISAM tables: what is the benefit of ALTER and ANALYZE if you already do OPTIMIZE?
Per this post, in order to optimize the storage of a MyISAM table, you need to:
OPTIMIZE TABLE ;
ALTER TABLE ENGINE=MyISAM ;
ANALYZE TABLE ;
It's obvious what OPTIMIZE does for disk space but what ...
0
votes
1answer
27 views
Configure SQL Server Database for High Availability & Warehousing
I have 3 DB servers (DB1, DB2 & DB3 - all on Win 2008 R2 with SQL Standard 2008 R2 in the same datacenter). Let's assume AdventureWorks as an example database.
My goal:
- Setup DB mirroring with ...
-2
votes
1answer
45 views
Select query using a map [closed]
CREATE TABLE grid_rows(
[row_id] [int] NOT NULL,
[column_id] [smallint] NOT NULL,
[column_val] [decimal](18, 6) NULL
)
// (row_id, column_id) is a composite primary query
For a given ...
1
vote
1answer
21 views
Can I remove #sql_ .MYD files?
I found some old files in the mysql datadir:
-rw-rw---- 1 mysql mysql 0 2012-10-09 09:39 #sql_263c_0.MYD
-rw-rw---- 1 mysql mysql 1.0K 2012-10-09 09:39 #sql_263c_0.MYI
-rw-rw---- 1 mysql ...
0
votes
1answer
19 views
Is there a system wide way to change MariaDB to create tables using ROW_FORMAT = DYNAMIC
I've got a 700MB dump file from a mysql database that I was trying to undump into a new install of MariaDB and I got this error
ERROR 1118 (42000) at line 7481: Row size too large (> 8126). ...
6
votes
1answer
44 views
Index usage stats DMV indicates no index activity
I'm trying to obtain information on indexes. According to several websites, the below TSQL query should join information on indexes to the indexes table, returning indexes and related information. ...
0
votes
0answers
25 views
Mview replication
We are setting up a large scale replicated environment and would like to know if there is a way to skip certain dml for eg. deletes during data trasfer with simple mview replication. Also, is it ...
0
votes
2answers
27 views
How to set password for PostgreSQL database with a script?
In a bash script I'm writing, I need to create a database and set a password that is generated automatically by my script.
The problem is I can't find a way to set up the password without user ...
0
votes
0answers
23 views
Federate engine to help overcome distributed transaction?
Currently we have been using pure innodb. The issue is that we have architecture where we have multiple outlet each have its own local db and a copy of it in the hq outlet. The issue is that we ...
0
votes
1answer
53 views
How to create a table in MySQL with automatic numeration of columns?
Example. My data is from Table name:BIKE
Bike_No Repair_Date Repair_Cost
-------- ----------- ------------
ABC1234 2013-01-05 50.00
BMX5678 2013-02-04 75.00
ABC1234 ...
2
votes
3answers
59 views
Database design for conditional detail table
I have an expense management system for monthly expenses. Expenses are of two types: one-time monthly expenses, and daily expenses for each day of month. I have created the following tables:
...
1
vote
3answers
24 views
About changing data path by database
Is there any way to change physical path by database?
For example :
I have 2 databases in server.
database1 will be located in /data/database1/
database2 will be located in /data/database2/
Is ...
