Heh... thanks Steve... I'll consider it. It would be very difficult, though, because I break out in a bad case of Tourette's syndrome every time I try to do something...

True. The use of...

Better syntax:

Use NULL vs. a literal such as 1 or 'x' as in:

SELECT NULL FROM ...

Sample code using EXISTS that checks for the proper installation of the full-text filters for...

One of the major deficiencies of using a CTE for hierarchical queries is the inability to order the nodes. Contrast with Oracle's CONNECT BY ... ORDER SIBLINGS BY ......

Very nice tribute:

http://dannythorpe.com/2008/01/31/ken-henderson-1967-2008/

Ideally you should trim both leading and trailing spaces to avoid inserting an extra blank (or two) at the end of the passed in string.

Normally, all of this data scrubbing...

Numerous issues with this script. A lot of extra logic. It can be streamlined.

1. Why all the dynamic SQL?

2. The names of the views should be obtained from...

No, SQL Server doesn't conform to the generally accepted/ANSI standard that you must SELECT from "something" (table or view).

So you can just SELECT a constant. E.g., SELECT 'foo'; vs....

Update (JohnG): It appears that the posting (excerpt in the quoted text below) that I reference in my reply has been removed by the original poster after reading my...

Ensure that the statement immediately preceeding the WITH statement ends in a semicolon.

Try to get into the habit of using the semicolon as a statement terminator in all T-SQL code....

Take a look at your split function and ensure that it is matching what you are passing in.

Per your "Join" statement you are putting a blank after the comma. ...

TOAD is an independent product. Therefore, you have to work with the functionality that is provided by that product.

That said, yes, you can perform the same thing as SQL...

Set the maximum memory amount in both instances to something other than "all memory".

Otherwise both instances will be trying to take over all of the memory.

You don't want to be...

Consider the CONTAINS and CONTAINSTABLE vs. FREETEXT.

See the BOL for details. Also look at Hilary Cotter's articles:

http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

Your UI will need to provide either a radio button or separate fields...

Create a suitably named folder in your source control system

(Visual SourceSafe, Perforce, StarTeam, etc.)

You get:

1. Storage where others (your other DBAs) can access them

2. Backup of what you have developed

3....