The Ji Village News

Author: Haidong Ji

  • desc is sp_columns in Sql Server

    In Oracle and MySql, to get the column name and data type of a table, you can use: desc MyTable or describe MyTable The equivalent of desc in Sql Server is sp_columns. Therefore, run the command below will get similar results: sp_columns MyTable

  • 读保罗-麦卡特尼的新闻有感

    This entry expresses my own opinion. It could be interpreted by some as political. Read it at your own risk 🙂 Paul McCartney and Heather Mills McCartney are in tabloid headlines lately. Their high profile divorce has captured the imagination of many people, especially with Heather’s alleged allegation of abuse and account of her exploits…

  • 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…