And I also found out these kind of article focus how to troubleshoot, and more practical, vs bookonline is just like a library, and collection of rules, but didn't teach...

Thanks, but the sys.databases and sys.tables and sys.indexes, they are the new sys view, aren't they?

Thanks,

when you say: You need to filter all the unique constraints from that report.

How can I do this?

By the way I'm reading and learning from this article:

http://www.sqlservercentral.com/articles/Indexing/74510/

Thanks,

I mean is this tool needed to be install on the machine that needs to do the windows update?

Or can you briefly explain how this tool works, comparing with that...

Is WSUS a tool needed to install on the server that need to be updated?

or where should I install the tool?

Thanks a lot.

Thanks.

When you say bulk-logged recovery, I guess during the weekend maintence job, I can first change from full to bulk-logged recovery, then do the reindex, then change it back to...

Thanks, and what is the difference between native client and ssms?

One of the site collections in the web application is to archive district documents and photos. It makes the database grow quickly

Thanks, we are using MOSS 2007 sharepoint server.

I guess Ignacio A. Salom Rangel 's idea about creating a new content database may be a good idea.

I just concerned if the...

That's only mdf file. We do have transaction log backup too.

Thanks,

but sorry I provided wrong information.

The database now is 116 gb, and it gorws 6 gb every week.

Thanks, that makes much sense.

I recreate my query use 'the one to many' the one side table as the first table before join, now there is n o duplicated records.

I didn't use union or union all in my from clause.

It's 3 joins with primary keys with other tables.

Yes, so in the case we do need a restore from a full bk, a dif, and a series of transaction backup,

I would prefer to use SSMS to...