All Questions

Filter by
Sorted by
Tagged with
13 votes
2 answers
7k views

How do I change the instance name in MS SQL 2005 without installing a new instance?

I have an instance that really has nothing on it, it's merely been installed (it was intended for one project, but that never actually got done on this server, the project was done in duplicate on ...
jcolebrand's user avatar
  • 6,354
21 votes
4 answers
93k views

Can I change the SID of an Oracle database?

The Server is Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Is there an easy & quick way to change the SIDs of the test databases on the server? Dropping & recreating of ...
bernd_k's user avatar
  • 12.2k
28 votes
4 answers
69k views

How to change SQL Server collation

How could I change the SQL Server 2008 R2 Express Default Collation for the whole server and a particular database? Is there a way to do it using visual interface of SQL Server Management Studio? In ...
rem's user avatar
  • 1,555
7 votes
2 answers
16k views

Can I use OpenLDAP to authenticate users in Oracle?

I like to use OpenLDAP to authenticate my Oracle users. It should be possible to fetch at least the password from the directory. There appearently is something for the Oracle LDAP servers, but would ...
Sebastian Roth's user avatar
74 votes
3 answers
43k views

What are the drawbacks with using UUID or GUID as a primary key?

I would like to build a distributed system. I need to store data in databases and it would be helpful to use an UUID or a GUID as a primary key on some tables. I assume it's a drawbacks with this ...
Jonas's user avatar
  • 33k
13 votes
3 answers
7k views

Dynamic SQL in MySQL stored routines

According to the restrictions on stored routines and triggers, dynamic sql cannot be used (restriction lifted for stored procedures in version 5.0.13 and later). Why is this limitation in place? And ...
Derek Downey's user avatar
  • 23.5k
19 votes
6 answers
39k views

What is the recommended RAID configuration for an Oracle database?

RAID (Redundant Arrays of Inexpensive Disks) comes with different configurations (RAID-0, RAID-1...). What is the recommended RAID configuration that I should set up and use when installing an Oracle ...
Eddie Awad's user avatar
7 votes
1 answer
2k views

What are some important MySQL status variables to keep an eye on? [closed]

I'm a fairly new DBA with a programming background. As such, I like to build tools to manage tasks to help me familiarize myself with the intricacies of a technology. In this case, I am managing ...
Derek Downey's user avatar
  • 23.5k
15 votes
3 answers
3k views

Speeding up conversion of MyISAM to InnoDB

I've got a mysql 5.1 server with a database of approximately 450 tables, taking up 4GB . The vast majority of these tables (all but 2) are MyIsam. This has been fine for the most part (don't need ...
Derek Downey's user avatar
  • 23.5k
28 votes
3 answers
39k views

Code to simulate deadlock

I am testing my application I need some code that stable simulates the deadlock on database site (sql script if possible). Thank you. ADDED: Reproducing deadlocks involving only one table
garik's user avatar
  • 6,722
13 votes
2 answers
4k views

Security for Application Developers doing PL/SQL work in Oracle

How do you handle the lack of Schema level privileges in Oracle? Oracle’s security architecture works well for applications that only need object level privileges and it works well for DBAs that need ...
Leigh Riffel's user avatar
  • 23.9k
6 votes
1 answer
142 views

Where to put a database in case of IP failover?

I understand that to achieve some level of availability of an online application it is possible to organize an environment with a redundancy using an IP failover mechanism and switching between ...
rem's user avatar
  • 1,555
29 votes
4 answers
17k views

Why is OS authentication considered poor security for Oracle databases?

Oracle is deprecating OS authentication according to the Oracle Database Security Guide, which says Be aware that the REMOTE_OS_AUTHENT parameter was deprecated in Oracle Database 11g Release 1 ...
Leigh Riffel's user avatar
  • 23.9k
7 votes
3 answers
3k views

Online resource for writing Access SQL statements [closed]

I am looking for an online resource for writing Access SQL statements. I write queries using SQL because the UI puts limitations on what can be queried. I have been using w3schools for reference, ...
Move More Comments Link To Top's user avatar
10 votes
2 answers
6k views

Why can't I read Oracles CLOB columns via SQL-SERVER 2008 linked server?

I want to access data in an Oracle 11g database from SQL-Server 2008 I set up a linked server and when I execute select * from [Link_server_name]..Oracle_schema.Oracle_table and Oracle_table ...
bernd_k's user avatar
  • 12.2k
9 votes
2 answers
9k views

Is it better to store calculated values or recalculate them on request? [duplicate]

Possible Duplicate: Storing vs calculating aggregate values At an old job, we had this database, it wasn't normalized rigth, some tables wheren't used anymore, it was patch after patch. In ...
eiefai's user avatar
  • 1,874
