0
votes
1answer
205 views

Is there a way to truncate the microseconds of a CSV value when importing data using LOAD DATA INFILE?

I'm loading data using LOAD DATA INFILE in 5.5 where the value includes microseconds. I must use DATETIME data type. Currently, I'm using regular expressions to remove them from the CSV prior to ...
0
votes
2answers
142 views

Buffer pool above 90% utilized causes MySQL to crash

Without getting deep into the architecture and setup, is it common behavior for MySQL to act in this manner? EDIT I'm using Rolando's script to identify how full the innodb_buffer_pool is. SELECT ...
-1
votes
1answer
91 views

Show all categories from CATEGORIES table [closed]

I have these two tables, categories and files And I have this query that shows only one result/row. SELECT `categories`.`category_id`, `categories`.`timestamp`,`categories`.`name`, ...
1
vote
1answer
416 views

Is it possible to do flashback after truncate?

Is there any possibility of doing flashback after truncate ? Thank you in advance.
1
vote
1answer
77 views

Oracle optional select value

I'm writing query to select students with their Program, Country and Teacher. So far, I have the following query: SELECT H.STUDENT_CODE, H.FIRSTNAME, H.LASTNAME, H.PROGRAM, ...
2
votes
1answer
3k views

Using OPENQUERY to execute a script

I have a SQL Server 2008 instance which I want to use to import data from an Oracle server. I have set up a linked server that works correctly when running simple queries like SELECT * FROM table. ...
0
votes
1answer
3k views

Airline reservation system [closed]

I'm making a simple airline reservation system. But I'm not sure about the design decisions I made. Concretely, I'm trying to implement following constraints: each Aircraft can have one or more ...
1
vote
1answer
233 views

How can I set block size on Oracle 11 when creating a database instance

Is there any way to configure Oracle 11g's default block size on installation? I have tried Oracle 11g r2 and r3, during both installations block size is 8k and it is disabled (and can not be ...
2
votes
0answers
827 views

“Host has low open file limits” error in MMS

I am running Standalone MongoDB (v 2.6.0 64-bit) host on Centos (v 6.5). Centos is guest OS on Windows 7 host running under VirtualBox (4.3.10). MongoDB process runs under root account. And it is ...
1
vote
0answers
139 views

Cold backup database, what files to copy, slow shutdown?

After a broken server installation I am going to backup a mysql database with a cold backup. This is, because I am not able to dump the sql tables and somehow everything is broken. My questions are at ...
0
votes
1answer
58 views

PHYSICAL_READ_BYTES_DELTA and PHYSICAL_READ_BYTES_TOTAL

What is the difference between PHYSICAL_READ_BYTES_DELTA column and PHYSICAL_READ_BYTES_TOTAL column in DBA_HIST_SQLSTAT table? Are they correlate? Please provide also an example.
0
votes
1answer
137 views

is this database structure correct?

I need some help with a new database structure because I want to make it right. Later in the app you should be able to create users, events and groups. When you create a group you can add members ...
1
vote
1answer
1k views

how to count null and not null values of same column from Mysql

how to count and retrieve null and not null on same column from Mysql mytable ----------------------------------------------- id | name | visited | registDate | ...
0
votes
0answers
120 views

SQL Server 2008R2 Developer's Edition Error while Installing

I had Sql Server 2008R2 Developer's Edition Installed on my machine, Two Named instances, Default Instance was Sql Server Express. and there was another named Instance Evaluation Enterprise Edition. ...
3
votes
1answer
523 views

MySQL queries are 10 to 100 times slower after OS reboot

I have a MySQL server running on Ubuntu. If I restart the MySQL, everything is fine. If I however restart the OS, my queries take anywhere from 10 times to 100 times as long. The only "solution" to ...
2
votes
1answer
48 views

Is MySQL secured?

When I go to directory of MySQL C:\ProgramData\MySQL\MySQL Server 5.1\data all database can see as folder. When I go into those folders I can see 3 file under one table. When I see those one by one ...
3
votes
4answers
8k views

TSQL command to delete backup files older than N hours

Can anyone please help me with a TSQL commmand to delete backup files older than N hours?
1
vote
1answer
516 views

Optimizing GROUP BY Query

I'm running the following query: SELECT `type`, MAX(`time`) AS `last_updated` FROM `stocks` GROUP BY `type` On the following table: CREATE TABLE `stocks` ( `id` int(11) NOT NULL AUTO_INCREMENT, ...
1
vote
0answers
2k views

Management Studio Generate Script Errors

I am trying to generate a script (right click database, tasks, generate scripts, tables) from SQL Server Management Studio 2008 R2 Express and I keep getting an error. I read somewhere that it could ...
0
votes
1answer
679 views

Getting an error in MySQL Workbench: Cannot Open Administrator

I'm using local installation of MySQL CE on Windows 7 64-bit. Tried to use Administrator part for the first time. Here's the error I'm getting: I also see the following in the log: <object ...
0
votes
2answers
303 views

New database server hardware and software inserts slower than old setup

We are upgrading our database hardware and software. The previous server is about 5 years old and is running SQL Server 2005 while the new one is SQL Server 2012. Every hardware component is faster in ...
2
votes
0answers
437 views

Powershell Get-Counter not returning values for SQL counters

I am attempting to use PowerShell to get some SQL counters but it doesn't seem to return the SQL specific counters anymore. I am not sure what could have changed on my server that would have caused ...
4
votes
2answers
65 views

Determining the tables and impact of a large number of SPs

I'm trying to track down what is causing some response times to increase when data is compressed by page compression, when the system is not CPU bound and 95% of responses see a decrease in response ...
12
votes
1answer
345 views

How deterministic is execution plan creation in SQL Server?

Given the following constants: The same database with the same structure (tables, indexes, etc) The same data The same SQL Server and hardware configuration The same statistics The same SET options ...
0
votes
1answer
45 views

How should I entitle date columns? [duplicate]

Is there any convenience in name date-time related columns? created and delivered, … or createdTS, deliveredTS or createdAt, deliveredAt or…
5
votes
1answer
192 views

Why does the CBO not chose a lower cost skip scan without stats?

In the script below, the CBO chooses an INDEX FAST FULL SCAN over an INDEX SKIP SCAN (this is illustrated by the queries with the UNION ALL but you can demonstrate it is true with just explain plan ...
0
votes
2answers
736 views

Read massive flat file into relational database

I have a massive flat text file with ~4M records that I would like to read into MySQL using Ruby/Rails, Python, or any other method. The flat file is roughly this format: ...
4
votes
3answers
8k views

How to find out the content differences between 2 SQL tables and produce sync SQL

How do I find out the differences in data between the two tables that have exact schema, and how to produce synchronisation SQL to get the union results (without duplicates) ? These are the 2 ...
1
vote
1answer
334 views

Converting multiple SQL implicit joins into explicit joins

I am trying to convert several queries that use implicit joins into explicit joins, as per the standard ANSI/ISO Entry SQL-92 [1]. But after a lot of googling I could not find any examples or guides ...
3
votes
3answers
1k views

“Deploy Database to SQL Azure” Task missing

I recently installed SQL Server 2014 Express on a workstation I have and am trying to deploy to SQL Azure. I've done this before on a previous workstation using SQL Server 2012 Express by doing the ...
0
votes
1answer
45 views

Oracle Recovery

Oracle server died. Built a new VM and mapped out the volumes to the SAN. Installed the same version of Oracle on the new server and applied the same patches. How can I "register" or "attached" the ...
5
votes
1answer
289 views

SQL Server: TSQL or safe steps needed: Change collation en masse for group of tables

Looking for a safe TSQL (preferred) or safe steps (rather automated if possible) to change collation on dozens of tables in one throw. Background: We have a db, SQL Server 2005, with ~100 tables. ...
3
votes
1answer
1k views

CREATE DATABASE permission denied for sysadmin

I'm attempting to create a stored procedure that can be used as a proxy for creating databases where users do not have rights for creating databases. See Restricting Database Access/Functions to User ...
5
votes
2answers
449 views

How to create a secondary read-only reporting database with < 15 minute latency

We have a 2012 standard edition instance that is doing log-shipping of 2 related databases every 15 minutes to a secondary 2012 standard edition instance for DR purposes. Although it provides ...
5
votes
1answer
467 views

What is the correct way to ensure unique entries in a temporal database design?

I'm having trouble with the design of a temporal database. I need to know how to make sure I have only one active record for any given timeframe for a store. I have read this answer, but I'm afraid I ...
1
vote
2answers
157 views

Is my ERD valid for airports,cities and airlines database?

My objective is to make a database of airports, cities and the airlines which provide coverage to them. I asked the question before on stackoverflow and the person told me to break up the ...
1
vote
1answer
210 views

database design for dynamic menu bar [closed]

I am trying to create a menu bar which will load dynamically on user log in, based on the user roles. Say if the user is an admin he can see all the items listed under the header and if a user is a ...
2
votes
2answers
222 views

Restricting Database Access/Functions to User Groups?

We've been having issues with Databases being DROPed or RESTOREd WITH REPLACE with the incorrect backup etc... I'm developing a plan right now on how to restrict access and I have some questions. ...
0
votes
0answers
272 views

Archive log backup error and backup completed with errors

My prod DB backup completed with errors stating the below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ...
0
votes
0answers
197 views

Login failed for a user in a Domain Local Group

I have recently been considering moving from using SQL Logins in my applications, to a model using Windows Authentication using Active Directory groups My intention is to allow users access to ...
1
vote
0answers
217 views

pgpool stability issues

I am using pgpool-II 3.3.1 to load balance connections to my postgres 9.3. I am experiencing an ocassional stability issue where clients are not able to connect to pgpool (but they are able to connect ...
0
votes
1answer
35 views

Does database require block storage always?

I was reading the difference between block, file and object storage and I read somewhere that database require the underlying storage to be block storage. Is this true? Can I not install a database on ...
6
votes
3answers
385 views

What are some important security-related error codes / events to monitor?

I am setting up alerts in SQL Server and am interested in what events I should be raising alerts for. In particular, I am looking for any events related to security. I am already monitoring error ...
1
vote
1answer
52 views

How to read queries of master that sends to slaves?

I want to see queries that Master sends to slaves in Mysql ? Is there a way to see that ?
0
votes
0answers
23 views

Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor ) [duplicate]

I have already seen the questioned in the stack overflow that might relate to my problem but let me emphasize that none of them could resolve my issue. issue is: when I wanted to integrate OWASP ...
1
vote
1answer
11k views

Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor )

I have already seen the questioned in the stack overflow that might relate to my problem but let me emphasize that none of them could resolve my issue. issue is: when I wanted to integrate OWASP ...
2
votes
1answer
149 views

Select query - group by and sub group by

CREATE TABLE [dbo].[temptable] ( [Id] INT NOT NULL PRIMARY KEY IDENTITY, [uid] INT NOT NULL, [pid] INT NOT NULL, [event] INT NOT NULL, [timeStamp] DateTime NOT NULL ) I want ...
1
vote
1answer
103 views

MS Access migration from Oracle to SQL server?

Let me start off by saying I'm relatively new to databases etc. I have been asked to undergo a project is which I will attempt to migrate about 100 or so existing MS access 2003 databases from using ...
2
votes
1answer
185 views

Easiest way of shutting down a PostgreSQL server on Ubuntu

According to pg_lsclusters I have 2 servers running on Ubuntu 14.04: Ver Cluster Port Status Owner Data directory Log file 9.1 main 5432 online postgres ...
2
votes
0answers
2k views

Setting password for 9.3 PostgreSQL server

I currently have a 9.3 server running (on Ubuntu 14.04) with "trust" set as the authentification method in pg_hba.conf. How can I set the password again. In pgadmin the server currently doesn't allow ...

15 30 50 per page