-4
votes
2answers
88 views

Is RAM size related to SQL performance? [closed]

I have some simple code that generates 3 millions insert queries. I have two VPSes, one with 512MB RAM and one with 2GB RAM. On the 512MB RAM VPS, I can insert about 50,000 rows in 5 minutes. On the ...
1
vote
2answers
86 views

How to force sqlite3 table to take next available id for auto increment in firefox sqlite3 manager?

We delete some records in a sqlite3 table (re-id record manually) and compact the db. However when adding a new record in firefox sqlite3 manager, the auto incremented id is not the next available id ...
1
vote
1answer
56 views

Does converting a disk from basic to dynamic require a reboot?

I'm finding conflicting info on converting a disk from basic to dynamic and have a few questions. Will it require a reboot? The server with the disk in question is hosting SQL Server 2008 R2, and ...
0
votes
2answers
51 views

Ubuntu 10.04 database connection problems

I'm having some problems with a legacy program I'm starting back up. We had an image of this server, and the setup is Ubuntu 10.04, 5gb partition for mysql database, and 100gb filesystem. My issue ...
0
votes
1answer
83 views

Which Database (SQL/NoSQL) is the best fit? [closed]

I have 2 nodes, one gateway and one worker. Data must be passed from gateway to worker (without direct connection). I would like to store a Key into a database identified with an ID and a Time To ...
9
votes
2answers
5k views

Third-party SSD solutions in ProLiant Gen8 servers

I was wondering if anyone had any specific experience using Intel DC3700 SSDs (or similar) in the HP (DL380p) Gen8 servers? I'm upgrading a set of database servers that use direct-attached storage. ...
0
votes
3answers
54 views

Connecting mySQL to MSSQL

I need a little advise, I need to sync a DB that is currently on a Server 2008(SQL Server 2005) machine and I use Studio Express to connect to it. I need a way of syncing this DB to mysql that lives ...
0
votes
1answer
46 views

missing data after attach mdb

Recently, one of my customers had a server crash. Unfortunately, the 3th party who was responsible for the backup had 'forgotten' to schedule a backup of the DB (I know, I should have noticed that). ...
0
votes
0answers
37 views

Need some information about using SQL-Express 2012 with an OLD databse software

I have a friend who has managed to go for many years running their company on an old piece of software that is no longer supported. The original software vendor is no longer in business and the one ...
3
votes
3answers
563 views

if I select more than 15 fields, I get catastrophic failure

Using sql server 2012 I am connecting to a linked server with Pervasive SQL on it. When I do select * or select field1,field2,field3....field15 I am getting this error: Msg 7399, Level 16, State 1, ...
0
votes
2answers
133 views

Coverting MySQL SQL statements to SQL Server

I am installing a product which needs a database - it can use any database as long as there is a jdbc connector available for it. However, the installation guide has instructions only on how to make ...
2
votes
5answers
2k views

Mysql - drop database with # in name

How can i delete database with # in name? Like that: #mysql50#mysql.backup I don't know who is possible to created it, but it happened. When I try DROP DATABASE name, I have error: ERROR 1102 ...
0
votes
1answer
326 views

What are invalid table names in SQLServer?

So, apparently you can't name a table Trigger in SQLServer. Someone in my office found out the hard way porting an application from MySQL, I'm suspicious of whether or not that's a valid table name in ...
1
vote
1answer
351 views

Update mysql database with arpwatch textfile database

I'm looking to keep arpwatch entries in a mysql database to crossreference with other information I'm storing based on mac addresses. I've manually imported the arpwatch database into my mysql ...
0
votes
2answers
390 views

How can I move a MySQL database to a new localhost? [closed]

I have a localhost (XAMPP) on an old pc. I need the MySQL database on my new mac with a localhost (MAMP). Issue is, pc doesn't have internet connection. Any way I can move the database over? Detailed ...
0
votes
1answer
164 views

MSSQL Incremental Database-to-Database backup/clone

I'm trying to save some time on a repeated task I keep getting asked to do. We have an internal application we'll call "App". This App has a database called "AppLive" We have a "Test" instance of ...
1
vote
0answers
309 views

