Okay. That is why I am concerned about the log truncation just before running the full backup.

Starting with the full backup taken Sunday night/Monday morning with transaction log backups hourly until the full backup taken Monday night/Tuesday morning als followed by transaction log backups hourly.

If you...

Here is my concern about the above. Scenerio setup: Nightly full backup with transaction log backups hourly between full...

There is no updated table. Please, don't tell me who the vendor is, as I don't want to know.

carlos cachulo (2/12/2009)

---

Start from the begining

2 DATABASES - MANDIFLEX and PRODIFLEX

MANDIFLEX has this tables TABATOPCO and TABAT

PRODIFLEX has the table ST

TABATOPCO and TABAT can me joined by this fields...

Roy Ernest (2/12/2009)

---

Grant Fritchey (2/12/2009)

---

GilaMonster (2/12/2009)

---

Eeep..

http://www.sqlservercentral.com/Forums/FindPost655667.aspx

I want to do a PhD in the area of database optimisers. Can anyone suggest a good topic?

Gees, it took me months of reading to...

No. You could still...

I have rewritten your first select query below. Next question, however, is how does this query relate to the other table, tabatopco.

What would really help is if you would...

carlos cachulo (2/12/2009)

---

hello the query returns

Server: Msg 156, Level 15, State 1, Line 3

Incorrect syntax near the keyword 'from'.

i´v tried this

update tabatopco set u_nconsumo=1 where (select ref,u_nconsumo,cod_art,desc_art

from...

Bert (2/12/2009)

---

jcrawf02 (2/12/2009)

---

Bert (2/12/2009)

---

I've intentionally held back here because I've been blasted on this forum before. But since you asked, here goes. While I'm not a Scientologist, nor...

GilaMonster (2/11/2009)

---

I can think of a couple...

GilaMonster (2/11/2009)

---

I can think of a couple...

You've got to be kidding me....

Bob Hovious (2/11/2009)

---

Steve, what do you do if they are unwilling, or unable, to take the hints?

Sometimes giving an example in code is the easiest way...

As Sergiy said, read BOL.

[font="Courier New"]

Column name Data type Description

id ...