You can't. Add datafiles on other drives.

Usually you are going to see a trade of in between "faster" and "safer",...

ksnandhinee (12/15/2008)

---

Restore ---> For replacing any particular file in the database, we go for the backup data(which is a stored file). Replacing a file from the stored backup represents as...

Ian Yates (1/31/2008)

---

Certainly linking your foreign keys to primary keys only helps with understanding and self-documenting of the database. You should at least have a primary key on the...

Steve Jones - Editor (12/10/2008)

---

Do you know how to write a trigger?

If you do, then an audit trigger just inserts changed data into some table. There are articles here on...

I'd the opportunity of doing it both ways e.g. from Oracle to SQL Server and from SQL Server to Oracle.

When it comes down to code here is how it works....

In regards to your first question and since you are looking for binary sort order, please follow previous advise and check sort order is in the *_BIN form.

Answering your second...

Cool! That makes sense, glad you solved it. Congrats!

smacena (12/4/2008)

---

Hi, I'm trying use this clause in WHERE:

...

WHERE

CASE :Hist WHEN '2'

THEN (PERSON.DATE is null or PERSON.DATE is not null)

...

Please do this, get and post execution plan for both "select count(*)..." and "select count(your-pk-column)..."

Toad is pretty bad managing sessions, it usually leaves connections open.

My first suggestion would be to test the connection from SQL*Plus.

If the issue persists try issuing a commit even if...

well... that's the expected behavior.

Are you expecting SQL Server to load balance your objects accross the filesystems?

It would happen on Oracle+ASM environment but as far as I know SQL Server...

Do you really mean "database partitioning" like in a distributed database environment or are your just referring to partitioning a couple of tables?

I have to disagree. Performance in a non properly maintained database keeps deteriorating...

just to be sure... you did an upgrade in place, didn't you? meaning, neither moved to...