You're in luck this weekend if you can get away for a bit.

There is a weekend long Pass SQL Rally in your neck of the woods.

http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=782

Hire the appropriate staff and technologies to test, QA, and stage, before deploying, and also hire the appropriate staff and technologies to support your applications after deploying to production.

SQL Server 2008 introduces changes to the Report Definition Language (RDL), the report object model, and the rendering object model that affect reports created in earlier versions of the software....

Henrico Bekker (4/13/2012)

---

If you have enough disks, best setup would be:

Sys db's on own disk, but have tempdb on its own drive.

user db's on own disk.

split mdf and ldf's...

How new are we talking about here? You might want to start at wikipedia then work into books online.

http://en.wikipedia.org/wiki/Relational_database

http://en.wikipedia.org/wiki/Database_model

http://en.wikipedia.org/wiki/SQL

I really like the maintenance scripts over at:

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

Very flexible, and easy to use.

With that topography it sounds as if many of your databases might be replicated from a...

That's not a very good way to handle you tempdb files, but in this example sql server will still run, as long as there's someplace to expand the tempdb. ...

GilaMonster (3/2/2012)

During a disaster of the secondary site, can a restore be done on the secondary independant of the primary, or will the secondary site need to wait for a...

Sorry for the spray of questions.

Would this allow statistics to be generated on the secondary?

Can the secondary have indexes that the primary does not have?

During a...

I'm getting great compression on my datadomain device using 2008 native compresson. The backup and restore times are faster as well.

Yes I read the whitepaper, but testing in my...

How big are these databases and what kind of work(type and load) do they have?

I've seen way more than 10 per instance in production on 32 and 64 bit machines.

I'd start with an mdf an ndf and a log file. But you should always test, not just for performance but for sizing. The nice thing is you...

Are all drives accessable? Is compression turned on for any of the locations? What do the error logs say?

Also

http://www.sqlservercentral.com/Forums/Topic142662-5-2.aspx

http://support.microsoft.com/kb/224071

Where is the current tempdb? Is there enough space for it? How big is it? Is it set to autogrow?

Don't assume it's stable and everything is good.

http://www.brentozar.com/blitz/