6 votes
2 answers
482 views

different login credentials based on user

I run a PHP symfony-framework web app for my company and it uses a single database login for all connections, whether the user is an admin or a client. I know that higher security systems often use ...
Patrick's user avatar
  • 4,229
8 votes
2 answers
1k views

Is this a new common pattern in Oracle Where exists ( Select NULL FROM...)?

Years ago, it was common to write where exists (Select * from some_table where some_condition) Last year I noticed that many t-sql scripts switched to using the number 1 instead of the star where ...
bernd_k's user avatar
  • 12.2k
1 vote
1 answer
167 views

version controll application/system for mysql databases [duplicate]

Possible Duplicate: Keeping track of schema changes Hello, How do you keep your mysql database schema under version control.
Gabriel Solomon's user avatar
32 votes
9 answers
39k views

How do you version your Oracle database changes?

I am interested to know what methods other people are using to keep track of changes made to the database including table definition changes, new objects, packages changes, etc. Do you use flat files ...
Leigh Riffel's user avatar
  • 23.9k
15 votes
5 answers
16k views

Does it make sense to use SQL Server's bracket notation in hand written code?

Code generators tend to be simpler when they generate output using the new Microsoft bracket notation ([]) for nearly everything. When I first saw it, I though wow a reincarnation of the somewhat ...
bernd_k's user avatar
  • 12.2k
0 votes
3 answers
224 views

What database platform better at scaling? [closed]

I am planning a for a database that i expect will be very big in terms of number of records rather than tables and batabases. My Question is what product (i.e, SQL 2008, Cassandra, Azure) handles ...
Sevki's user avatar
  • 533
19 votes
4 answers
12k views

Task scheduler for SQL Server Express

I have an ASP.NET MVC app which works with database under SQL Server 2008 R2 Express edition. There is a need to perform a regular task on updating some records in the database. Unfortunately the ...
rem's user avatar
  • 1,555
174 votes
6 answers
172k views

Guid vs INT - Which is better as a primary key?

I've being reading around reasons to use or not Guid and int. int is smaller, faster, easy to remember, keeps a chronological sequence. And as for Guid, the only advantage I found is that it is ...
BrunoLM's user avatar
  • 3,493
7 votes
2 answers
154 views

Is there a good "rule of thumb" for translating EXPLAIN cost to (wall-clock) runtime?

From time to time, consumers of my database processes will ask for an estimate of when a given task will be done. While I feel like I know how to read an EXPLAIN in most database engines, I have ...
TML's user avatar
  • 1,364
25 votes
3 answers
5k views

Which collation should I choose for a muiti-language website?

