what does select @path return?

If @path is null the string returned from the concatenation will be null if SET CONCAT_NULL_YIELDS_NULL in ON.

Maybe this will help.

When you backup your database, HomeDesignDB, the backup file contains the physical location and filenames of the mdf/ndf(if present)/ldf files. For example D:\Databases\HomeDesignDB.mdf, D:\Databases\HomeDesignDB.ldf.

When you restore...

Chris Morris (2/13/2009)

---

Heh yeah I...

Here is a solution, based on the article everyone mentioned and is also listed below in my signature block.

create clustered index IX_RunningBal on #temp (

budget asc,

...

First, I got my degrees to fill in the boxes while looking for work in my chosen career field. Plus I enjoyed going to school and learning.

I will agree,...

Chris Morris (2/13/2009)

---

Lynn Pettis (2/13/2009)

---

Not saying this is true of all PhD's, but many of the ones I have met seemed to have lost one very important thing, common sense....

Why do you think it is only storing 8K of data?

Could be, of course, that common sense isn't all that common.

Not saying this is true of all PhD's, but many of the ones I have met seemed to have lost one very important thing, common sense. Is there a...

Actually, I think we need an emoticon for sarcism. Know of one?

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.