So tempdb grows in process of converting ...

Try to insert less records and measure growth of tempdb.

In such cases I'm usualy make such tests:

__________________________________________________________________

Records | Growth| (usualy time - to...

Thanx.

I like this approach. Very simple, but I didn't even think in this way.

When you click on table you see rough result:

EM do this so:

SELECT

SO.name

,SI.rowcnt

FROM

sysobjects SO

JOIN sysindexes SI ON SO.id = SI.id AND SI.indid <2

WHERE

SO.xtype = 'U'

It's...

I supposed locking,but you say that query fills tempdb.

What kind of query? And why tempdb is used?

Subselects? Large UNIONs? Views in query?

Did you compare estimated execution plans on both...

Something wrong in this kingdom.

Is it joke?

For what reason such a meaningless article?

My mark - 0. Or even -2.

Good article.

It's not about everything, but can be extended if needed.

I think about implementing such thing on our customers servers.

I will extend settings table, maybe we'll write GUI and it...

>>but when you step up to 4 or 8 way then Opteron leaves XEON in the dust

I'm agree. 4-way is very good. But finger me on a 8-way Opteron.

I've found only mentions about prototypes,...