SQL Server 2000 stores the full-Text index outside the database.  SQL Server 2005 stores the full-text index inside the database.  This means that when a SQL Server 2005 database is restored,...

Always a pleasure to read Mr. Poole's articles   One thing I noticed a while back is that Rules are deprecated.  From the BOL...

OK, the reason I ask is I was just wondering if you've considered moving to another location, possibly with more opportunity?  There are a lot of places hiring out here...

Hi Rex,

Where are you located now?  I saw a reference to Idaho in Katie's story, is that your present location?

Hi Conor,

I didn't compile it on x64, but the source code is available for download here: http://www.sqlservercentral.com/products/mcoles/default.asp.  If you download and compile the source code targeted for x64, I...

Here's a short CTE, assuming a table named #Employees with the data shown in the article:

WITH OrgChart (UserID, LastName, FirstName, ManagerUserID)

AS

(

    SELECT UserID, LastName, FirstName, ManagerUserID

    FROM #Employees

    WHERE...

Hi David and Craig,

The LeftID and RightID define a subset.  In the case of John, his LeftID=1 and RightID=24.  Anyone with a LeftID and RightID between these two numbers are...

Ahhh, ye olde adjacency list model.  You might get better efficiency from a set-based solution, like the nested sets model or one of its variants.  Here's an Q&D sample.

June 3, 2007 at 9:36 pm