When using the GUI for attaching a database, select the MDF file in the upper part, then delete the log file in the below part (the database details).

With which error did it fail?

+1

It's a system...

etl.laptop (9/26/2013)

---

Is there a set of guidelines and tools which can be used for testing if your ETL process does its job correctly ?

I was thinking in terms of...

Interesting, very interesting. Thanks for the question.

You need to create another table which stores all the dates between two certain dates.

For example all days between 1900-01-01 and 2050-12-31. You can add extra columns with year, month,...

Congrats!

spectra (9/28/2013)

---

Kurt W. Zimmerman (9/27/2013)

---

This is something I do all the time. There are several methods you can choose from. The first is a real simple method that...

I'm not 100% sure thas can be done easily in SSRS itself.

Might be possible with some .NET though.

dan-572483 (9/28/2013)

---

By "install SSIS" I mean the Integration Services checkbox in Setup.

So it sounds like it doesn't need to be on installed on the Database Engine server if a package...

The best approach would be to create a date/time dimension.

Using Date Dimensions for Reporting

Storing the dates as-is in a dimension or fact table is a terrible idea. As you have...

It's a logical operation, which makes it so fast.

More info:

How To Decide if You Should Use Table Partitioning[/url]

I'm no .NET developer myself, I just know the basics so I can script things in SSIS.

When I want to know something, I just google it and 90% of the...

BlackIceAngel (9/27/2013)

---

Thank you that looks like it might do the trick.

And no I'm not aware of the pitfalls of No Lock could you please elaborate?

Also what is a CTE. Is...

Which other approach?