I have implemented a sharding solution for our SQL Server databases as per the MSDN documentation here: https://msdn.microsoft.com/en-gb/library/dn589797.aspx This has been running for around 6 months now with 4 shards, but is now getting to the point were the workload across these shards is g...

I am looking for the best database solution for a high availability, high performance solution that meets the following requirements. Data being read, written and updated is very simple, and small. Must Haves: Fast Reading and Writing without failure. Concurrent reading and writing Ability to ...

I am a newb, just gonna put that out there. I am currently on a shared hosting plan with Godaddy. I have started a free trial with DigitalOcean to see how I would fare with a Linux VPS using putty. I have installed multiple Wordpress sites and they work etc. but I cannot for the life of me get t...

I am planning out a website project and have a limited amount of knowledge and understanding, which are two completely different things. I hire freelancers to do my actual work, but for that to work out right it sometimes seems like I need to know as much as they do. It is kind of a garbage in ga...

I need to compare three columns in a single table. Please help me clarify this problem. $pro_qry1 = "SELECT * FROM orders WHERE customer_id ='$id' AND item_id='$pro_id' AND status='0'"; $pro_run1 = mysql_query($pro_qry1) or die(mysql_error()); $pro_result1 = mysql_fetch_assoc($pro_run1);

Can Anybody help me I was using SQLite database but it does not support multi-user write or concurrent writes or simultaneous multiple writes. I want to Ask which reliable Sql or non-Sql database supports multi-user write or concurrent writes

I am currently an Electrical engineer and I have been tasked to set up a database(outside my realm of expertise) that will be used by multiple users over a networked drive. There will only be a couple thousand data entries with images as well. I have currently thrown together a quick access data...

I'm just starting using data bases and I want to create a table which will store some values and 2 other tables in it. If I were using java for instance I would create an array list of table document and step inside my table ... so if you make my point here are my tables ... also I need at most...

I have a very simple MySQL stored procedure as shown below: BEGIN INSERT INTO listing_offers (lo_active, lo_amount, lo_amount_number, lo_contract_reference,lo_created, lo_currency, lo_currency_symbol, lo_entity_name, lo_listing_id, lo_loc_total, lo_loc_passed, lo_loc_failed, lo_status, lo_...

there are 4 columns which I need in conditions. age, city, accommodation, sex I want to export total number of 1000 records in the following criteria: I choose ages between 31-35 years old with both sex, 3 cites and in accommodation in apartment and villa. I want the records in such a split: ...

Since yesterday, I have not been unable to run procedure on Oracle SQL Developer. When I click on Run button, progress bar with "Launching" text appears on the right bottom corner of the SQL Developer, and then it stuck in there. In the Logging Page: Source ...

Running a client/server application where the client app is powered by MS Access and the database on the server is in SQL Server. We have two locations and have active users at both. We recently moved from Century Link's MetroE, now considered a legacy product, to their new MPLS offering. MetroE ...

I have a trigger script that creates the trigger, compiles and runs without any error in DB2 with Windows Environment. The same sql script is failed to create the trigger on the DB2 with Linux 5 version. Please note that the version of DB2 is identical on both machines. Any helps??? Regards,...

I summed the same float data it returns different result. Any help? The column Value is float. SQL command used to sum: Select sum(Value) from myTable There is no index in this table. My records are like this, RecID Value 1 -4832.12000000001000000000 2 -266765.26000000000000000...

All, I'm building a view which uses a spatial intersect (STIntersect in MSSQL 2012) between points (student addresses with address information) and polygons (school boundary polygons with school numbers by grade). The idea is another team will build a stored procedure that will take an address ...

Could any one please tell how to convert .ibd , .frm, .MYD, .MYI FILES TO .SQL . Or is there any way to open this files in php my admin .. Please tell how to convert this to .sql file

I have to mantain very big and complex SQL queries (more than 1000 lines) with many nested subqueries. These queries were made by other people and are very difficult to understand, so I want to replace all subqueries with CTEs to make them easier to understand. Is there a tool to automatically r...

I connected to my server using ssh via Putty, and I typed the command apt-get install git or sudo apt-get install git but I get the error : -bash: apt-get: command not found or -bash: sudo: command not found. But other commands like ls work.

I am trying to rename a table but it has many locks in it.Is there a way other than sp_rename ?

I'm trying to think of an architecture for my game server. Here is how it would work for two regions: A server instance runs on one machine For each machine there is a slave database to speed up SQL statements such as SELECT. My problem here is that I don't really see how I would speed up IN...

I need to read some .sbf and .sbd files but I don't find any software for it. I have downloaded FileViewPro but when I try to open .sbf file, appears an error. A lot of thanks for your assistance

MySQL keeps crashing, but after futher research, I found this error SQLSTATE[08004] [1040] Too many connections but I have this line #max_connections = 100 commented in my.cnf.

I am developing a Bus Route Demo application and I am trying to design the UI based on the below table sqlfiddle: PKID BUS_ID STOP_POSITION STOP_ID ------------------------------- 1 1 1 A 2 1 2 B 3 1 3 C 4 2 3 C 5 2 ...

I have a situation with some of the scheduled tasks when they are completed a messages appears on the activity monitor that reads performing completion action and in some cases it is taking very long time to clear up / away. Any ideas will help. Thanks John

I have a question I need to answer about how to retrieve data from a production database without being able to mess up up the data. The question (from an interview) is: For your daily work you use production databases to get raw data for analysis as well as to pre-process it. What precauti...

I have a client that had an employee intentionally permanently delete their work off a laptop. This employee also uninstalled the programs associated with some of the data. Using data recovery software I was able to recover everything that had been deleted that had not been over-written. I was...

I'm newish to Sql. In an attempt to make a query more efficient I noticed something strange, the following query, on a single date (where date is a datetime object: SELECT ..., Sum(...)/COUNT(DISTINCT DATE) FROM DATABASE WHERE date = '01 Jan 2012' ran about 40 times faster than a similar query...

I'm having trouble to model a scalable database schema with performance in mind. The requirements are wide, as such that I need a schema that supports; user can swith between multiple types of accounts, any account can interact with content, know who interacted with content, if needed. I will...

I'm trying to figure out if it is possible to implement a faceted search (like the ones popular in online shops like Amazon) in a reasonably sane and efficient way in PostgreSQL. A faceted search allows the user to filter the results by certain facets, and shows the number of results for each fil...

Following data table and query is a simplified version of what i have on production. Table: Id ParentId KeyText Value Example data: Id ParentId KeyText Value 1 1 'a' 12 2 1 'b' 2 3 2 'a' 4 4 2 'b' 8 Th...

On a monthly bases our databases (Oracle and MSSQL) are heavily calculating and persisting GB of data in 100+ of schemata (5 really important schemata). 1/2 Day building archives (inserts); 2-3 Days calculating (inserting/updating); 1 Day ETL -> DWH; 1 Day creating/persisting reports. A lot of th...

I noticed in the last month one of my SQL Server instances is getting a daily SQL Dump saved off to the Log directory. Unfortunately the SQL Dump is getting large and is consuming the majority of disk space. I don't know exactly where to start investigating why I'm getting SQL Dumps. If I run a D...