|
Navigation
Categories
Entries by Month
| October, 2008 (1) |
| September, 2008 (1) |
| July, 2008 (4) |
| June, 2008 (6) |
| May, 2008 (2) |
| March, 2008 (5) |
| December, 2007 (1) |
| October, 2007 (1) |
| September, 2007 (2) |
| May, 2007 (1) |
| April, 2007 (5) |
| October, 2006 (1) |
| July, 2006 (2) |
| June, 2006 (6) |
| January, 2006 (2) |
| December, 2005 (6) |
| November, 2005 (9) |
| October, 2005 (9) |
| September, 2005 (3) |
| August, 2005 (11) |
| July, 2005 (20) |
| June, 2005 (3) |
| May, 2005 (5) |
| April, 2005 (5) |
| March, 2005 (5) |
| February, 2005 (5) |
| January, 2005 (13) |
| December, 2004 (10) |
| November, 2004 (6) |
| October, 2004 (2) |
| September, 2004 (7) |
| August, 2004 (8) |
| July, 2004 (8) |
| June, 2004 (4) |
| May, 2004 (13) |
| April, 2004 (14) |
| March, 2004 (33) |
| February, 2004 (1) |
| May, 2003 (6) |
| April, 2003 (5) |
| March, 2003 (4) |
| February, 2003 (1) |
| January, 2003 (6) |
|
|
|
 Friday, September 17, 2004 Tuesday, September 14, 2004
Joel Spolsky mentioned that he is using the full-text search feature of SQL Server and that it required a manual job to re-index the database.
In fact, SQL Server 2000 will monitor a table for changes to a table that is included in a full-text index. The sp_fulltext_table procedure has parameters to 'Start_change_tracking' and 'Start_background_updateindex'.
As I wrote in Joel's discussion board, I have a script I could share that enumerates all indexes on a server and sets the change tracking for all tables in the index.
Wednesday, September 08, 2004 Thursday, September 02, 2004 Wednesday, August 25, 2004 Monday, August 16, 2004
When you're incapable of providing leadership or exercising good judgment, substitue an inflexible policy.
Bob Lewis, “KJR” Archive, 8/16/2004
Thursday, August 12, 2004
I often use a web page to convert C# code to VB to help me understand it. Sometimes, that is overkill when trying to understand a keyword or two.
MSDN has this page to help in this situation: Keywords Compared in Different Languages
A community site, Attune Systems, has the PowerSearch tool installed. Type “experts” in the search box (top-right for the unfamiliar).
|
|
Search
Further Reading...
Powered by: newtelligence dasBlog 2.2.8279.16125
The opinions expressed herein are my own personal opinions and do
not represent my employer's view in anyway.
© Copyright 2008, Paul Schaeflein
 E-mail
|