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


Are ABORT_AFTER_WAIT's victims logged?


In SQL Server, using the KILL command to terminate a session results in an...

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...

Read the latest Blogs


Backup with Checksum Show No Issues, While DBCC CHECKDB Reports Errors

By IT researcher

I took a backup with the CHECKSUM option, which was successful and showed no...

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....

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