There isn't a datawarehouse component per se. It looks like what you looking for is Analysis Services, SSAS. This can be used in developing a datawarehouse.

Actually, this will use 5 bytes. From BOL:

Numeric data types that have fixed precision...

Jeff Moden (5/27/2010)

---

Lynn Pettis (5/27/2010)

---

Jeff Moden (5/27/2010)

---

Heh... I remember not being able to do this type of stuff especially since UPDATE requires a bit of different handling than just a...

jcrawf02 (5/27/2010)

---

Lynn Pettis (5/27/2010)

---

Well, that treats the symptom, not the problem. What...

Our SIS database was using the BULK_LOGGED recovery model until a couple of months ago when I took over responsibility for the database. I changed the recovery model to...

Big question, why rebuild/reorg every index in the database everytime? If you search SSC you will find several scripts that will allow you to selectively rebuild/reorg indexes as needed.

This...

Gift Peddie (5/27/2010)

---

Lynn Pettis (5/27/2010)

---

Gift Peddie (5/27/2010)

---

That source did not tell you it is almost rocket science to install SQL Server 2005 in Windows 7 Ultimate if SSRS is included....

nigelc (5/27/2010)

---

i was thinking of doing the following to combate this

normal log back up at 12.00am

The maintenance plan runs after this

which is

Db check

Index re-org

Log back up - To...

I find it interesting when people want to stop the logging process because the t-log is just sooo big after a reorg/rebuild.

Nope. You might be able to switch to BULK_LOGGED recovery model during the index rebuild/reorg, but that isn't going to really affect the size of the t-log backup file.

Can't see what you see from here. Could you post the DDL for your tables?

I'm lost, what are you looking for here?

Full and Differential backups do not truncate the transaction log, that is only done by the transaction log backup.

Gift Peddie (5/27/2010)

---

That source did not tell you it is almost rocket science to install SQL Server 2005 in Windows 7 Ultimate if SSRS is included. I just did...

From what I have learned, the only service pack that requires the previous service pack to be installed first is Vista SP 2. According to a very well informed...