I use SharpReader (http://www.sharpreader.net/index.html) It's a standalone app. It has occational problems with the corperate firewall/proxy, but nothing serious.

Please post this in the performance forum, rather than here. This forum is just for discussions of the question of the day.

There could be a thousand reasons for slow performance -...

That sound like a pretty insane table design. What's wrong with storing all the data in one table with a date column? 

From what I read on the MS training site, the only upgrade exam will be to upgrade MCDBA to the new MC IT Professional: Database Administrator, so unless you have...

Weapon speeds? What the hell are weapon speeds? (coming from someone who started with D&D 3.0)

Pleae, don't let this deteriorate into a 2nd ed vs 3rd ed argument. There's better...

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.