I didn't bother, and I'm not going to.

declare @sample table (rowkey int, row1 varchar(50), row2 varchar(50))

insert into @sample

values

(1, 'dog', 'duck'),

(2, 'dog', 'duck'),

(3, 'dog', 'duck'),

(4, 'cat', 'cow'),

(5, 'cat', 'cow'),

(6, 'cat', 'mouse'),

(7, '', 'mouse'),

(8, ...

Some clarification please. You are apparently asking two different questions.

(1) What percentage of rows have been filled in for a particular column?

and

(2) What is the total...

Any opinions on just getting rid of say 40% of the data? If you're trying to get a hundred rows out of 150 million, cutting...

Did you ever stop to consider that if a product couldn't make it in the marketplace that maybe all the great performance increases you read about were just hype? ...

There's a Western Europe in your reality? It wasn't partitioned by the South African Empire and the Canadian Hegemony. Then invaded by the Kiwi Confederation?

Alvin, I keep trying to explain this to you.

DBCC TIMEWARP is fully documented... in approximately half the alternate realities in the multiverse.

Of course all the...

My alltime favorite from despair.com.

http://www.despair.com/gettowork.html

Interview question?

You're right, Gail, I was a bit sloppy this morning. May I blame it on lack of caffeine?

Since Stock.Status.ID was a primary key, I assumed there would...

One other variation:

;with cte as (SELECT TOP 10 * FROM Stock.Register ORDER BY Stock.Register.id)

SELECT *

FROM cte

INNER JOIN Stock.Status ON cte.stock_status_id = Stock.Status.id

Like Gail said, you really need to see the whole picture including execution plans to understand what is going on. But while you are doing that, could you...

You can use the OUTPUT clause with DELETE to save the deleted rows, like this. (You can use #temp tables or even permanent tables instead of the table...

Walton,

Please make a note of how Jim set up the problem with scripts to create and populate the tables. The volunteers who help out here...

They come in ONES?? :w00t: