DTS/SSIS

You can't. You can only delete a record if you can identify it. (At least in sQL 2000. In SQL 2005 the DELETE TOP 3 ... might work.)

Your best bet...

A developer that codes a view as SELECT * FROM [Very Big Table]...that is what does not belong in the IT environment

True, but neither does a DBA who assumes that...

Yeah, I guessed much that. I like to give the .NET develpers here a hard tme too, even though I'm also classified a developer

REPLACE(@str,'''','''''')

Works in SQL 2000, can't say about 7.

BoL also says the following:

Indexes can be created on either a single column or a combination of columns in a table and are implemented in the form of B-trees. An...

One minor comment on your superfluous indexes...

If you have an index on a,b,c then a second index on a is indeed a waste of space and time. The index on c...

You don't like developers do you? Personally the idea of chastisng a developer because they don't agree with you strikes me as arrogance that really doesn't belong in an IT...

Table-valued functions may also be used in the from clause

SELECT blah FROM dbo.SomeFunction(@Param1, @Param2)

In addition to the restrictions already listed, functions cannot have any side effect. Hence you cannot insert...

Thanks, interesting reading (the entire article)

I'm tending to suspect there's a problem with the disk system (though the SAN people disagree, naturally). The server's not short on memory, got 48GB...

Converting that many records shouldn't fill TempDB.

Try a restart of SQL (assuming that this is not a production system and you can restart SQL without impacting users) as a...

What error do you get? It might be because there are non-numeric values in the column.

Try this

SELECT SUM(CAST(col AS FLOAT)) FROM tbl WHERE ISNUMERIC(col)=1

Looks like your problem is lack of available hard drive space.

You said you had 16GB free of 19GB on drive C, but the tempdb is on drive C and...

In the interests of keeping all relevent info in one thread, see

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=238067

I can't see pictures that are on your hard drive. Please post the results of sp_helptext in text.