fatish.scott (9/12/2012)

---

I'm receiving this error message ""ORA-00933: SQL command not properly ended' when trying to execute the following sp against Oracle link server

DECLARE @sql NVARCHAR(4000)

SET @sql = 'SELECT * FROM...

And minimize any logic in the triggers. They have to be fast and accurate. Remember, if the trigger fails so does the transaction that fires it.

Lynn Pettis (9/11/2012)

---

Here is a bit of code that returns what you are looking for:

declare @TestDate date = '2012-09-11';

with SevenRows(n) as (select row_number() over (order by (select null)) - 1...

Luis Cazares (9/12/2012)

---

In 2005 there are TVF (Table Valued Functions)

There are not Table Value Constructors.

Is that what you meant?

It can be fixed by

declare @TestDate date = '2012-09-12';

with SevenRows(n) as (

...

You need to remember that indexid = 1 is the clustered index, which means the table and the data itself. You can lose data and you need to be...

That is up to you. Personally, unless the CU addresses a problem that I need to resolve, I don;t apply them. CU's do not (or at least didn't in...

Plus, we only have part of the problem. We should wait for the other shoe to drop and see how this is going to be used in the procedure....

GSquared (9/11/2012)

---

Lynn Pettis (9/11/2012)

---

Here is a bit of code that returns what you are looking for:

declare @TestDate date = '2012-09-11';

with SevenRows(n) as (select row_number() over (order by (select null)) -...

Here is a bit of code that returns what you are looking for:

declare @TestDate date = '2012-09-11';

with SevenRows(n) as (select row_number() over (order by (select null)) - 1 from (values...

simon4132-806507 (9/11/2012)

---

Hi,

Simply because it works.

'if it aint broke don't fix it'

This is a heavily used production system. To upgrade you have to pause mirroring and disconnect the mirror. If we...

oscarooko (9/11/2012)

---

So you saying even though I have a the criteria LogTime < @dCutOffDate and an index is defined on LogTime, it still will NOT be used?

Any ideas on what...

CELKO (9/11/2012)

---

The short answer is that this is a running total problem which can be done with the SUM () OVER (PARTITION BY ..

ORDER BY...

My question is why do you want to keep the production system at SP2?

The DELETE will be doing a CLUSTERED INDEX (i.e. table) scan. It won't use the index on LogTime.

Just so you know.

Appreciate you telling us what indexes are defined, but it would be nice to see the actual definitions.