Viewing 15 posts - 421 through 435 (of 938 total)
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,...
July 24, 2007 at 6:19 pm
Always a pleasure to read Mr. Poole's articles One thing I noticed a while back is that Rules are deprecated. From the BOL...
July 23, 2007 at 5:41 pm
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...
June 5, 2007 at 7:50 pm
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...
June 4, 2007 at 11:31 am
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...
June 4, 2007 at 9:21 am
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
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):
June 1, 2007 at 8:13 am
"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...
May 31, 2007 at 7:53 am
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...
May 30, 2007 at 8:26 pm
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...
May 30, 2007 at 12:02 pm
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...
May 29, 2007 at 9:37 pm
I agree with your assessment that checking for "x % 3 = 0 and x % 5 = 0" is equivalent to checking for "x % 15 = 0". "x...
May 29, 2007 at 9:12 pm
Gotta love those Monty Python references "A what? A grailllllll?!"
May 29, 2007 at 9:06 pm
Viewing 15 posts - 421 through 435 (of 938 total)