Anirban Paul (10/21/2008)

---

As per your link:

A word breaker is a language-specific component that finds word boundaries based on the lexical rules of a given language (word breaking). Each word breaker...

The good news:

PowerShell is here!:)

The bad news:

PowerShell is here. Handle with care.:unsure:

My answer was "word breaker". Because I think that "stemmers" is part of Word Breaker, isn't it?

http://technet.microsoft.com/en-us/library/ms142541.aspx

(botton of the document)

Regards!

"...What are the units of the values...?"

Your question is about the units, and I think the UNITS are BYTES (as well if you talk about the units as gallons, liters,...

Miles Neale (9/23/2008)

---

Great Question. I got it right but for the wrong reason. After the explanation I see most people's point about the same not being the same.

I always thought...

Due is a tricky question I think both answers could be correct.

And I want my points back!:w00t:

Sergiy (9/4/2008)

---

I'd like to see how.

I guess I'm not alone here.

Same question - how?

I agree with your POV but both solutions are efective to insert a new record...

icocks (9/5/2008)

---

A further thing to bear in mind - if there's an Insert trigger on the table, then it will be fired in response to option 2, but not option...

Sergiy (9/4/2008)

---

Can you prove it?

Open...

MERGE is an alternative to reach the target -Insert a new row without duplicates-, but is the last alternative I would choose for this case.

You spend a lot of code...

I'm not completly agree with the answer, because depends of the context:

If you are looking for the best execution plan the answer is #1

If you are looking for less deadlock...

In case of different domains my solution was:

Create a local admin users in both servers with the same name and pwd.

Give access to the replication share folder to that user...

Try this:

CREATE PROCEDURE up_ToXMLFile

@FileName varchar(255),

@xmlText xml

AS

DECLARE @FS int,

@OLEResult int,

@FileID int

BEGIN TRY

EXECUTE @OLEResult = sp_OACreate 'Scripting.FileSystemObject', @FS OUT

END TRY

BEGIN CATCH

PRINT 'sp_OACreate (Scripting.FileSystemObject) fail. Try...

The answer 3 is correct also.

The right answer is #2 -ONLY-

The author of the question may be was drunk! (haha)