This is still an issue. With years and eye sight deteriorating, even worse.

Anyone solved this ?

Grega

Why nobody is talking about going after these ransom people. 
Globally. 
Just get them and punish them severely. 
Instead of that, what happens ?
AV market rises. 
I wonder.

Hi.

I'm also interested in getting real CPU utilisation when more cores involved.

I would divide the reported % by number_of_CPU that SQL may utilize.

Okay, here's my ticket.

Once upon a time there was a song Bridge over troubled water.. by Simon & Garfunkel!

select row_number() over (order by bridge_id) as troubled_water_id, river

from rivers

Best...

Sory. I take my comment back. It works! My bug.

This doesn't work in MS-SQL 2005 where I created the example and PDF reader 9.00

> "I would be especially interested to know how Microsoft shops are using the product and how it helps their respective organizations."

We use SSIS as a main data-document interchange platform...

Well, I was not as satisfied with rownumber over order-by ..

I needed to enumerate 22mio records and over 3h didn't know wheather I'm on half way or no-way.

So I...