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.

4.59 (17)

You rated this post out of 5. Change rating

2008-01-18 (first published: )

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

4.4 (10)

You rated this post out of 5. Change rating

2008-01-11 (first published: )

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

4 (6)

You rated this post out of 5. Change rating

2007-09-22 (first published: )

29,357 reads


Part 2: The Modern Azure Data Warehouse – ADF and ADLS


In today’s data-driven world, having the right tools to manage and process large datasets...

A New Word: Flichtish


flichtish – adj. nervously aware how much of your self-image is based on untested...

Automating Container Image Builds with Docker Build Cloud and Github Actions


In a previous post we went through how to use Docker Build Cloud to...

Read the latest Blogs


Realities of Predictive Analysis

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Realities of Predictive Analysis

Linked Server Product Name?

By Brandie Tarvin

Just came across something weird. Was wondering if anyone else has ever seen this....

Can index fragmentation cause the database to enter suspect mode?

By IT researcher

My database was in suspect mode, and when I checked using DBCC CHECKDB, it...

Visit the forum

Question of the Day

Creating Statistics on XML

I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?

See possible answers