Does a collation have any influence over a query speed? Does the size of a table change depending of the collation? If I want to build a website that must support all possible languages (lets take ...
BrunoLM's user avatar
  • 3,493
8 votes
3 answers
222 views

Is there a performance gain by handling data with stored procedures versus feeding it into functions after retrieval?

Title sums it up. I'm reasonably well off with PHP, and comfortable getting it to do what I need it to with values pulled from MySQL, however in the interest of expanding my knowledge I've been ...
Kaji's user avatar
  • 937
13 votes
1 answer
1k views

SQL Server - How are data pages stored when using a clustered index

I recently heard that the data pages in a clustered index aren't stored contiguously. Is this true? Perhaps data pages are normally stored contiguously with some exceptions to the rule? Or perhaps I ...
Peanut's user avatar
  • 233
5 votes
1 answer
102 views

Can I activate PITR after the DB has been used

My Postgres-Server is running for quite a while and contains probably 4-5 GB of data. Backups are done using dumps, and this works ok. Though not most efficient, it just works. Due to future growth ...
Sebastian Roth's user avatar
111 votes
5 answers
33k views

Storing vs calculating aggregate values

Are there any guidelines or rules of thumb to determine when to store aggregate values and when to calculate them on the fly? For example, suppose I have widgets which users can rate (see schema ...
BenV's user avatar
  • 4,903
31 votes
3 answers
9k views

Character vs Integer primary keys

I'm designing a database with multiple lookup tables containing possible attributes of the main entities. I'm thinking of using a 4 or 5-character key to identify these lookup values rather than an ...
BenV's user avatar
  • 4,903
18 votes
8 answers
24k views

Must-read Books for DBA [closed]

This question is almost mandatory in any SE site for basic reference. Please post only books with permanently value for DBAs in general. The post should be a must read book, the classical ones, the ...
8 votes
3 answers
884 views

Which databases are recommended to be used as embedded databases?

Which databases are recommended to be used as embedded databases to store data within an application? The embedded database may or may not synchronize back to a larger system database.
SchwartzE's user avatar
  • 339
21 votes
13 answers
1k views

The Value of Certifications [closed]

Questions What certifications do you have? Has your certification (or lack of one) ever worked for or against you? Do you intend to reach out for certification? Do you renew your certifications? If ...
Riedsio's user avatar
  • 1,377
6 votes
4 answers
3k views

Is there a way to measure replication lag in MySQL with a resolution less than 1 second?

Is there a way by which you can measure replication lag in MySQL with a resolution of less than 1 second? That is, can replication lag be measured on the microsecond or millisecond level?
Riedsio's user avatar
  • 1,377
24 votes
2 answers
3k views

Do I need separate indexes for each type of query, or will one multi-column index work?

I somewhat know the answer to this question already, but I always feel as though there is more I need to pick up on the topic. My basic understanding is that generally speaking, a single index that ...
Andrew Barber's user avatar
4 votes
4 answers
725 views

how did you become a DBA? [closed]

maybe this is more of a wiki type question, but I'd like to learn more about the (no doubt many) paths taken to become a DBA. What path lead you to become a DBA?
Ramy's user avatar
  • 191
5 votes
1 answer
459 views

What are the pros and cons of using the Sphinx Storage Engine?

What are the pros/cons of using the Sphinx Storage Engine in MySQL (doc) over the normal api?
Riedsio's user avatar
  • 1,377
40 votes
6 answers
70k views

How do you tune MySQL for a heavy InnoDB workload?

Assuming a production OLTP system with predominantly InnoDB tables What are the common symptoms of a mistuned/misconfigured system? What configuration parameters do you most commonly change from ...
Riedsio's user avatar
  • 1,377
5 votes
0 answers
281 views

books for aspiring DBA [duplicate]

Possible Duplicate: Must-read Books for DBA What books do you recommend for the aspiring DBA? Update: I'm particularly looking for sql-server and PostgreSQL books (though books geared towards ...
4 votes
2 answers
204 views

How to create multiple entries on index based on the fields of one row?

I never found a good way to index multiple fields of one row as entries of an index or simulate this feature on MySQL. The problem arises when you have fields working as tags or similar concept. Ex.: ...
Maniero's user avatar
  • 2,728
11 votes
2 answers
17k views

How to connect to another db using stored procedures?

I need to get some data from an external db and make some calculations with it in another db, is it possible to connect to an external db from a stored procedure? Thanks guys. PS. Im using Oracle ...
eiefai's user avatar
  • 1,874
6 votes
2 answers
859 views

Best practices to run time offset delayed replication

I want to setup replication system on postgresql like #1 MASTER SERVER and two replicated servers: #2 SERVER in realtime (for load balancing), #3 SERVER delayed with some time offset (for example 2 ...
TomaszSobczak's user avatar
4 votes
1 answer
7k views

Can a Wallet be used with SQL Developer? How?

I have a Wallet configured and working fine for SQLPlus. Is there a way to make it work with SQL Developer?
Leigh Riffel's user avatar
  • 23.9k
169 votes
13 answers
346k views

How can I move a database from one server to another?

How can I move MySQL tables from one physical server to another? Such as this exact scenario: I have a MySQL server that uses innodb table and is about 20GB size. I want to move it to a new server, ...
John's user avatar
  • 1,851
8 votes
4 answers
7k views

For a MySQL query, how do you determine physical and logical I/O?

I'm used to having a showplan in Microsoft SQL and have gotten lazy with using tools to tune MySQL queries. How can I determine physical/logical I/O for a query in MySQL? (EXPLAIN shows the index ...
David Hall's user avatar
  • 2,277
3 votes
1 answer
2k views

Is there a way to allow a proxy connection to use passed authentication in a public database link?

I think the answer to this is no, but I could be wrong. If nothing else it might be nice for others to be aware of this limitation of proxy connections.
Leigh Riffel's user avatar
  • 23.9k
13 votes
2 answers
8k views

Can Oracle be installed on Windows without being an administrator?

Can the oracle software be installed on windows without having administrator privileges?
Leigh Riffel's user avatar
  • 23.9k
12 votes
1 answer
564 views

Best practices for connecting DBs that are in different geographical regions

We are about to set up SQL Servers in different countries. We need to link them, but we don't have to have a direct link (as in linked server). In other words, they can be loosely coupled. Is it ...
IamIC's user avatar
  • 576
1 vote
1 answer
857 views

What does HSJOIN mean in an Explain Plan?

I have the following EXPLAIN PLAN results from a query on my DB2 database. 0 SELECT STATEMENT ( Estimated Costs = 5.928E+02 [timerons] ) 1 RETURN 2 HSJOIN 3 [O] ...
BenV's user avatar
  • 4,903

15 30 50 per page