Tag Archives: SQL server

Full-text searching allows more complex searches such as word or phrase searching, inflection matching, proximity searching, and relevance matching to be performed on many different fields within tables.  In order for these searches to run SQL server builds and maintains a catalog. We have such a large amount of data that rebuilding a full-text catalog can take as long as 14 days.  We needed a way to be able to bring the full-text catalog back without rebuilding it, essentially, I needed a backup.  Microsoft does not backup the full-text catalog…

Continue reading

I put SQL Server on a Windows Server 2003 virtual machine on my new 64-bit laptop but Enterprise Manager would not run.  After some searching, I found a guide that helped me fix the issue.  I had to change permissions on various registry entries in the HKEY_CLASSES_ROOT and then I had to manually register a few dll files.  Quite a number of services and processes had to be stopped during this procedure. New technology works well with new technology but new technology does not work well with old technology.  My…

Continue reading

I am always trying to learn something. I really enjoyed learning about programming yesterday and now I want to shift my efforts onto Microsoft SQL Server. I have an install of SQL server 2005 at school and I might have a copy of SQL Server 2000 at home. I plan to study and work with it for the next few months. I have one book on it and some lab manuals. I might order a few more depending on my interest. It feels good to be learning. Ian and I…

Continue reading

Richard Hale and I took my classes on a field trip to the Microsoft offices here in Cleveland for a SQL server event.  They gave us lunch at the event. It was nice to see the Microsoft facilities, but I was not overly impressed with the presentation itself.  The content was a little too technical for the students and the presenter's English was rough, making it difficult even for Richard and me to understand.  They showed a few charts without explaining the data which gave the impression that the data…

Continue reading