The name of the mdf/ldf in the restore are the physical names of the files of the database that was backed up. If you are restoring a database backup...

What I think he was asking, will the create index run faster after I run the query with the order by first.

If that isn't what the OP meant, he needs...

GilaMonster (2/13/2009)

---

Chris Morris (2/13/2009)

---

But what if he (or she) is only 18 and the only person for miles around who's got hold of a lappy and a copy of SQL...

Max (2/13/2009)

---

Does anyone know if it's faster to do "order by" before creating a clustered index?

ex)

select COLUMN_A, max(COLUMN_B) as COLUMN_B

into TABLE_B

from TABLE_A

group by COLUMN_A

order by COLUMN_A

create unique clustered index COLUMN_A...

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...