All Questions
0
votes
0answers
4 views
Rearranging the output of mysql query
When i run the following Query:
SELECT ticket.id, th.ticket_id , th.id, th.name, th.create_time
FROM ticket_history th
JOIN ticket ON th.ticket_id = ticket.id
WHERE (
th.name LIKE ...
0
votes
0answers
6 views
PstgreSQL 9.1.4 will not install service scripts
Same setup as before, but with a different install command.
PostgreSQL refuses to install its service scripts into /etc/init.d/; in fact, I can't find them anywhere (find / -regex ".*postgres.*")
...
1
vote
1answer
20 views
Is it ok to let users add new columns and tables to your database?
I'm basically making a database of databases. An administrative User can go in and hit "Create Database" (which is basically a table) and set up the column types and how many columns. Other users can ...
1
vote
1answer
27 views
How to select specific rows if a column exists or all rows if a column doesn't
I'm writing a script that gets a count of rows for a few tables, however for some tables I want to only get a count of rows where a flag is set (in this case active=1). Is there a way I can do this ...
0
votes
1answer
11 views
Create spfile from pfile
I'm having a problem in creating spfile from pfile.I think I don't have permission to write on Oracle Home. I'm using Windows 8
SQL> startup nomount pfile='initlittle2.ora.txt';
ORACLE instance ...
0
votes
2answers
22 views
Syncronization with transformation
I have the following scenario: a database in SQL Server 2012 that must replicate changes in a transactional way to a SQL Server 2000 database. Since the schemas of two databases differ, a ...
0
votes
0answers
14 views
Creating schema for a shop that sells items from multiple tables
I am trying to create a table in mySQl that contains a list of all the items that a shops. For example:
shops (shop_ID (PK), shop_name)
shops_and_items (shop_ID (PK), item_ID (PK), price)
The issue ...
0
votes
0answers
13 views
Calculating the row size of a table [duplicate]
Is there a way to calculate the row size (in bytes) of a particular table in postgresql / pgadmin3?
0
votes
0answers
30 views
Windows Server failover cluster [closed]
I have 5pcs. IBM System x3650(7979 - ex. ESX/VMWare, planned EOL) now with baremetal Win2012 DataCenter, every machine has the same HW and SW (inc policy).
I want to create two clusters (MS SQL), for ...
-1
votes
0answers
23 views
How much time is considered 'Ideal' for a SELECT query? [closed]
This is my first experience in developing for the masses, and I wanna know how much time is considered ideal for running a select query and returning the data to the client?
I've seen simple queries ...
-3
votes
1answer
26 views
Querying Change Data Capture data
I have Change Data Capture enabled and working fine. The question that I have is how do I query the data to show users what changes occurred.
1
vote
2answers
15 views
Help wrapping my mind around many-to-many relationships
I'm making a database that needs to have the following tables: Article, Video, Image, and Keyword. Keyword contains a fixed list of keywords. (For example when creating an article, you'd have to ...
0
votes
1answer
20 views
Give access to view or table?
I want to give an external user (new login) read access to part of the data model from my Database. The user will copy the data model and content from my Database, and then integrate that into their ...
0
votes
0answers
7 views
Using PL/R for clustering geometries
I have a Postgres/PostGIS database of geography points which I'm trying to cluster; meaning I want to group and count them by proximity. I have had first success with the kmeans Postgresql extension, ...
2
votes
2answers
15 views
Issue importing large file into SQL server
I am trying to import a 4gb csv file into a new table in sql server using the wizard. And when I do I get the errors below. I also included the 2nd row of the file I am trying to import without the ...
2
votes
1answer
12 views
NEWB Getting to KNow New Database and Understand Where Relationships Are
I'm teaching myself SQL using MYSQL and a textbook.
While working through the textbook I'm using a database I'm kinda familiar with - an exported copy of my CMS driven websites database.
My website ...
1
vote
1answer
23 views
Databases outside of AlwaysOn availability group stuck in RESTORING status
I am testing the AlwaysOn feature of SQL Server 2012. I have 2 servers set up and can successfully create availability groups and fail them over between servers. However, any databases that DO NOT ...
0
votes
0answers
13 views
Difficulties in createing a PostgreSQL Database
I am a very beginner with Data Base programming and I am trying to create a new postgreSQL database. I use Ubuntu 12.10 and I am having some trouble creating a local DB.
First I use the if address I ...
0
votes
1answer
11 views
The InnoDB log sequence number is in the future
Our site was getting intermittent database errors and I asked my webhost to check what's happening. After some inspection they found that the database has few issues and tried repairing it. Finally I ...
0
votes
0answers
7 views
Missing reference in elasticsearch
After a server restart, my elasticsearch indices aren't working properly. If do I search of data before the system start, everything works just fine. If I insert new data, not a problem. If I search ...
0
votes
0answers
6 views
What is wrong with table_cache hit rate?
In my.cnf I have:
table_cache = 524288
open_files_limit = 65535
Both are at max allowed value for mysql config. Both are less than max open file limit:
# cat ...
4
votes
3answers
144 views
Get transactions that failed or were never committed
Is there anywhere I can look to find failed transactions in SQL server 2012?
4
votes
1answer
73 views
What is the difference between these two index declarations and do I need both?
I was examining a script with 'Display Estimated Execution Plan' and it made several recommendations for indexes to add to the database. I added them and the script did indeed run much faster. Now ...
0
votes
0answers
10 views
Creating and tuning a materialized view in oracle for use by Cognos BI
I am currently in the middle of a Cognos BI implementation and am having difficulty in tuning a view in order for SQL Server to select its contents for fulfilling the incremental load in a timely ...
0
votes
1answer
19 views
SQL Server to Oracle export using Microsoft OLEDB Provider for Oracle
I am trying to Export Data from SQL Server to Oracle using the "Microsoft OLEDB Provider for Oracle".
I am using "Export Data..." option from Task menu.
I get to connect to the source database (SQL ...
0
votes
0answers
17 views
Query take a long time! Is that server issue?
When Query runs on Server (shared-server) it takes (2.5332 sec)
But when I run the same Query on another Server (dedicated-server), it takes only (0.0205 sec).
I don't know where is the issue! Is ...
0
votes
0answers
15 views
Connecting to Oracle from SSIS using ODBC
I am using SSIS to pull data from Oracle DataSource. In the Connection when I chose the Oracle provider and gave the necessary inputs I got error saying "Oracle client and networking components were ...
1
vote
2answers
20 views
Why are there different levels of MySQL collation/charsets?
Looking at the MySQL server variables the server and database collation are set to latin1_swedish_ci but the collaction_connection is utf8_general_ci. Additionally, the collation/charset is set at ...
0
votes
0answers
14 views
Hotel Review System - MongoDB Schema Design
I'm going to develop simple hotel review system. I'll be using MongoDB and I'm new to it and I'm from SQL. Kindly criticize/comment/feedback on the initial Schema design I have.
Users
{
_id: ...
0
votes
2answers
25 views
How to use GROUP BY after the Having clause Mysql
Here is the query which gets the accounts for a specific user the products are related to accounts in one-to-many relation so for each product there are four permissions
All the accounts which is not ...
0
votes
2answers
51 views
Which is better: more rows or more columns in a student attendance table?
I want to create an attendance table for student attendance. Which structure should I go for?
I have two options.
attendance(student_id,date,is_absent,reason)
...
3
votes
1answer
49 views
Deploying database changes in high availability environment
We are currently looking at our deploy process, which consists of an application tier and data tier for a web solution.
We'd like to develop a deployment strategy that does not require downtime for ...
1
vote
0answers
12 views
Postgres ODBC driver versions
On the Postgres ODBC driver page the name for each file is of the form:
psqlodbc_09_01_0100-x64.zip
psqlodbc_09_01_0100.zip
psqlodbc_09_01_0100-1.zip
psqlodbc_09_01_0200-x64.zip
...
1
vote
1answer
25 views
Do I need to use -f to fix insufficient max server memory settings?
SQL Server Version:
SELECT @@VERSION;
/*
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Developer Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)
*/
Issue:
So, I was playing ...
0
votes
2answers
31 views
Commands like CREATE, GRANT, DROP always return “0 rows affected”
I was considering why some special commands in mysql like create user, grant privileges, drop user when correct passed return "0 rows affected", which is not true! (rows in mysql db are affected ...
1
vote
0answers
21 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
1answer
27 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`,
...
6
votes
2answers
79 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 ...
-2
votes
3answers
68 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 ...
12
votes
6answers
323 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
35 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
15 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:
...
1
vote
1answer
20 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
43 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 ...
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
0answers
31 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 ...
1
vote
3answers
47 views
Nonclustered index is faster than clustered index?
Both tables have same structure and 19972 rows in each table.
for practicing indexing, i created both tables having same structure and created
clustered index on persontb(BusinessEntityID)
and
...
3
votes
1answer
62 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
39 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
20 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.
