0
votes
0answers
3 views

SQLite 3 Tree List Without CTE

I adapted a SQL statement to work with SQLite 3. But unfortunately Common Table Expressions and WITH clause works only in SQLite 3.6 ahead, but the users of my Open Source application are using SQLite ...
1
vote
0answers
6 views

Have a separate database for data warehousing?

I have built a typical web application using PHP and MySQL for enterprise usage. The MySQL database is 3NF as much as possible. However, as time goes by, the requests for the data appear to be more ...
0
votes
0answers
6 views

How to add External data source into MySQL?

I want to add ODBC data source in MYSQL. Is that possible ?Which is the best to perform this ?
0
votes
1answer
17 views

Application is hanging when database upgraded from SQL Server 2000 to SQL Server 2008 R2

Presently we are working with SQL Server 2000, the database is perfectly working with our software for retail sales counter application developed with VB 6.0. But after upgraded to SQL Server 2008 R2, ...
0
votes
2answers
15 views

Loose database structure

I'm just thinking out loud. I'm wondering if there's any database technology where it's structure does not need to define upfront? For example it may start off with just one column or roll and user ...
0
votes
2answers
11 views

finding text in a string

I am trying to find records where the post code starts with a certain set of characters from some 10,000 records, 1300 or so of which meet the select below. My code is Select * from table where ...
-1
votes
0answers
7 views

MYSQL Service Automatically not respond after some time when 5 people using that connection

MYSQL Stop After some time when no of user connected to MySQL server what is problem I don't know is that MySQL problem because in java I connect properly. my error is some time I need to manually ...
0
votes
0answers
6 views

getting an error in trigger while invoking a procedure in it

i have created a procedure name 'prd' which contains 3 parameters (pmat_amt,pstartdate,pstopdate) which is used to update a column in the table rd_details contains 3 columns which are ...
-1
votes
0answers
3 views

What is difference between CM mode and NFM mode in DB2 V10.1

What is main difference between CM mode and NFM mode in DB2 V10.1. Please let me know features for NFM mode.
0
votes
0answers
4 views

pg_dump in 1G VPS crashes

I'm trying to run pg_dump on a relatively small database (2G), but pg_dump keeps crashing with an out of memory error. du -h --max-depth=0 9.4 1.9G 9.4 The command: pg_dump -Fp -h "$HOSTNAME" -U ...
0
votes
1answer
19 views

Product Attribute System While Avoiding EAV

I'm working on building an attribute system for products. The issue that I'm running into is that various products can have very different attribute requirements. Some E-commerce websites such as ...
0
votes
1answer
32 views

Manage multiple short-term tables with same schema or use single table for short-term data?

My team has proposed to store session state data for each open client session in a table in the database. The application server creates a new table for each client session as the user logs in via ...
0
votes
0answers
7 views

MySqlworkbench asking for convertion

hi everyone i have a question about sql in the programm of mysqlworkbench .I want to convert a er diagramm which i created in word into a database in sql.So Can anybody know to tell me how to connect ...
0
votes
2answers
25 views

Multiple databases or one large database?

My company has a framework where different areas of a region are created as separated databases - we call them datamarts. All of the databases are exactly the same and in some regions we have 20 -30 ...
1
vote
0answers
15 views

Can MySQL log lock waits?

Is it possible to have MySQL log queries or transactions where lock waits occur? Once can debug specific application errors generated from lock wait timeout errors from the DB but without the ability ...
-2
votes
0answers
16 views

How to connect to Oracle Database using SQL Plus?

I need to connect to a oracle database on a remote host (I have no oracle installed locally) using SQL Plus, I've already installed SQL Plus and looking on the internet got those way to connect but no ...
0
votes
1answer
21 views

How to write a query which recursively returns all foreign key references to a column?

I need to obtain a list of foreign keys which refer to a given column, as well as all foreign keys which refer to those keys, and so on. Order does not matter. I have SELECT s.name, t.name, ...
-1
votes
0answers
11 views

After applying SQL Server 2012 SP2, Full-Text Filter Daemon won't restart

Before applying SP2 to SQL Server 2012, I stopped the following four processes in Sql Server Configuration Manager under SQL Server Services: Sql Server SQL Full-Text Filter Daemon SQL Server ...
1
vote
1answer
32 views

