smunson (7/16/2008)

---

GSquared,

The reason I wasn't all that worried about performance is because this kind of fixing is generally a one-time event, and even if it took an hour, the overall...

smunson (7/16/2008)

---

There is a potential pitfall here, folks: Any time there are exactly X spaces between words, where X is greater than 2, you have a problem with...

Here's why I suggested what I did, with taking larger chunks first, then smaller.

create table #T (

String1 varchar(1000),

String2 varchar(1000),

String3 varchar(1000))

insert into #t(string1)

select 'A' + replicate(' ', (abs(checksum(newid()))%100)+1)

+ 'B' + replicate('...

Yes, we understand what you're trying to do. Unpivot and Avg will do what you need.

Break the calculations up.

Something like this might do it:

;with

Portions ([Type], Weight) as

/*

Replace this CTE with a table in the real app.

This is for proof of concept only.

These numbers...

You index a uniqueID column the same way you index any other column.

If it's the PK, it's indexed. The question is whether or not it should be the clustered...

I haven't had a problem with it.

You might need to set up some sort of table partitioning. If you had today's data in one partition and older data in another (or others), the indexes on...

You can use Unpivot (check it out in Books Online) to turn the row into a column, then use Where to dump 0 and null, then use Avg to average...

Somehow I doubt that Oracle defaults to dirty reads, so what...

Daryl, that one won't work if you have DateFirst or Language settings that don't make Sunday = 1 in the week. Too common and too easy to change to...

You'll need something like this:

select [Name]

from dbo.Actor

inner join dbo.Casting

on Actor.ID = Casting.ActorID

inner join dbo.Movie

on Casting.MovieID = Movie.ID

where Title = 'Alien'

That won't sort the actors. You'll need an Order By...

There isn't. You'll have to either create your own way, or upgrade to a higher license of SQL Server, or buy something that does this.

I had something like this happen on one server. Found out that the e-mail address had been stored in the Operators data as "[email:myaddress@mycompany.com]" (names changed to protect something...

You're going to be querying from a join between the tables. You say, "3 databases", does that mean these are in separate databases, or are they separate tables in...