Data Summaries(Histograms) in SQL 2005

Hello everyone,
My question is regarding some internals of SQL Server 2005. Does anyone know what kind of histograms are used for estimating query result size? I understand that this is a bit not T-SQL question but didn't really know where to put it :)

Any help is much appreciated.

Thanks,
Ando

Hi Ando,

Lookup BOL for DBCC SHOW_STATISTICS, this should give you the information you need (if I've understood your question).

If you need more details please ask.

Jamie

|||

Hello Jamie,
Thanks for your reply.
DBCC SHOW_STATISTICS shows some information about statistics. My initial question was about underlying data structures(type of histograms). There are limitless techniques, including some novel ones proposed by Microsoft Research. You can search "Query Estimation" on ACM portal for some articles. I was wondering-which one are they using in the SQL2005 :)
Thanks again,
Ando

|||

ah, okay then...can't help with that kind of detail :S

Although I'd also be interested to find out...I'll keep watching this thread :D

Jamie

Data Replication performance.

I'm seearching for information regarding database replication
performance. We need to compare the performance of replication for SQL
Server and Oracle and it is urgent! Anyone who can describe the
performance bottlenecks for each database when performing replication,
or can point me to a white paper or webpage.Hi Tobias

please have a look at the following link,

http://www.akadia.com/services/sqls...l#_Toc513865493

thanks
Shehzad

toby_one_canoby@.hotmail.com (Tobias Johansson) wrote in message news:<a64d0b53.0410010417.386d1fb6@.posting.google.com>...
> I'm seearching for information regarding database replication
> performance. We need to compare the performance of replication for SQL
> Server and Oracle and it is urgent! Anyone who can describe the
> performance bottlenecks for each database when performing replication,
> or can point me to a white paper or webpage.