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
14
votes
7 answers

SQL Server - Force DB in memory?

We have a beefy Windows 2008 x64 server (4 x 4 core CPU, 32GB RAM) running SQL Server 2005 64-bit. We have a small (6GB) but very important database that is somewhat slow to access until the pages are cached in memory (the usage is very much random…
Matt Rogish
  • 1,512
  • 6
  • 25
  • 41
14
votes
6 answers

How can I diff two Oracle 10g Schemas?

I have the feeling that there are some difference between two large complicated Oracle schemas which should be identical, so decided to dump and diff them to investigate. I found an article…
Stuart Woodward
  • 1,343
  • 4
  • 14
  • 29
14
votes
1 answer

How to disable keys in MySQL InnoDB tables?

Is it possible to disable keys in InnoDB tables? If yes, how? If not, why?
user12145
  • 1,115
  • 6
  • 28
  • 47
13
votes
11 answers

Should I run my database off of a RAID 5 configuration?

I've heard that the write performance of RAID 5 can be appalling at times. While I want the redundancy that it provides I don't want to sacrifice my database insert/update times. Is this something I should be worried about and if so, what would be…
Scott Saad
  • 436
  • 2
  • 7
  • 10
13
votes
2 answers

With MySQL, how long does an "ALTER TABLE ... DISABLE KEYS;" statement last?

If you disable the keys (suspending indexing) on a mysql INNODB table, how long does that setting last? For a query like: ALTER TABLE users DISABLE KEYS; Do the keys get re-enabled at the end of the script? or do they last until you explicitly…
Daniel Beardsley
  • 547
  • 6
  • 12
13
votes
4 answers

Giving a database an alias in postgres

Is there any way to give a postgres database an alias? Essentially, I need a single database to operate with two names, so that I could make queries to, say, DB_ALPHA and DB_ONE and they'd have the exact same effect. I accomplished this in MySQL by…
bigmattyh
  • 308
  • 1
  • 2
  • 9
12
votes
3 answers

What types of systems have to “scale up” rather than “scale out”?

I have been wondering for a long time if there are systems that have to "scale up" (onto a more powerful, more expensive server) rather than "scale out" by being split across many smaller servers. Do such systems exist, and if so, is there anything…
Demi
  • 239
  • 1
  • 9
12
votes
3 answers

What is more important for a database server? Mem? Mem speed? Cores?

I am going to be moving my database server to somewhat better new hardware. The current database server does not have any problems except that it is running Centos 4. The current hardware is 2 quad core xeon 5335, 4 15K RPM in RAID 10 and 4GB(yes,…
Echo says Reinstate Monica
  • 1,165
  • 3
  • 11
  • 16
12
votes
2 answers

Is there a secure way to allow IIS 7 in a DMZ to access a DB server behind the firewall?

Our network admins are adamant that it is insecure for our web servers, which are hosted in the DMZ, to access the DB server behind our firewall. To get round the problem, we access the data via web services or WCF. I feel that this is an…
Al Polden
  • 223
  • 2
  • 4
12
votes
8 answers

What hardware makes a good MongoDB Server ? Where to get it?

Suppose you're on dell.com right now and you're buying a server to run your MongoDB database for your small startup. You will have to handle literally tens of thousands of writes and reads per minute (but small objects). Would you go for 2…
João Pinto Jerónimo
  • 245
  • 1
  • 3
  • 6
12
votes
6 answers

How do you interview a Database Programmer/ Admin applicant?

During the interview, I ask basic database design questions. Normalization (When-Why) is one of my concerns when it comes to database design. Some scenarios I site that involves synchronized servers and what/why/how they take consideration of…
Sajal Dutta
  • 613
  • 5
  • 18
12
votes
7 answers

How to undo DROP Table?

I accidentally dropped all tables. Can I restore back? I don't have the backup copy.
deadman
11
votes
4 answers

PostgreSQL scaling up to 64 cores?

In this Computer World article, it specifies that PostgreSQL can scale up to a core limit of 64. Does this mean for one multi-core processor of 64 cores? Or multiple processors with fewer cores? The reason why I ask is because I am trying to find…
O_O
  • 635
  • 3
  • 15
  • 25
11
votes
4 answers

How do I most efficiently store and serve 1,000,000+ small gziped files on a Linux web server?

I have large static content that I have to deliver via a Linux-based webserver. It is a set of over one million small, gzip files. 90% of the files are less than 1K and the remaining files are at most 50K. In the future, this could grow to over 10…
Jérôme Verstrynge
  • 4,787
  • 7
  • 24
  • 35
11
votes
5 answers

Database planning - Multiple Schemas vs Multiple Databases vs Single large database vs Partitions

We design websites for Realty companies. The websites are used only to display the information and all the websites share a common template. We have around 150 websites for different customers. Some third party data providers, provide us all the…
kishore
  • 872
  • 3
  • 13
  • 28
1 2 3
…
99 100