Ms Support keeps on sharing a few on forums on case to case basis, other wise you may find them in personal blogs. And thanks to contributions from friends like...

Every flag that I add/edit in my list now on will sure carry sources along with.

Promise.

Will try to include that, though I'm not sure how many I can recall some of them have been taken offline.

Be posted, I'll add a few then and now as I find and test them.

Pleasured while sharing; it will be a privilege if you can share comments for something’s missing...

Yep just looking at the inside however was a little lazy & have someone scan the ?GAM for me. working on this script myself.

Thanks a lot I got it now.

Any handy script that you can refer to check sequence of pages which are free & used?

HDD real state is somewhere in futire and I can see extra 20 GB allocated to an MDF which is dearly needed by others. On the MDF SHRINKFILE doesnothng &...

In the build list, you mak like to check the link against 959195.

9.00.4211 961930 http://support.microsoft.com/kb/961930

Service Pack 3 Cumulative Update 2

9.00.4207 959195

You may like to see

http://www.sqlskills.com/BLOGS/PAUL/post/New-script-How-much-of-the-database-has-changed-since-the-last-full-backup.aspx

http://blog.sqlauthority.com/2009/05/09/sql-server-find-last-date-time-updated-for-any-table/

http://sqlblog.com/blogs/aaron_bertrand/archive/2008/05/06/when-was-my-database-table-last-accessed.aspx

CAn you do a dbcc sqlperf ('logspace') and check log space used & occupied & then try shrinking like

USE [YourDB]

DBCC SHRINKFILE ('YouDBlogFIle' , 0, TRUNCATEONLY)

If this fails to do...

You may like to take a look at this for trace flag 7646.

http://sqldev.wordpress.com/2008/09/16/sql-server-2008-full-text-slowness/

Any ideas where I can get Yukon_SP3_CU1 becasuse the HOT FIX web site is only giving Yukon_SP3_CU1_SNAC.