If I recall corrently, the default fill factor is 80% (going purely on memory here).

I'd recommend Murach's (publisher) book SQL for SQL Server. It is a good introduction to T-SQL (less t-sql administrative stuff like system tables, it is mostly how to query a...

One thing that deffinitely keeps interested in my current job is that they pay for 100% of graduate school. It ammounts to something like $10,000 per year. Not a bad...

Check out http://www.sqldts.com/ for info on making packages more portable. Also, check out the Disconnected Edit feature. It makes it much easier to change some DTS settings like connection objects,...

Check out Microsoft's site: http://www.microsoft.com/learning/default.mspx. They'll answer all of your procedural type questions about the exams.

The absolute worse example I've ever seen was Legato Networker. I went to their headquarters for 10 days worth of classes (three seperate classes for Legato Certified Specialist). One whole...

I used to have (at a previous job) an Active/Passive cluster that Log Shipped a database to another Active/Passive cluster.

The Log Shipping (on Enterprise Server) is all through SQL...

But if you want the SQL Virtual Servers to be able to fail over between physical nodes independantly (and otherwise, why cluster), they will each need their own IP addr....

If you're installing on a cluster, SQL Server 2005 probably will need its own IP address. Every SQL Server 2000 virtual server in a cluster requires an IP address.

There's a check box in the SQL Server Registration that specifies show system databases and system objects. Check that, but otherwise it may be a permissions issue.

I read a lot of books a year as well. I guess that's a good thing, because since I started Graduate school (working on a MS and a MBA) that...

I don't think that you are expecting too much. These are all things that were covered when I took the SQL Server 7.0 Admin class (I never took the 2000...

So is the answer Milliseconds or Microseconds? I answered milliseconds and got it wrong, but the explanation says

" Each tick on the operating system is 31.25 milliseconds"

I've always found RGR'us (or Remi, etc.) to be extremely helpful. I think that the problem is that it is EXTREMELY eassy to get the basic help you were looking...

I don't think that a backup and restore will do it. You'll probably have to rename the existing tables, create a new table on the new filegroup, then copy the...