Good question!

For those who don't understand the implications of optimistic concurrency, fire up SSMS and do the following:

Window #1

---------

CREATE DATABASE snapdb

GO

ALTER DATABASE snapdb

SET ALLOW_SNAPSHOT_ISOLATION ON

GO

USE snapdb

GO

CREATE TABLE x (xId INT...

DB2's "CLR integration", as others have pointed out, is really nothing but a very loose interop wrapper. It's hardly "integration" in the sense of what SQL Server is doing,...

David,

DBAs can't continue to be just database geeks any longer. The DBA now has to be able to fill the role of .NET mentor and architect. See this...

It's interesting to note that CLR integration does NOT necessarily "[move] things from a set based model to a row by row based, procedural model." Indeed, I'm wondering how...

Personally, I am not a DBA. I consider myself to be a database-oriented software engineer. I act as backup DBA when our fulltime DBA is out or busy,...

Mom,

I'm a bit confused about how a DBA could make more than a .NET developer but less than a C# developer...?

FYI, a large percentage of C++ developers make less than...

You'll probably have much better luck in the 2005 newsgroups:

http://www.aspfaq.com/sql2005/show.asp?id=1

I saw Andrew's article -- I also wrote one about tracing for unused stored procedures, in the same issue of SQL Server Professional:

http://tinyurl.com/6ox35

So now we can find most-used and...

Parsing text for the data is not the way to go, IMO. I'm working on a solution to this on my end (this question is fairly common, actually), hopefully...

Anyone else thinking this might be a good candidate for an example of why display should be done on the client side and atomic attributes should be placed into their...

FYI, Beta 3 is not released yet. What you have is probably the October CTP, which was labelled "Beta 3". Subsequent CTPs, due to the confusion that one...

I have some ideas for this; can you more clearly define "utilization"? What, exactly, would you want to see?

A simple -- if naive -- approach, might be to take advantage of the fact that there are two spaces:

UPDATE YourTable

SET CityStateCountry = REPLACE(CityStateCountry, ' ', ', ')

WHERE CHARINDEX('...

It wasn't a shameless plug -- I would hope that no one would ever actually use it!

And if you need even MORE, you can use the large number libraries posted on my blog