Sql Server - Running a Job on Multiple servers

I am using SqlServer 2008. I have a Sql Server Job that checks Disk Space and emails admins if the space is less than 15% Instead of adding that Job to all servers is it Possible to run the Job on ...
0
votes
1answer
7 views

Sql Server Change Data - Insufficient Arguments [on hold]

I am trying to get Sql Server Change Data configured and am running into problems trying to query the tables. My setup: create table Person ( Id uniqueidentifier PRIMARY KEY DEFAULT ...
0
votes
1answer
13 views

Postgres - Inject 0 values when rows do not exist

I have 3 tables that I need for reporting: *dates* date_sk | full_date | day_number_of_month 1 | 2013-01-01 | 1 2 | 2013-02-01 | 1 3 | ...
0
votes
1answer
23 views

How to get best mark for each Student

I can't find a solution although it should be easy one. I have some students and all I need is to get the highest mark of each one in Math. TableName: Students. Columns: Name Mark John 90 John 84 ...
0
votes
1answer
21 views

Return List of Database Users and Server Logins

How can I return a complete listing of all server logins and all database users across my enterprise? Need to include the remote server name, database name, AD account and SQL users.
1
vote
1answer
19 views

Count of 3 consecutive unsynced dates

I have a table set out like so: user_id the_date minutes_asleep ---------------------------- 1 2015-01-01 480 1 2015-01-02 0 1 2015-01-03 0 1 2015-01-04 0 ...
0
votes
0answers
6 views

Using MongoDB with circular object references

Please forgive me from the beginning. I am brand new to document oriented databases and I am sure that I will need guidance to reform the question in order to get answers. I am looking to use MongoDB ...
0
votes
0answers
18 views

Does my MSDN License allow me to use SQL Server Dev on a dev machine? [on hold]

Complete new guy question. Can I install SQL Server Dev version on a machine I use for development? The Dev Machine is a virtual box that I am building and testing an intranet site for my office. I ...
0
votes
1answer
19 views

PostgreSQL Primary key disappears from test table

I have a somewhat convoluted scenario where a test table I had created with a primary key won't return the primary key. pgAdmin III reports there are no constraints. I have the entire PostgreSQL query ...
0
votes
1answer
30 views

MDF file full - cannot find the source of its giant size

All, I am completely at a loss here and I'm hoping you guys can help me out on this one. I am experiencing the following situation on an SQL Server 2008 R2 database. MDF-file: Allocated space: ...
0
votes
2answers
14 views

MySQL always writes simple temporary/memory tables to disk (both tmp_table_size and max_heap_table_size are set to 8GB)

I'm struggling with this issue and just can't figure out why this is happening. CREATE TABLE sitecache._test ENGINE=MEMORY SELECT * FROM website.gallery_likes WHERE 1=0; Every time I execute this ...
0
votes
0answers
13 views

Are there limits to SSRS 2014 RDL files going over to SSRS 2008 (or 2012)?

Is there any incompatibility with reports developed in SQL Server SSRS 2014, and then exported to .RDL files that will be imported into SQL Server 2008?
-3
votes
0answers
18 views

Import Data from SQL Server 2000 to SQL Server 2014

Can I import data from a SQL Server 2000 database to a SQL Server 2014 database? I need this to execute every night. It's only about 10-15 tables/views. If not, can I do with 2012, 2008 R2, or 2008? ...
0
votes
0answers
7 views

new subscriber on existing publication Error number: 20598)

i have Publisher server with one transactional replication on it, one publication with two articles( Microsoft Navision tables), there are 4 servers connected like subscribers and the replication is ...
-1
votes
0answers
3 views

Install mysql udf sys_exec to call php file on trigger

Can anyone explains complete details of installing sys_exec function to call php file on mysql trigger over the SSH. I tried solution given by various links but not luck. please suggest if anyone has ...
0
votes
0answers
7 views

SSAS firewall / restricted direct database use

We want to open ports 2382 / 2384 for users in AD group A (they are supposed to read SSAS data via a sharepoint frontend only). That can be easily done with the windows server firewall, I guess. ...
1
vote
0answers
29 views

