Full text indexing adds another dimension to your database so to speak. To use the full text indexes you have to use the keyword CONTAINS in your SELECT statement...

Since others have touched on what might be best practice or shared their opinions, I'll touch on another subject that doesn't seem to have been addressed.

Who has responsibility for the...

The OS plays a role in determining how much memory SQL Server will use. My experience has shown that SQL Server 2005 will use as much memory as it...

Kay Mohd (12/12/2007)

---

Question:

What kind of mess i'll be seeing in the future?

Can't GUID size indexing problem be solved with partitioning?

Can you suggest other alternatives to GUID, based on the above...