I would probably do...

SELECT SUM(NVL(qty,0))

rather than...

SELECT NVL(SUM(qty), 0)

...so to ensure individual Null values are summarized as zeros.

vrkumar01 (10/25/2010)

---

Hi Team,

i am very new to this forum.... we have SCOM R2 which monitors all our SQL servers which is quite ok and satisfied with the default SQL MP's.

today...

SQL ORACLE (10/26/2010)

---

For example, we have two indexes needed to build.

We can create these two indexes sequentially.

We can also create these two indexes at the same time.

Which approach is faster?

Any...

virpan_17 (10/26/2010)

---

I am using sql server 2008. I am building a website in ASP.net and querying my db. I have a table called "groups" and it contains 2 columns among...

Unfortunatelly there is not such a thing as a SQL Server - Oracle Magic Decoder Ring.

I would suggest to check alter system, alter database, alter session syntax and options.

John Rowan (10/22/2010)

---

PaulB-TheOneAndOnly (10/22/2010)

---

John Rowan (10/22/2010)The execution plan shows a clustered index scan and returned results in under a second. This tells us that you don't even need the...

ioani (10/22/2010)

---

I have following tables:

CREATE TABLE Item

(

ItemID INT,

Name VARCHAR(60) ,

CategoryID TINYINT,

Subcategory

)

CategoryID from Item is a foreign key...

John Rowan (10/22/2010)The execution plan shows a clustered index scan and returned results in under a second. This tells us that you don't even need the non-clustered index on...

ioani (10/22/2010)

---

Hi,

I have an entity named Item that has following attributes:

Item:

Name,

Category,

Subcategory

The database should enforce the following rules:

1.An item can belong to one of 3 categories;

2.A category can...

You certainly have a strong case for partitioning.

As you already pointed out partitioning is a great tool for archiving/purging purposes - the fact that you can switch a whole partition...

Lynn Pettis (10/21/2010)

---

Okay, we think we solved the problem, but don't ask me why; especially since we couldn't rebreak it.

Using Oracle's SQL Developer stored procedures and functions are by default...

Firstly... and not trying to hurt your feelings, as already pointed out by...

Welcome to the wonderfull world of troubleshooting 😀

Some of your "select into" queries is returning more than one row - either because of faulty data or faulty logic.

I would...

Lynn Pettis (10/21/2010)

---

One solution would be to put a contraint on the table to prevent a duplicate entry, unfortunately not possible at this time as we have multiple duplicate entries...

Where is the Package Header?

Where are the errors?

What's the question?