Lynn Pettis (10/8/2010)

---

We all know that in SQL Server that there is a system table that tells you about all the columns in each table in a database, sys.columns (in...

qaz123 90964 (10/9/2010)

---

I have a select statement in sql 2000, with the select on a linked server (oracle) table.

For example

select * from linkserver..dbname.my_table

in SQL 2000 reportedly caused locking...

Lowell (10/11/2010)

---

In Oracle, the NVL function is equivilent to the ISNULL function in SQL.

One of the wierd things in Oracle is that an empty string ('') is considered NULL, which...

dwmllr (10/10/2010)

---

Thanks for the response.

Your suggestion is an option. I was hoping to find a way to get around the SQL Server issue without cluttering the integration code. ...

Raghavender (10/11/2010)

---

Can we install different Editions of SQL Server, like SQL Server 2005 ent edition is one instance and SQL Server 2005 Std edition is another instance on one system...

Jeff Moden (10/10/2010)

---

PaulB-TheOneAndOnly (10/8/2010)

---

The focus of Oracle RAC is high availability...

There is...

Michael Valentine Jones (10/8/2010)

---

DEC Rdb was introduced with clustering similar to RAC in 1984. My assumption is that Oracle acquired a lot of the technology for RAC when they...

The focus of Oracle RAC is high availability 🙂

You can...

LAG() is actually a PL/SQL analytic function.

I agree IS_VALID_DATE() is a custom function usually coded like:

create or replace FUNCTION IS_VALID_DATE(pStr VARCHAR2, pFmt VARCHAR2) RETURN NUMBER

IS

vRet NUMBER := 0;

vDate DATE :=...

LadyRuna (10/8/2010)

---

I've gotten myself into an odd situation. A few months after an upgrade from SQL 2000 to 2005 (which I was NOT involved with), the customer comes back to...

grahamc (10/8/2010)

---

PaulB-TheOneAndOnly

since you have it running... does that mean if you have a RAC environment running, that if you are hitting performance problems that a shiny new server can...

grahamc (10/8/2010)

---

From my understand (mostly reading of forums, blogs and web articles) the Oracle RAC is mostly a marketing gimmick, nice to helps sell the product, but not really applicable...

It does indeed - surprised? 😀

Jeff Moden (10/8/2010)

---

GilaMonster (10/8/2010)

---

That's when you split a database across multiple servers so that each holds a piece.

RAC...