Yes

SSIS, bcp or T-SQL scripts to transfer the data over. Probably...

ChrisM@Work (3/5/2014)

---

If I script out the nc index containing the cluster key as an include column from the code I posted above, the cluster key column still shows in...

Edvard Korsbæk (3/5/2014)

---

Next step was, that he used 'Tivoli' to restore from the old DB to the new db - And that went wrong. It was the old db that...

Files/filegroups cannot be moved from one database to another.

Not 'cannot be specified twice', actual 'cannot be present twice', so precluding SQL putting a column...

That's not very useful 🙁

A DB won't go into the restoring state by itself, someone has to run a command to do so.

RESTORING or RECOVERING (important question)

Error log, from Object...

What was the backup command which you ran? What options did you specify?

RESTORING or RECOVERING?

Any entries in the SQL error log relating to this DB from about the time it...

Exactly.

A column cannot be present in an index twice. If a column is explicitly specified as part...

CREATE TABLE ReallyStupidTable (

ID CHAR(100),

OtherID INT

)

GO

CREATE UNIQUE CLUSTERED INDEX idx_Silly ON ReallyStupidTable (ID)

GO

INSERT INTO ReallyStupidTable (ID, OtherID)

SELECT ANumber, ANumber FROM (

SELECT TOP (5000000) ROW_NUMBER() OVER (ORDER BY...

No. Since the transaction (the index rebuild)...

Why do you...

My preference is to run queries/procs I'm testing multiple times and ignore the durations/IOs of the first result, rather than clearing plan and data cache after every single execution.

ChrisM@Work (3/5/2014)

---

If a multi-column clustered index includes a GUID, a nonclustered index which incorporates that same column either as a key or include column is going to be significantly...

No.

No, exactly...

Jeff Moden (3/4/2014)

---

Almost forgot. The log file won't shrink past the last VLF currently in use. It is sometimes necessary to first take a backup of the database...