When your queries are not very complex and don't involve joins to tables in different databases, the tuning wizard works great. I have used it hundreds of time and it...

I take it you didn't have to re-register the DLL? That would rule out any good software uninstallers removing the file. But also if the file was in use, there...

I suspect you have a group policy in effect that won't allow you to install non-verified software. See http://support.microsoft.com/default.aspx?kbid=822798 for more info

The big problem is the shrink will get rid of free space in all tables. So then when it does regrow you will have some slowness (as it grows) and...

I would recommend you setup a database maintenance plan. Enterprise manager has a nice wizard for doing this. Open enterprise manager, select your server, then go to tools and database...

First thing you should do is review your DW design. Is your fact table to granular? Can you do better summarization during ETL of the data to reduce the number...

I agree your trans log is way to big for the number of transactions. My 12GB dbs have 4gb trans logs with over 700,000 transactions per day. The size of the...

this may not be what your looking for, but I use the crystal report exporter, write a batch file and call it with the windows scheduler. You need .net framework...

I've played a little with this http://www.epsilon-logic.net/OfficeQB.asp they had a standard version freebie a while ago now its $49 for the pro. Has a little learning curve, but once you...

I also have my systems on a fast san, so I applied the hot fix and I haven't seen the problem since. I found other problems related to networking which is...

3.4 Gb is huge for 300,000 rows what type of data are you moving? Have you seen this http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B810885 and applied those hot fixes?

Maybe you could simplify the update and...

Do you have the luxury of being able to simply recreate the dbf files? If so my recommendation is to upate the SQL tables, then dts out new DBF files...

I always run into issues as I have to name objects with the absolute in non-techie user in mind. Most database naming schemas won't work for BI end users. When I am...

All 3 questions have 1 answer. It Depends.

1. If you OLTP server is maxed out (CPU, Memory, I/O ...) then yes buy another license for SQL server and setup...

We can hope. At least it was only a practice bomb right? I guess it proved its point, we need more practice.