Installation of Access Database Engine 32-bit Fails

I am trying to install Access Database Engine 2007 32-bit. The splash screen comes up, you click "Next", then it fails with the error: Installation ended prematurely because of an error You click ...
-1
votes
2answers
236 views

The good SQL database to process a lot of data?

I have to process like 10-100 millions records. I have to give the data to the client when it's finish. The data is givent as SQL requests to execute in the database. He have a powerful server with ...
2
votes
1answer
61 views

Copy a database from Denali CPT3 to SQL 2008 R2

Ok, officially this one is messing with my head. I had the worst idea to try out the SQL server Denali CPT3 when it came out on our development environment. And it seemed ok so we used and gathered a ...
1
vote
0answers
78 views

SQuirreL Client: Opening up a table in a separate tab

I've switched to SQuirrel Client to view an Oracle database with a variety of tables. At any given time, I need to look at the contents of several related tables at the same time. The problem is ...
1
vote
1answer
564 views

How do you read an Oracle .dmp file on a Mac?

I have a ~1GB .dmp file I'd like to get the data out of and I'm on a Mac. Is there any way to do this without either buying Oracle or finding a windows machine? Can you import .dmp files into ...
0
votes
3answers
390 views

What database server will benefit from 4 CPUs

I use MySQL server on Debian GNU/Linux machine with 4 CPUs (Linode 4096) and there are performace issue on havy load (in the middle of the day) but machine is not overload only queries are slow. What ...
1
vote
2answers
336 views

How to leave only e.g. TOP 100 records in ALL TABLES in database (SQL SERVER 2005) [closed]

I'm having a huge database over 100GBs and I need to burn an application (for demonstration purposes) on CD or DVD which uses this huge database... is there a way how to leave for example only first ...
0
votes
1answer
149 views

using command line to extract large db file

I have a large database file (1.5GB) named file.sql, I use "source" command to extract it into mysql databse but I receive lots of error messages. It used to work fine. Here is a snapshot of part of ...
1
vote
2answers
156 views

downloading a large database

I tried to export a large sized database using phpmyadmin but later the downloaded file seems to be of incorrect size, many of the tables inside the database are eliminated during download. The file ...
0
votes
1answer
41 views

Website and DB Backup - Windows Dedicated Servers and SQL Express

I have inherited a number of dedicated windows web servers running websites and local SQL Express Databases. We want to backup both the sites and the databases remotely - maybe to some cloud storage ...
0
votes
5answers
697 views

Move MySQL DB to another server

I have server with very big mysql database (160GB). How easy way to move this DB to another server?
-1
votes
1answer
154 views

Big SQL database platform that performs well [closed]

I would like to know your opinion on which DBMS (probably SQL) can perform fairly well and not stress the server too much from the CPU / RAM point of view. I'm used to MySQL but I found (maybe it was ...
2
votes
1answer
460 views

Do we really need to perform MS SQL database integrity check regularly?

What's the benefit of performing regular database integrity checks? Can't we just perform it when there's a problem?
2
votes
1answer
544 views

How to store text inputs of unknown & varying size? [closed]

I am trying to create a table (or several) to receive user inputs (UGC). This content could vary in size from a single character up to a few hundred words. The input will be coded in utf8_unicode_ci ...
0
votes
0answers
149 views

SQL based database is slow and periodically crashes

This seemed to have happened after a server restart and a server restart seems to temporarily solve the problem. Everyone's database does not crash at the same time. Mine may be working while someone ...
0
votes
3answers
76 views

How to warehouse data that is not needed from MS SQL server

I have been asked to truncate a large table in MS SQL Server 2008. The data is not needed but might be needed once every two years. It will NEVER have to be changed, only viewed. The question is, ...
1
vote
1answer
635 views

Unexplained CPU and Disk activity spikes in SQL Server 2005

Before I pose my question, please allow me to describe the situation. I have a database server, with a number of tables. Two of the biggest tables contain over 800k rows each. The majority of rows ...
2
votes
1answer
180 views

Multipathing vs. bonded connections

