The CLR in SQL Server 2005

  • Article

Updated: Jan 2008. One of the big changes in SQL Server 2005 is the integration of the CLR into the relational engine itself. This is probably the biggest reason for the delays in completing the product and it is a controversial decision. Steve Jones spends a few minutes looking at the pros and cons of having the CLR integrated and possible implications for DBAs.

3.6 (10)

2008-01-25 (first published: )

143,079 reads

Inside SQL Server Development

  • Article

After the announcement last week by Microsoft that there would be no Beta 3 for SQL Server 2005 and that the CTP process would take over, Steve Jones had the opportunity to interview Thomas Rizzo and Allan Ros from the SQL Server development team about the CTP process and testing the SQL Server builds.


5,669 reads

Learning SQL Server 2005

  • Article

Everyone wants to get ahead of the curve with SQL Server 2005, but many people don't have the time or desire to dig through a Google search. Steve Jones has gotten quite a few requests for resources, so here is a compiled list of some places that might help you get started.

2006-09-08 (first published: )

44,939 reads

SQL Server 2005 Editions and Integration Services

  • Article

The SQL Server 2005 product family has now been announced, so with four editions available, what does this mean for SQL Server Integration Services? Starting from the bottom we have the free edition known as Express, and the entry level Workgroup edition, and neither include the full IS product. They have the Import/Export capabilities, but nothing more, so for simple loading and extraction of data this should suffice, but you will not be able to build packages.


4,009 reads

Comparison of SQL Server 2005 Editions

  • Article

On February 24th, 2005, Microsoft announced the new editions and pricing of SQL Server 2005. There have been quite a few changes and MVP Brian Knight has put down a comparison as well as details about which features are included with each. Read about the 4 new additions and see which one might be right for your next project.

5 (2)

2006-09-01 (first published: )

62,896 reads


Daily Coping 18 Sep 2020


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Optimize for Unknown for Inline Table-Valued Functions


I had a curious performance issue today. An inline table-valued function (iTVF) was performing...

Daily Coping 17 Sep 2020


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs


How to create a minimal tally table and to describe its advantages (if any)

By Steve Collins

What is the minimal way to create a tally table/tvf/cte and to describe its...

Need some help with log file


I have an issue with a log file which I am trying to solve....

Querying a table to get the columns with values

By mrodwell

Morning, i have a table with over 100 columns and i need to query...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers