0
votes
0answers
4 views

import and export some Excel data from an Excel sheet into a sql server database

have sql server 2008 64bit Developer’s Edition Installed on my machine. And Microsoft Office 2013 Professional 64bit. I have been trying to import and export some Excel data from an Excel sheet into ...
0
votes
0answers
4 views

Breaking up large transaction - worth it?

I'm in charge of monitoring the performance of an industrial chemistry process. Every hour, a process gathers 50 million rows from various subsystems and feed into the central database. The whole ...
0
votes
0answers
6 views

SQL Server FILESTREAM access denied

I have my machine and a database server on the same Windows domain. I also have a staging machine that is not on the domain. From my machine, I am able to perform any and all operations using ...
0
votes
0answers
6 views

MySQL created_by or updated_last-by

I've been giving the task of taking SQL DDL from data modeler and to transcribe it into mySQL for an internship. The only thing I cannot figure out is how to take Created_By VARCHAR2(30) DEFAULT ...
1
vote
1answer
12 views

Converting string to date with timezone adjustment

I am attempting to convert stirngs to dates in mysql Thu Oct 23 16:46:47 2014 +02:00 Im unsure how to handle the +02:00, The rest is simple enough update logs set date = str_to_date(date_raw, ...
1
vote
0answers
16 views

Transaction Log won't shrink, DB thinks it is replicating

I've got a database MSSQL2008R2Express DB running Kaspersky Security Center, and I have no idea under what circumstances the install happened, but the database appears to think that it's being ...
0
votes
0answers
18 views

Accessing SSRS receive System.UnauthorizedAccessException

Trying to log into localhost/reports I get the following error on the screen. An internal error occurred on the report server. See the error log for more details. (rsInternalError) Access is ...
0
votes
1answer
7 views

Implement a Parent-Level Count in Binary Search Tree

Based on this question, have any way to implement a parent level count? Find highest level of a hierarchical field: with vs without CTEs Example table: +----+-----------+ | id | parent_id | ...
0
votes
1answer
15 views

high mysql sent traffic

we have a wordpress site (Centos6.5+apache2.2.15+mysql5.1.73+php5.3), which are server in vultr, I noticed there has a terrible mysql traffic. Traffic Tip ø per hour Received 67 MiB 88 MiB Sent ...
0
votes
1answer
15 views

creating cache tables in database

I have a big database with sort of complicated relations between tables I have some common queries for retrieving data by joining several tables and I'm using view and stored procedure now . Would it ...
0
votes
0answers
6 views

What pivot tables to use for User Event Registration with Events and Sub Events

I need to design a database for an application to register and review attendees for events. But There is a complication I don't know how to deal with The event they can register for is for a month, ...
0
votes
0answers
11 views

How to solve “ORA-12514: TNS:listener does not currently know of service requested in connect descriptor” error?

I am trying to create connection with the database for debugging ASP.Net website. Database is 11g Oracle DB... There is no problem when I connect using SQL Developer, however using Visual Studio I get ...
0
votes
1answer
22 views

Recover data from corrupt .mdf and .ldf files

The server was crashed due to some hardware problems. I was able to recover .mdf and .ldf files but when I tried to attach them an error message appears that. I am running MS SQL Server 2000 SP4. ...
0
votes
1answer
15 views

SQL Server 2008R2 - how to install replication components

I am trying to install the Replication components for SQL Server 2008R2, on technet website it says: 1.On the computer that is running IIS, insert the SQL Server 2008 R2, SQL Server 2008, or SQL ...
0
votes
0answers
8 views

How do I call a collection of tables with normalized (generic) information

In a database design there are many fields with information that needs to be normalized. For instance for an address record countries can be normalized but also the address type (i.e. private address, ...
0
votes
1answer
9 views

MysqlDump with ignore errors

I'm helping a friend to backup his database, but I can't get it right doing standard mysqldump process, when I try to use mysqlcheck, I sort the result: http://pastie.org/9748430 '___') It's ...
0
votes
0answers
2 views

corrupt 'msmMMOB.mdb' file

In the process of cleaning up my harddrive, some files have been shuffled between OMFI MediaFile folders. Upon startup, Avid rescans the folders, however this time I am recieving an error message, ...
0
votes
0answers
19 views

Count rows in dataset SSRS2012

I want to count the number of rows in my result DataSet, I put in my DataSet a calculated field with this expression : =CountRows("DataSet1") But I have the following error message: "The expression ...
2
votes
1answer
16 views

Will MyISAM prevent multiple users inserting data at the same time?

I am using a MyISAM database to store user data because I am using full text searching. I have looked in to options like Sphinx but cannot install this on my shared hosting plan which uses MySQL ...
3
votes
1answer
50 views

Discrepancy between system catalog view and sp_change_users_login?

I want to check for orphaned users on a database. To that end, I use the following query on my SQL Server 2005 instance to get all users and their accompanying logins for a specific database (say ...
1
vote
0answers
21 views

Oracle Data Pump Import with running advanced replication

In our system we have a running advanced replication between two databases(11g release 2) and want to use pump import to import a backup on one site. However the imported data is not replicated to the ...
2
votes
2answers
64 views

InnoDB inserts 100 times slower than SQL Server inserts

I have a simple table with two columns: id (autonumber) and name (char(255). When I use C# to insert 100 records in a loop it takes about 30 milliseconds per insert. This is way too slow. So I ...
0
votes
1answer
22 views

Stored Procedure count and list the occurrence using like from another table

Actually this is my first procedure apart from basic "Hello world" procedure. I have two tables like this: cars users ------------------------- ...
0
votes
1answer
44 views

SELECT with lots of left join is very slow in SQL Server 2014

I've got a query with, more or less, this structure: SELECT MAINTABLE_ID FROM MAINTABLE WITH (NOLOCK) LEFT JOIN TABLE_1 WITH (NOLOCK) ON TABLE_1_FK_MAINTABLE_ID = MAINTABLE_ID LEFT JOIN ...
1
vote
0answers
8 views

Application running slow when querying against SQL Server 2008R2

I'm having an application that is starting to run really slow when inserting and querying data from a SQL server. The db is on a dedicated virtual box with 10 GB ram, AMD Operon 6134 processor (4 ...
0
votes
0answers
17 views

Cannot connect to PostgreSQL database as 'localhost'

I am developing an Android application and I'm using PostgreSQL bundled with PostGIS. I want to use a local database for that but connecting via 'localhost' doesn't work, I have tried the alternative ...
0
votes
0answers
12 views

SSRS using select from (Select)

I want to report a script which contains a Select from (Select), when I just run the second select I have no problem but when I put the whole script it loads and nothing happens. Here's my code : ...
1
vote
0answers
11 views

How to create a “match result” data type?

I'm building a football match table which contains one column "match result", which should consist of data like "3-1","0-0"... I'm wondering what kind of data type is best appropriate for it, varchar ...
0
votes
2answers
14 views

MongoDB replicaset number of connections too high

I'm using a 3 node replicaset with 2 data nodes(version 2.6.1 and 2.6.3) and 1 arbiter node. I get frequent alerts on number of connections >1000, whereas total databases are about 400 and also I'm ...
1
vote
1answer
151 views

Why is casting a string to DATETIME not accurate to the ms? [on hold]

Why does SELECT CAST('2014-11-28 15:06:02.165' AS DATETIME) return: 2014-11-28 15:06:02.167
0
votes
0answers
11 views

How to calculate total amount of time to load CSV file in SSIS [on hold]

In current, I have one C# application and it is calling SSIS package (.dtxs) to load one CSV file(about large than 100MB). I would like to calculate estimation of time to load this file into my ...
0
votes
0answers
29 views

How to find what is causing large transaction log backups in MS SQL Server? [duplicate]

Most questions, including Why Does the Transaction Log Keep Growing or Run Out of Space? and other articles deal with people who have a transaction log file that keeps growing, usually due to them ...
1
vote
0answers
11 views

PostgreSQL 9.4 analysis, performance of normal column, indexed column and jsonb key

If I have a table containing: CREATE TABLE test( id SERIAL PRIMARY KEY, name VARCHAR(200), age INT, data JSONB ); and data column populated with {"name": xxx, "age": yyy}, sometimes ...
0
votes
0answers
19 views

SSIS cannot access the file

I have a SSIS package which performs a few tasks using SQL Server Agent. First it executes a script task, then accesses Excel files, executes a SQL query and moves files to another directory. The ...
0
votes
0answers
18 views

Why index is not used?

I've been asked a question in interview which i could not able to answer as i'm not much into mysql. I would like to know explanation about scenario. There is a table with colomns like id, day & ...
-3
votes
0answers
11 views

Error while running a job [on hold]

Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the necessary space by dropping objects in the filegroup, adding additional files ...
0
votes
0answers
7 views

Galera cluster consume many CPU percent and CPU high load

I have implemented a cluster include three nodes: two stored nodes and one garbd (also haproxy - load balancer). Some information about servers: SSD 480G Raid1 Memory 32G Swap 16G 2xCPU, number of ...
1
vote
1answer
17 views

check the progress of table upload-mysql

I have a dataset of around 200GB. The sample is shown below: Posted a new song: "Ensaio Don`t back anger & imagine- Stone Rocks " http://t.co/i9TqakT38t #music 460523675293196289 ...
0
votes
0answers
6 views

Converting Timestamp datatype to Datetime datatype

I have a Timestamp datatype variable in my SQL Server 2008 database. An example of such variabel is "0x00000000CA346EDC". As for as I know its not possible to Convert a timestamp Datatype to datetime ...
0
votes
0answers
18 views

Best way to store a function map

I am building a site where data gets filtered through user defined functions to create an output. It is a requirement that the functions are represented in the database as formulas. For example a ...
0
votes
0answers
10 views

MYSQL Group Replication

I have setup a Master-Master-Slave replication where say A B and C, I want to replicate data from A to B (which is working) and B to C (also working) and from A to C which is not working with two ...
1
vote
1answer
25 views

Should I put common fields in each specific tables or one common table then join when data selecting?

Assuming there are a few categories: blog, video, gallery. Each of them contains post data like id, title, content, author, create_at, but different category have few more specific field: video will ...
0
votes
0answers
5 views

issue granting privileges in a hierarchical user configuration

as SYS: grant execute on sys.dbms_reputil to system with grant option; grant select any dictionary to system; grant dba to system; -> ok. Then, as SYSTEM: GRANT EXECUTE ON sys.dbms_reputil TO ...
1
vote
1answer
16 views

Using Aerospike without SSD [on hold]

Is there a drawback for using Aerospike when used in non-SSD server?
0
votes
0answers
4 views

Tempdb tables, table in database or even cte for usp for reporting

I am about to start a project for SSRs report base on a USP. The procedure will have to use two cursors to compare orders v stock position (similar to a mrp run ): I am thinking of storing the data ...
0
votes
0answers
13 views

PostgreSQL: Store hierarchial data and return a recursive result with full path data

Background: I am considering whether to use LTREE or Recursive CTE with Materialized Path. For storing data, I am deciding between HSTORE or JSON. Objective: I need to store a hierarchial data. Each ...
0
votes
0answers
14 views

How can I copy a database from Sql Server to Azure Sql Database?

The local database has settings that Azure will not accept and that we must keep in the local copy. I tried using SSDT and with that I could publish to a new database on my local Sql Server a schema ...
2
votes
0answers
28 views

select on table slows done during update on same table [on hold]

I have a weird problem with mysql. During a transaction which runs from 10-30s around 270 statements are performed, some of which are updating and inserting a few rows on a table. If a select is ...
2
votes
2answers
103 views

SQL Server doesn't use expected index

I have the following query (simplified from an Entity Framework query, I don't have direct control of the SQL): SELECT TOP 15 HouseHoldingRuns.Id, ( SELECT TOP 1 ManCoId FROM ( SELECT TOP ...
0
votes
1answer
10 views

my.ini configuration for a huge server

I have developed a web based app in PHP MySQL and Flash Builder. It was running fine until a few days ago when the client began to connect a lot of users. Then the app started to freeze and sent ...

15 30 50 per page