As David mentioned, SQL Server gets its time from the system. If you don't have your systems syncing time with some source, it is easy for this to happen. Also,...

It seems that everyone is talking about a similar thing here. Let's try to remain professional and respectful as we debate things. I had a few complaints that this was...

Wow, quiet a debate going on!

Brad, thanks for the break and a nice job on the editorial.

We all need to get "reset" at times, to have ourselves grounded back in...

Whenever you have a sourcing contract, you need to be sure you have this spelled out with the provider. If it's a small provider, you should also think about escrowing...

Just for this reason you never want to assign rights to public. Create new roles for every group of users.

As Brian suggested, check and be sure that this group doesn't...

The only issues I've heard of are people overloading the physical machine with VMs and then having IO or CPU issues. You can run 2000 in a virtual environment, just...

The limits change at times in versions, but to date I haven't heard anyone talking about reaching the limits.

you don't want to shrink it. You'll just grow it when you reindex again. You want to have enough free space to handle normal data change needs, including rebuilding indexes.

My guess is you need to contact a reseller and ask for pricing.

Or call MS. This page (http://www.microsoft.com/sqlserver/2008/en/us/purchase-options.aspx), shows (800) 426-9400

You do this the same as you do for a full backup, but you add the DIFFERENTIAL option

http://technet.microsoft.com/en-us/library/aa238405(SQL.80).aspx

There is a restart option for RESTORE. Not sure if it will apply for you, but you can try it.

http://technet.microsoft.com/en-us/library/aa238405(SQL.80).aspx

If I'm doing something small, paper or Visio work well. If I need to manage and handle changes to a larger database, I prefer ERStudio over Erwin. Haven't used TOAD.

Some good info here: http://www.microsoft.com/learning/mcp/sql/2008/default.mspx

I don't think there will be a lot of difference between these exams in terms of content. If you are working with 2008 now, take that...

There's no "best" in college. There are tiers of colleges, which are based on reputation and the networking you'll get, but for something as specific as DB research, I'm not...

a gee-whiz fiber optic laser beam assembler?:D