NHibernate, Views and SQL Server

Hi there,

First thing off, I'd like to know what Views are useful for? I thing it can speeds select query containing multiple join, but I'm not even sure if that's true.

Second, assuming that Views speeds thing up for SELECT query, can it be used by NHibernate when restoring object from their persistence store (in this case, SQL 2k5) ? If not, can they be (views) of any use if we use NHibernate?

Third, would it be better to create our crystal report using Views to improve performance?

Thanks for anyone who participates in this thread! :-)Views rarely speed anything up (partioning is a special case). Indexed views can help by providing a second pseudo clustered index. Generally views are to make life easy rather than faster, I'd avoid them wherever possible.

Newspaper stykle 2-columns for a Table in RS.

Hi ,
I can't find a possible way of doing this at present
If I have a Table element containing 3 columns, how can I get it to display
the following way? Is it possible? If I get 10 rows, I want 5 rows in each
of the following. If there are say 7 rows, I'd want 4 ros on the left and
3 rows on the right.
Required layout follows....
ColA ColB ColC ColA ColB ColC
How feasible is this or am i expecting too much?
Thx,
PaulI have an example of multi column layout at www.MSBICENTRAL.com It is in the
downloads section... The only issue is that the column setup MUST apply to
the entire body of the report ( this is an RS restriction.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul Buxton" <paul@.nospamspireite.ndo.co.uk> wrote in message
news:1ihujo3tfvqbl$.5hm437dvn3y2$.dlg@.40tude.net...
> Hi ,
> I can't find a possible way of doing this at present
>
> If I have a Table element containing 3 columns, how can I get it to
> display
> the following way? Is it possible? If I get 10 rows, I want 5 rows in
> each
> of the following. If there are say 7 rows, I'd want 4 ros on the left and
> 3 rows on the right.
> Required layout follows....
>
> ColA ColB ColC ColA ColB ColC
>
> How feasible is this or am i expecting too much?
> Thx,
> Paul

Newboe: table containing XML schemas in database

I just created a schema in the AdventureWorks DB (the place for newbies). Where are these schemas stored and what t-sql statement can list all XML Schemas defined in a database\table\column?

TIA,

Barkingdog

select x.name, t.name, c.name
from sys.column_xml_schema_collection_usages cx,
sys.tables t,
sys.columns c,
sys.xml_schema_collections x
where x.xml_collection_id = cx.xml_collection_id
and t.object_id = cx.object_id
and c.column_id = cx.column_id
and c.object_id = t.object_id

The best way to learn this (catalog views) is thru SQL Server Management Studio -> Object Explorer -> Database -> master -> Views -> System views. Just do select * from every one of them.