My main hobbies are Aikido and computer graphics.

After a day at work it's great to step onto the mat and forget everything except the partner you're working with and the...

The traceflag is mentioned in Books Online under configuring database mirroring

Turning off the rpc security didn't help. I was getting the error about not been able to enlist in the specified transaction coordinator until I made some changes in the...

Could you give us a little bit broader description of tables involved and what fields are unique?

Ideally you shouldn't put more than one value in a field (doing so...

update order_header set order_header.total_weight = TotalOrder.TotalWeight from (SELECT order_no, sum(weight) AS TotalWeight FROM order_lines GROUP BY order_no) TotalOrder where order_header.order_number= TotalOrder.order_no

Not tested, but should be more-or-less right.

awww.. not a concatenated list... that will be absolutely horrible to search through...

Search through? How about updating to remove a job. That goes...

You could check the syslocks and syslockinfo tables in the master database to see if there are any exclusive locks on the table in question. That would tell you if there's...

You don't. You normalise your database schema so that a single field stores a single value.

In your example use 3 tables. 1 to store details of the user. (id =...

Varchar - requires 2 bytes + the amount of characters entered per record. The two bytes is used to store the actual length.

If a field is defined VACHAR(5000) and I...

I'll add http://www.sqlskills.com

And don't forget the SQL Books Online. It's probably the best reference to SQL that you'll find.

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.