I recently tried to sell the idea of multipathing one of our production databases (thanks to Brent at SQL Pass summit!) currently using just 1 database file (189GB!!!) on a physical server with 2 ...
0
votes
1answer
140 views

security in sql server 2008 r2, create special user

I have a system win server 2008/ sql server 2008 r2 where sql server is accessed by remote user (the same but multiple connections). I need to have a user who can create/alert databases but I do not ...
1
vote
0answers
243 views

Error when using mysql to create or change users

I went to change passwword on my mysql user to make sure it was correct for wordpress and when i did it i got Failed to save user : SQL flush privileges failed : Table 'mysql.servers' doesn't exist so ...
0
votes
2answers
154 views

Any other configuration for MySQL database?

I'm trying to set up a MySQL database, and all seems to be working except I cannot get PHP files to communicate with it. Just to be clear, the PHP files are correct, along with the host name, ...
0
votes
1answer
244 views

shrinking a syslog sql database

I am trying to shrink a SQL database used for our syslog monitoring. the DB is about 43GB right now, and i'm sure hasn't been cleaned up in years. I recently inherited this DB when someone quit, and ...
3
votes
1answer
741 views

Deleting MySQL rows causes lock table error

I had a couple million rows to delete but they can't be deleted at once without this error ERROR 1206 (HY000): The total number of locks exceeds the lock table size So I wrote a script to delete ...
0
votes
1answer
315 views

SQL / OracleDB: How to set the same value for all fields in a column?

Is it possible to set a value for all fields in a column, e.g.: ID Host URI 1 //cyrus /images 2 //cyrus /videos 3 //cyrus /text 4 //cyrus /misc 5 //cyrus /backup I want be able to ...
0
votes
5answers
7k views

SQL Server Log File Won't Shrink due cause “log are pending replication” on non replicated DB?

I have a non Mission Critial DB 9am-5pm SQL Server database that I have set up to do nightly full backups and log backups every 30 minutes during business hours. The database is in full recovery and ...
0
votes
2answers
44 views

Network MSSQL with local failover

I currently have a database setup where my MSSQL 2008 R2 server runs on my local network, but the program runs on a notebook that is normally mobile and away from the network. VPN works, but I'm ...
2
votes
1answer
64 views

How to Properly Migrate SQL

If I am changing servers, I usually migrate my wordpress database by going to phpmyadmin and doing an SQL Export on one server and doing an Import on the other server. I notice that in this process, ...
1
vote
3answers
339 views

How can I prevent MYSQL from writing to the disk?

I am using the MEMORY Engine for all tables associated with a particular MYSQL query because speed of access is paramount to my project. For some reason, I have noticed that a large amount of disk ...
1
vote
6answers
164 views

What DB better to use for application?

I want to create program for PC in OS Windows, Mac and Linux. Program deal must use big DB with about 12 000 000 items. I need to have text search what is the best technology for that? Maybe Java + ...
0
votes
2answers
306 views

What Could Be Causing MySQL To Crash On A Read Query?

So I have a pretty large MySQL DB... 7 Gigs in Total size, 35 million URLs. I was querying it (using SELECT queries only) quite fast the other day. My ubuntu froze/shutdown (that's a first!) and said ...
0
votes
1answer
490 views

SQL Server 2008 Error when restoring DB backup: “specified cast is not available”

I was using SSMS to restore a database backup onto another database in a SQL Server 2008 instance, when I received the error message: "specified cast is not available". The backup was made on a SQL ...
1
vote
2answers
342 views

how to choose backup strategy?

I am DBA of a big online retail company. I am responsible for the availability of the company’s database. The size of this database is 28GB, and it handles an average of 120 transactions every minute. ...
1
vote
4answers
253 views

What are performance limits of a database?

What are some rough performance limits (read/s, write/s) for a single database server (no master-slave architecture), assuming storage on disk? How many read/s, write/s, depending on the kind of disk? ...
0
votes
1answer
25 views

How do I Create an AutoCounter Column in a Table in SQL 2008 R2?

There is nothing in the "Data Type" drop-down that indicates an auto-counter. I selected int and I am assuming there is a setting somewhere else to turn it into an auto-counter. The idea is to have a ...