The Ji Village News

Category: Technology

  • 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

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

  • PASS Reports 20061116

    It is good to be at PASS Sql Server conference in Seattle. Most people here have this kindred Sql Server spirit. Since we all have this in common, it is easy to start a conversation with pretty much anybody. All you need to do is to smile, greet each other warmly, and share your own…

  • At PASS conference in Seattle

    After 2 hours of flight delay, I’ve made it to Seattle. I am attending PASS Sql Server conference here. No, not the P.A.S.S. above. (I got that picture from a place not too far from where I work in Chicago area.) The PASS I am talking about here is Professional Association for Sql Server. I…