-
Some autumn and winter 2006 pictures
Fall colors at Brookfield Zoo Fall colors at Morton Arboretum Snow, Oak Park, Illinois Not sure what the red tree fruit/nut is called The old way of farm life on display at a children and craft fair in a town north of Waco, Texas, during Thanksgiving. Some of it is pretty similar to what I…
-
Troubleshoot Sql Server cluster and ClusterRecovery
With some San disk configuration and drive letter changes, a two-node 64-bit Sql Server 2005 cluster on Windows 2003 boxes would not start, as evidenced in Cluster Administrator. Here are some errors in Event Viewer: Sql Server application error in Event Viewer [sqsrvres] OnlineThread: Error 435 bringing resource online. Sql Server Agent [sqagtres] CheckServiceAlive: QueryServiceStatus…
-
Quick script to rebuild full text search
Below is the script I learned while in Seattle attending PASS conference. Some guys from Microsoft helped me to rebuild full text index on some SharePoint databases I manage. select * from sys.fulltext_catalogs sp_configure ‘show adv’,0 reconfigure — Get the fulltext catalog name to rebuild select object_name(object_id), * from sys.fulltext_indexes select * from docs where…