I also would avoid RAID 50 for databases. Who recommended it? SAN vendors should have had enough experience with SQL databases to help you make a good decision,...

How would you split up the database?

Do you intend to have you application layer determine which instance to query based on some criteria?

Your data is in a star schema, do...

As Gail has pointed out, Active/Active is not a load balancing solution. An Active/Active cluster is actually two Active/Passive instances. If you only have a single database, you...

I usually rename or move the file first - sometimes to an additional folder. Then do the import. Finally, move it to the final destination folder.

That way, you...

Have you searched on "Package Configurations" in books online? The setup is a wizard, you should be able to follow their instructions.

It adds some overhead - I don't know how much.

Log shipping has worked pretty well for me in the past. I even had one place in which we had to FedEx the log files on tape to a...

Don't use MARS unless you program for it. If you do not actually program with the events being driven by data being returned to your recordsets, using it will...

You are getting an edition error. This basically means you are running a package containing a component that is only allowed on a higher edition of SSIS than what...

If this is a new install or you are upgrading from SQL 2000 or earlier, go with SQL 2008. The upgrade is essentially the same, it will save you...

The edition of SQL is really based on the features you need. If you want to use partitioning, online index operations, etc. use the Enterprise Edition. MS has...

If you are running Enterprise Edition of Reporting Services, this is exactly what data-driven subscriptions do.

You can set defaults in reporting services, but creating a "current date" calculated member and a named set is pretty useful.

For our cubes, the "current date" needs to be yesterday's...

I have done a couple of consulting jobs following guys like that. Eventually they do something horribly destructive and the company will have to pay someone to fix it.

That's quite the thread.

I think we need to devise a way in which we can shock people through their keyboards when they post something stupid.

I'm sure I would get shocked...