Robert Pearl


SQLServerCentral Article

Full Text Search Follies

Are you considering upgrading from SQL Server 2000 to SQL Server 2005? Are you using Full-Text Search? One of the top SQL Server consultants in New York walks us through an interesting issue that you might want to consider before migrating your databases.

(17)

You rated this post out of 5. Change rating

2008-01-18 (first published: )

15,070 reads

SQLServerCentral Article

Installing and Upgrading to SQL Server 2005

If you have not had the chance to work with SQL Server 2005, or even if you have, Robert Pearl brings us some important information about what your upgrade or installation of the next version of SQL Server will bring. This is information every administrator needs to know to get prepared.

(10)

You rated this post out of 5. Change rating

2008-01-11 (first published: )

199,286 reads

SQLServerCentral Article

A Bit About 64-bit

64-bit SQL Server is coming!! Are you ready for this new technology? Chances are most of you are like us in that you've never had a 64-bit machine around and you likely don't remember the transition from 16-bit to 32-bit. Do you even want to make the transition? Is it worth it? New author Robert Pearl brings us a first look at how the 64-bit version of SQL Server will differ from the 32-bit version.

(6)

You rated this post out of 5. Change rating

2007-09-22 (first published: )

29,377 reads

Blogs

AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared

By

Both SQL Server and PostgreSQL are moving fast into AI territory — and if...

Monday Monitor Tips: AI Alert Analysis

By

We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...

From SQL Saturday to Day of Data

By

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

Read the latest Blogs

Forums

Install SQL Scripts via GUI Wizard

By Jörg

Hallo all! My problem is this: I have quite a bunch of TSQL scripts...

Converting Money

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Converting Money

non ascii columns in a utf-8 .txt file

By stan

hi, we couldnt get our upstream data source developers to supply what is sometimes...

Visit the forum

Question of the Day

Converting Money

Does this run successfully on a SQL Server 2022, US English default installation?

DECLARE @YenAmount MONEY;
SET @YenAmount = ¥1500; 

SELECT @YenAmount AS RawValue;

See possible answers