Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database]

System that handles large amounts of data in an organised fashion

A database is a system of handling and organising large amounts of data that can be easily created, reference or edited.

SQL (Structured Query Language) is a database computer language that is designed for managing the data in a relational database management system.

Some popular database systems include:

  • FileMaker Pro
  • IBM DB2
  • Microsoft Access
  • MySQL
  • Microsoft SQL Server
1684 questions
0
votes
1 answer

Oracle/DB2 compare

I need to find definitions or explanations (DB2 and Oracle) for: instance database connection authority authorization transaction log tablespace application agent lock lock timeout Do someone know where can I find this?
Wolfy
  • 176
  • 7
0
votes
3 answers

How to create a large sample database?

I have few sample databases but they are quite small in size. I want to create a database with records upto 50GB. I want to learn many aspects of the database and also want to test our application's performance against it. How to gather random data?…
RPK
  • 215
  • 1
  • 5
  • 12
0
votes
2 answers

How to install Percona Server on Ubuntu 9.10 Karmic?

I followed the instructions on this page: ~$ gpg --keyserver hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A gpg: requesting key CD2EFD2A from hkp server keys.gnupg.net gpg: key CD2EFD2A: public key "Percona MySQL Development Team…
Continuation
  • 3,080
  • 5
  • 30
  • 38
0
votes
1 answer

What is a "DataBase Server Load"?

we are running sql server 2008 (not R2). 64 bit machine/operating system - 32 gig memory. The hardware/system guys are using Orion, I use Idera to monitory system vitals. Orion refers to "Physical Memory Size" Idera uses the term "Available…
Pete Mottershead
  • 1
0
votes
4 answers

back-up database in Linux partition from windows partition!

Hello I am in a very embarrassing situation, I was trying to upgrade to ubuntu 10.04 from ubuntu 9.10 yesterday and while updating I forgot to put my laptop on charger and the battery ran out. Since we know that there is no track back process in…
macha
  • 113
  • 1
  • 3
0
votes
2 answers

is it possible to make .htaccess to connect to DB

is it possible to read the username/password of .htaccess from a database (to allow multiple users) i need to manage it using apache and database only without having any PHP/perl code level any idea is highly appreciated. Regards
Alaa Alomari
  • 638
  • 6
  • 19
  • 37
0
votes
1 answer

How do I connect remotely to SQL Server from Windows client?

Having a bit of an issue connecting to SQL SERVER remotely from Windows. I've verified that all of my settings are correct via SQL SERVER MANAGEMENT STUDIO EXPRESS and SQL SERVER CONFIGURATION MANAGER. I can connect remotely using ODBC drivers from…
humble_coder
  • 533
  • 2
  • 6
  • 14
0
votes
1 answer

Possible to programmatically ALTER multiple MySQL tables?

I have multiple MySQL tables with names of the form "Shard_0", "Shard_1", "Shard_2" ... "Shard_n" All of them have identical table structure. They all live in the same database. Say I want to add a column to all those tables. Is there a way to do…
Continuation
  • 3,080
  • 5
  • 30
  • 38
0
votes
3 answers

Development DB server with dedicated hardware

I'm planning to move one of my development database servers to its own machine. I'm currently running it on my laptop, which is not very convenient. DB Servel is PostgreSQL 9.0.1, OS is Gentoo. There is only one development server attached to the…
Attila O.
  • 226
  • 3
  • 12
0
votes
2 answers

How do I implement a transparent high availability database fail-over solution?

How do I implement a transparent high availability database fail-over solution for my website?
Wiika
  • 101
0
votes
1 answer

Installing plaincart on hostgator

OK, so I am following this tutorial and I'm trying to deploy the sample code onto my MySQL and PHP web server over at Hostgator. OK, so I have all of the files contained in a folder called plaincart (the folder I downloaded from the site I…
Qcom
  • 169
  • 3
  • 8
0
votes
1 answer

Java class issue on Debian 6: java.lang.NoClassDefFoundError: org/apache/commons/pool/impl/GenericObjectPool

I'm having trouble running a script which should rebuild the database for a web service (the Fedora Commons digital repository) which normally runs inside Tomcat 6 (stock Debian version). I'm running it on Debian 6, and though Tomcat starts okay,…
grw
  • 168
  • 6
0
votes
2 answers

Find last access datetime stamp for objects in SQL Server 2000 database

I'm in the planning stage/phase of migrating one of our SQL Server 2000 databases to 2008. Our database holds numerous tables (hundreds) and stored procedures (hundreds). I'm trying to figure out which are in use and which are not. My first guess…
osij2is
  • 3,885
  • 2
  • 24
  • 31
0
votes
2 answers

MySQL CPU Usage at 99%

We have a Java based SaaS application running on MySQL database on a 2 GB Linux VPS. Recently we added RAM to the server and since couple of days, MySQL is taking up 99% of CPU usage. We are quite clueless as to why this is happening. We have made…
Souvik
0
votes
2 answers

Migration From SQL Server 2008 Express to SQL Server Web

I have SQL Server Management Studio (for SQL Server Express R2) on my pc, and I'd like to export a few databases for use by a website that's running on a server with SQL Server Web. However, when I right click one of the databases in management…
user55974
1 2 3
…
99 100