Have you had a look at Books online ?

most of the info should be in there

If you can't change the design or application. then you could change the hardware... I have seen some good performance improvements from using SSDs on badly designed databases, ...

setup regular t-log backups.

chetanr.jain (3/29/2011)

---

Instead of spending and purchasing 3rd party tool,

you can use SQL Profiler with selected filters to capture whatever changes is happening in the database.

since trace file can be huge,...

select * from sys.databases

]

you can use the un-documented DBCC log

dbcc log (dbname)

but good luck making sense of it, the structure is not designed to read by people.

you may be better off getting a...

Integration services for the server side.

Client tools or Business intellegence tools for the client side , sorry i am not sure of the exact name from memory...

I assume you mean SSIS.

This is availalbe on the SQL server setup disk, run the setup and select the correct tools.

It is not free (aside from the CTP...

The wording of that sounds like a brain-dump site. I take it this is not an offical MS link?

not sure...

That does sound annoying, those CDS are really useful.. maybe you could contact Microsoft publishing and see if they can send you a new one?

I wouldn't use an interface layer, you would have trouble getting this to work with a cube and you would end up developing everything twice.

My approach would be a...

looks like a stacked column chart, create it as you would any other chart and select the correct chart type

why do you need to create them dynamically?, is there a reason you want to do a loop?

if you have 10 tables with differing amount of columns, then this...

I am not sure that will work, ...