Forum Replies Created

Viewing 15 posts - 421 through 435 (of 938 total)

  • RE: Searching Words and Phrases in a Rich Text Field

    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,...

  • RE: A Love Hate Affair with User Defined Types

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

  • RE: Katie

    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...

  • RE: Katie

    Hi Rex,

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

  • RE: SQL 2000 DBA Toolkit Part 3

    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...

  • RE: Everybody Reports to Somebody

    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...

  • RE: Everybody Reports to Somebody

    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...

  • RE: Everybody Reports to Somebody

    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

    #710524

  • RE: IF EXISTS query problem

    Your USE statement inside the IF should be in a separate batch.  I would suggest putting everything inside the BEGIN...END in dynamic SQL and use EXEC.  Try this (untested):

  • RE: The T-SQL Quiz

    "would it be a better way to pass a million rows to the client in a multi-user environment or do the calcs on the server and pass just the result?"

    For...

  • RE: SQL 2000 DBA Toolkit Part 3

    Hi Dave,

    I was able to confirm the issue and fix it.  I've resubmitted the recompiled binaries and the fixed source code to Steve and asked him to repost.  I also...

  • RE: The T-SQL Quiz

    Just be aware that FLOAT uses an "approximate" IEEE representation to store values (no flames please, "approximate" is from the ISO standard), and using it can cause problems - especially...

  • RE: The T-SQL Quiz

    PS How do you get the code to format in this editor?

    You either have to do it manually, or you might try one of these:

    http://www.simple-talk.com/sql/sql-tools/the-simple-talk-sql-prettifier/

    http://www.wangz.net/gsqlparser/sqlpp/sqlformat.htm

    Then copy and paste...

  • RE: The T-SQL Quiz

    I agree with your assessment that checking for "x % 3 = 0 and x % 5 = 0" is equivalent to checking for "x % 15 = 0".  "x...

  • RE: The T-SQL Quiz

    Gotta love those Monty Python references   "A what?  A grailllllll?!"

Viewing 15 posts - 421 through 435 (of 938 total)