I will certainly do from test server first.

But it would be good to know before hand, do I need to stop IIS before the upgrade, or I don't need to...

Thanks for all the help, I will think it over to see what is the best solution.

Thanks, for the convert of the reports, we may later spend time working on that.

For now, I would like to know if do a in place upgrade, because the database...

Thanks, that is what I think too.

Could you direct me to more examples that use coalesce in join?

I cannot find many examples about this, thanks much.

Thanks, it's very helpful

I'm query jobhistory table in msdb database. It stored the run_date as this.

I'm trying to create a query that to check if a job run or not yesterday.

Yes, thanks, much easier than what I have.

What was in my mind was datepart, so it come up to a rather complicated one.

Thanks,

So when I plan my next server, what is the best to do for hardware also considering the price of license.

What you do as DBA, to plan for your hardware,...

I see from right click system-property,

Processor: Intel(R)Xeon(TM) CPU 3.60GHz 3.60GHz(2 Processors)

Does this mean if I install SQL server on it, I need to buy two Processor licenses, that's...

I don't have wmiexplorer tool, is there an easy way to find how many physical processors ?

I did a search and found a one that queries SQL, but I...

Thanks for all.

And thanks for the link of the white paper, will download and read it.

Thanks, we do have a monitor server tool called ServerAlive for all network computers.

But I found it didn't catch up what we have for an issue recently happened on one...

Mostly people use database A is for analysis.

But sometimes they do need to do a little change to the database, for example add a view or sproc that they need.

Is there a way to do only schema backup, I mean exclude to backup data?

Lynn Pettis (10/17/2011)

---

Please remember that each differential backup backs up all changes since the last full backup.

If you are truncating all the tables and reloading each night it makes since...