Had to force loop join and don't understand why

Hello SQL Server Experts. I have a table (table_A) with about 2 million rows and a table_B with about 10 million rows. SELECT b.title FROM table_A A JOIN table_B B ON A.id = B.A_id WHERE ...
0
votes
0answers
15 views

Unable to start SQL Safe service :Error 1053: Could Not Start or Stop the Service in a Timely Fashion [on hold]

We are facing quite a tedious issue for past couple of months and we are out of ideas now: We are using IDERA SQL safe to backup the databases for our many server: IDERA was installed earlier by the ...
3
votes
0answers
42 views

SQL Server 2012 Installation Has No Option To Uninstall

I've recently inherited a laptop for testing from a client, unfortunately it wasn't a fresh image so it has some software already installed that's causing me some grief. The short version is their IT ...
0
votes
0answers
13 views

Best practices for selecting partition boundary ranges to maintain empty partitions at both end?

I have partitioned the table based on a date datatype partitioning column. The data for the column starts at "2014-01-01" and ends at "2015-01-01". I know that, the partitions should have empty ...
0
votes
1answer
16 views

How to stop Firebird SuperClassic (run as application) in Win 7?

I run Firebird 2.5.3 SuperClassic as application in Windows 7 64-bit with this command: fb_inet_server -a -m Now, how can I stop/shutdown it from command prompt? I know that I could right-click its ...
0
votes
2answers
20 views

How to change ibdata1 path in mysql?

My ibdata1 file is keep on increasing in size and for a temporary solution, we want to move the file to a separate location with more hard disk space. But, when I change the my.cnf file parameters ...
0
votes
1answer
21 views

How to upgrade MYSQL from 5.6.12 to 5.6.21?

I have been a MSSQL DBA and dont have much knowledge about MYSQL. Does MYSQL also have patches just like MSSQL? I need to do MySQL version upgrade from 5.6.12 to 5.6.21 but i do not have much ...
0
votes
0answers
6 views

Report Server Subscription Configuration ISSUE

I Have Created A Subscription in our Development Server With below Steps. 1)Opened Report Configuration Manager and Configure Email Settings. 2) Opened Report Manager and configured a Report Data ...
0
votes
1answer
38 views

Cannot create MySQL database with name '5e370227_db'

Why am I getting error when I try to create database with name '5e370227_db'? I am getting the following error: mysql> create database 5e370227_db; ERROR 1064 (42000): You have an error in your ...
0
votes
0answers
10 views

Use join to aggregate data from various normalized tables

I have a database as follows: tbl_clients (Primary Key: client_id, Foreign Keys:place_id,district_id,zone_id,country_id) tbl_places (Primary Key: place_id) tbl_districts (Primary key: district_id) ...
0
votes
0answers
5 views

why my data is not being sharded?

I am using mongo 2.6.7 I deploy a sharding cluster follow the guide: http://docs.mongodb.org/manual/tutorial/deploy-shard-cluster/ My sharding cluster include: - two replica sets (one primary + one ...
0
votes
0answers
11 views

Single Transaction across multiple Sql Database [on hold]

I have a 3 sql Databases.I have inserted a same record in 3 databases at the same time. if transaction is not success in one Database ,i should rollback other 2 also...can you help me...
0
votes
1answer
28 views

Facing SQL Error 3403

Recently I was working in SQL Server and I faced an error called SQL Error 3403 which was stating: "Error 3403, Severity 22 During recovery initialization, page %ld was encountered. This page ...
-2
votes
1answer
15 views

Query in mysql is not solving [on hold]

I have two tables as pet details & owner details. In that many, no. of columns like Name,pets_id,Owners_id & Name,Owners_id,Mobile No. respectively. I need a query is to display owner ...
1
vote
2answers
28 views

Select from two tables with not direct relationship

OK i found myself in a dead end, and i know must be a way but my brain is just about to explode. This is the case: I have two tables with tons of rows, one for works done (lets call it works table), ...
3
votes
1answer
166 views

Execution Plans Differ for the Same SQL Statement

As a background to this question the details can be found at this link. In a nutshell: I have 2 SQL statements that are almost identical except for the RIGHT table. The LEFT JOIN is the same and the ...

15 30 50 per page