Jack Corbett (1/8/2010)

---

But wouldn't using CONTAINSTABLE(table, *, N'123 AND Apple AND Street AND FL AND 33647', 50) do the same thing as adding a column to Full Text on...

I think you just need the STDistance method. The following will help you:

http://blogs.msdn.com/pekorica/archive/2009/03/16/calculating-a-distance-between-two-point-of-interest-using-sql-server-2008-geography-data-type.aspx

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-2008-proximity-search-with-th

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

Please try to be more clear in your first post next time. Thank you.

DECLARE @data TABLE (test_id INT PRIMARY KEY, gender TINYINT NOT NULL CHECK (gender BETWEEN 1 AND 2));

INSERT @data VALUES (1,1), (2,1), (3,2);

SELECT

test_id,

male = CONVERT(BIT, gender - 2),

female...

I agree with Lutz that you are fighting a poor database design here, however:

DECLARE @Cogs TABLE (company_id INT PRIMARY KEY, cogs INT NOT NULL);

DECLARE @Sprockets TABLE (company_id INT PRIMARY KEY,...

Thank you for your valuable contribution 😛

Using Updategrams to Modify Data in SQLXML 4.0

You might not want to full text index each column: full text search works best when searching over the 'full text' 😉

One approach would be to full text index a...

...and if you don't want to remove the duplicates, use UNION ALL rather than UNION.

The way I read the article, the question was whether rolling back a transaction would also roll back any writes to the snapshot. This is quite different from suggesting...

Gah! I went back seven pages (at 50...

It is the checkpoint process, waiting to service the next checkpoint request. Totally normal and nothing to worry about. See http://msdn.microsoft.com/en-us/library/ms179984.aspx for a description of the wait types...

timothyawiseman (12/29/2009)

---

I am curious, why would you want to do this instead of (temporarily) taking the database off of read only status and updating the SIDS and then returning it...

TheSQLGuru (12/24/2009)

---

there was a massive thread here on sqlservercentral.com recently dealing with string splitting IIRC that had some amazing benchmarks involving all kinds of solutions. One of the things...

Jacob Luebbers (12/23/2009)

---

Paul White (12/14/2009)

---

...Because of the complex linguistic rules applied when comparing strings using Windows collations (which are always used for unicode data), comparisons typically use 20-40 times as...