I prefer to use SELECT NULL vs. SELECT * or SELECT 'x' or SELECT 1 for my existance tests. Selecting a NULL is a bit more indicative that nothing is...

See my response http://www.sqlservercentral.com/Forums/FindPost754136.aspx

to thread http://www.sqlservercentral.com/Forums/Topic751882-361-1.aspx

Note that we are using GUIDs exclusively for most of our PKs. Very similar to your application. It gives us a lot...

In order to cast a text string to the XML datatype, the text string must be valid XML. The text column that is returned from sys.dm_exec_sql_text is not XML.

See...

Found the fix! I.e., RTFM

After installing the PDF iFilter, it is recommended that you set your system PATH environment variable to the "bin" folder of the "Ifilter" installation.

For 64-bit...

You should be able to full-text index varbinary(max) data that is pure "text". Just specify a value of "txt" for the companion file type column.

I don't know if the...

Database size issues aside, as that is a business / environmental issue, I would still give the Adobe iFilter a try.

We are a SaaS-based company, hosting databases for our customers....

None that I've found. We use XML extensively as a transport mechanism (i.e., to eliminate an extensive list of scalar parameters and/or...

See my post 768830 which has links to other Full-Text resources.

http://www.sqlservercentral.com/Forums/FindPost768830.aspx

First off, you should install the 64-bit version of SQL Server 2008 on a Windows 2008 64-bit server.

Secondly, SQL Server 2008 SP1 has both a 32-bit and 64-bit version as...

You can't. It is a bug (of sorts). See the Microsoft Connect entry (265956): https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=265956

Please vote and enter your comments.

See post 774356 for a list of Microsoft white papers on XML to read.

http://www.sqlservercentral.com/Forums/FindPost774356.aspx

Don't use OPENXML! Use XQuery. See:

http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/01/20/stop-using-openxml-please.aspx

It depends upon what you wish to do with the XML. Just store it, "shred" it into a relational structure, etc.

In addition to the documentation in the Books Online...

Create a full-text index and use CONTAINS to search the contents of a binary file. However, you'll need to have a separate column that contains the file type (e.g,...

Thanks to all of the contributors to my post.

Yes, I DO have...