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.

Newsgroup Suggestion

It may be extremely useful for MS to start a SQL Server Service Pack
newsgroup. I've bounced around a number of MS SQL Server newsgroups for some
very useful info.
I noticed that there is one for MICROSOFT.PUBLIC.VSNET.SERVICEPACKS.
FrankM
You know you are in trouble when
the learning curve turns into a death spiralHi Frank,
There is already a newsgroup out there: microsoft.public.sqlserver.setup -
this newsgroup is the most appropriate for posting any issues related to
installation of Service Packs. Did you get bounced around posting to this
newsgroup?
Regards,
Jyothi Pai
Microsoft Online Support Engineer
Get Secure! ? www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--
| From: "frankm" <frank@.nxspxm.mallardcentral.com>
| Subject: Newsgroup Suggestion
| Date: Mon, 25 Aug 2003 12:59:20 -0500
| Lines: 13
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <OOEedKzaDHA.2580@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: angrboda.ms.acxiom.com 206.66.66.9
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:302989
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| It may be extremely useful for MS to start a SQL Server Service Pack
| newsgroup. I've bounced around a number of MS SQL Server newsgroups for
some
| very useful info.
|
| I noticed that there is one for MICROSOFT.PUBLIC.VSNET.SERVICEPACKS.
|
|
| FrankM
| You know you are in trouble when
| the learning curve turns into a death spiral
|
|
|
||||No offense, but one could spend hours searching for relevent material
in the KB or support or other places on MS site. Just to find days/weeks
later that there was something that did not show up in a Microsoft search or
something that some other person found.
"Jyothi Pai [MSFT]" <jyothip@.online.microsoft.com> wrote in message
news:Yv1djTMbDHA.2080@.cpmsftngxa06.phx.gbl...
> Hi Frank,
> Thanks for the additional feedback. I'll forward this to the concerned
> folks and see if this can be done. In the meantime, please post any
> setup-related issues with the Service Packs to the
> microsoft.public.sqlserver.setup newsgroup. As you've noted yourself,
> readme is the best place to start before applying the service pack. We
also
> publish KB articles if there are any known issues with a Service Pack and
> this would be another place to go to.
> Regards,
> Jyothi Pai
> Microsoft Online Support Engineer
>
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> --
> | From: "Frank" <frm@.nobs.com>
> | Newsgroups: microsoft.public.sqlserver.server
> | References: <OOEedKzaDHA.2580@.TK2MSFTNGP09.phx.gbl>
> <SABa#HDbDHA.2108@.cpmsftngxa06.phx.gbl>
> | Subject: Re: Newsgroup Suggestion
> | Lines: 65
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
> | Message-ID: <83U2b.15802$Ih1.5335836@.newssrv26.news.prodigy.com>
> | NNTP-Posting-Host: 68.72.136.177
> | X-Complaints-To: abuse@.prodigy.net
> | X-Trace: newssrv26.news.prodigy.com 1061948740 ST000 68.72.136.177 (Tue,
> 26 Aug 2003 21:45:40 EDT)
> | NNTP-Posting-Date: Tue, 26 Aug 2003 21:45:40 EDT
> | Organization: SBC http://yahoo.sbc.com
> | X-UserInfo1:
>
FKPO@.MC@.@.S@.KRV@.YJZHJOFXBWR\HPCTL@.XT^OBPLAH[\BQUBLNTC@.AWZWDXZXQ[K\FFSKCVM@.F_N
>
_DOBWVWG__LG@.VVOIPLIGX\\BU_B@.\P\PFX\B[APHTWAHDCKJF^NHD[YJAZMCY_CWG[SX\Y]^KC\
> HSZRWSWKGAY_PC[BQ[BXAS\F\\@.DMTLFZFUE@.\VL
> | Date: Wed, 27 Aug 2003 01:45:40 GMT
> | Path:
>
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!news-out.cwix.com!newsfeed.cwix.co
>
m!prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy
> com!newssrv26.news.prodigy.com.POSTED!not-for-mail
> | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:303304
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | There is no service pack newsgroup to go to. People go to the newsgroup
> that
> | is the closest to the problem they are having with service pack, like
> | replication or connectivity. So, basically to find out about a
collective
> | set of sp issues you need to bounce groups. MS says to plan and test.
So,
> I
> | plan by going through what documentation I can find, like the readme,
> then I
> | go around the newsgroups trying to find posts that pertain to the sp
> | specifically. There are times that people are told to go to another
> | newsgroup when the subject does not match. Unfortunately MS does not
have
> a
> | one stop shop for info about sp problems, planning and gotcha's. Most of
> the
> | time you need to search and scratch for any info in any number of
places.
> | The sp readme is just a starting point.
> |
> |
> | "Jyothi Pai [MSFT]" <jyothip@.online.microsoft.com> wrote in message
> | news:SABa#HDbDHA.2108@.cpmsftngxa06.phx.gbl...
> | > Hi Frank,
> | >
> | > There is already a newsgroup out there:
> microsoft.public.sqlserver.setup -
> | > this newsgroup is the most appropriate for posting any issues related
to
> | > installation of Service Packs. Did you get bounced around posting to
> this
> | > newsgroup?
> | >
> | > Regards,
> | > Jyothi Pai
> | > Microsoft Online Support Engineer
> | >
> | >
> | > Get Secure! - www.microsoft.com/security
> | > This posting is provided "AS IS" with no warranties, and confers no
> | rights.
> | >
> | > --
> | > | From: "frankm" <frank@.nxspxm.mallardcentral.com>
> | > | Subject: Newsgroup Suggestion
> | > | Date: Mon, 25 Aug 2003 12:59:20 -0500
> | > | Lines: 13
> | > | X-Priority: 3
> | > | X-MSMail-Priority: Normal
> | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> | > | Message-ID: <OOEedKzaDHA.2580@.TK2MSFTNGP09.phx.gbl>
> | > | Newsgroups: microsoft.public.sqlserver.server
> | > | NNTP-Posting-Host: angrboda.ms.acxiom.com 206.66.66.9
> | > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
> | > | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:302989
> | > | X-Tomcat-NG: microsoft.public.sqlserver.server
> | > |
> | > | It may be extremely useful for MS to start a SQL Server Service Pack
> | > | newsgroup. I've bounced around a number of MS SQL Server newsgroups
> for
> | > some
> | > | very useful info.
> | > |
> | > | I noticed that there is one for MICROSOFT.PUBLIC.VSNET.SERVICEPACKS.
> | > |
> | > |
> | > | FrankM
> | > | You know you are in trouble when
> | > | the learning curve turns into a death spiral
> | > |
> | > |
> | > |
> | > |
> | >
> |
> |
> |
>|||Hi Frank,
Thanks for the additional feedback. As I mentioned earlier, I'll forward
this to the appropriate folks and see if this can be done. In the meantime,
please post any
setup-related issues with the Service Packs to the
microsoft.public.sqlserver.setup newsgroup.
Regards,
Jyothi Pai
Microsoft Online Support Engineer
Get Secure! ? www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "frankm" <frank@.nxspxm.mallardcentral.com>
| References: <OOEedKzaDHA.2580@.TK2MSFTNGP09.phx.gbl>
<SABa#HDbDHA.2108@.cpmsftngxa06.phx.gbl>
<83U2b.15802$Ih1.5335836@.newssrv26.news.prodigy.com>
<Yv1djTMbDHA.2080@.cpmsftngxa06.phx.gbl>
| Subject: Re: Newsgroup Suggestion
| Date: Wed, 27 Aug 2003 14:20:35 -0500
| Lines: 153
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <ugXtLBNbDHA.2024@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: angrboda.ms.acxiom.com 206.66.66.9
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:303440
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| No offense, but one could spend hours searching for relevent material
| in the KB or support or other places on MS site. Just to find days/weeks
| later that there was something that did not show up in a Microsoft search
or
| something that some other person found.
|
|
| "Jyothi Pai [MSFT]" <jyothip@.online.microsoft.com> wrote in message
| news:Yv1djTMbDHA.2080@.cpmsftngxa06.phx.gbl...
| > Hi Frank,
| >
| > Thanks for the additional feedback. I'll forward this to the concerned
| > folks and see if this can be done. In the meantime, please post any
| > setup-related issues with the Service Packs to the
| > microsoft.public.sqlserver.setup newsgroup. As you've noted yourself,
| > readme is the best place to start before applying the service pack. We
| also
| > publish KB articles if there are any known issues with a Service Pack
and
| > this would be another place to go to.
| >
| > Regards,
| > Jyothi Pai
| > Microsoft Online Support Engineer
| >
| >
| > Get Secure! - www.microsoft.com/security
| > =====================================================| > When responding to posts, please "Reply to Group" via
| > your newsreader so that others may learn and benefit
| > from your issue.
| > =====================================================| >
| > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| >
| >
| >
| >
| > --
| > | From: "Frank" <frm@.nobs.com>
| > | Newsgroups: microsoft.public.sqlserver.server
| > | References: <OOEedKzaDHA.2580@.TK2MSFTNGP09.phx.gbl>
| > <SABa#HDbDHA.2108@.cpmsftngxa06.phx.gbl>
| > | Subject: Re: Newsgroup Suggestion
| > | Lines: 65
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| > | Message-ID: <83U2b.15802$Ih1.5335836@.newssrv26.news.prodigy.com>
| > | NNTP-Posting-Host: 68.72.136.177
| > | X-Complaints-To: abuse@.prodigy.net
| > | X-Trace: newssrv26.news.prodigy.com 1061948740 ST000 68.72.136.177
(Tue,
| > 26 Aug 2003 21:45:40 EDT)
| > | NNTP-Posting-Date: Tue, 26 Aug 2003 21:45:40 EDT
| > | Organization: SBC http://yahoo.sbc.com
| > | X-UserInfo1:
| >
|
FKPO@.MC@.@.S@.KRV@.YJZHJOFXBWR\HPCTL@.XT^OBPLAH[\BQUBLNTC@.AWZWDXZXQ[K\FFSKCVM@.F_N
| >
|
_DOBWVWG__LG@.VVOIPLIGX\\BU_B@.\P\PFX\B[APHTWAHDCKJF^NHD[YJAZMCY_CWG[SX\Y]^KC\
| > HSZRWSWKGAY_PC[BQ[BXAS\F\\@.DMTLFZFUE@.\VL
| > | Date: Wed, 27 Aug 2003 01:45:40 GMT
| > | Path:
| >
|
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!news-out.cwix.com!newsfeed.cwix.co
| >
|
m!prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy
| > com!newssrv26.news.prodigy.com.POSTED!not-for-mail
| > | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:303304
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | There is no service pack newsgroup to go to. People go to the
newsgroup
| > that
| > | is the closest to the problem they are having with service pack, like
| > | replication or connectivity. So, basically to find out about a
| collective
| > | set of sp issues you need to bounce groups. MS says to plan and test.
| So,
| > I
| > | plan by going through what documentation I can find, like the readme,
| > then I
| > | go around the newsgroups trying to find posts that pertain to the sp
| > | specifically. There are times that people are told to go to another
| > | newsgroup when the subject does not match. Unfortunately MS does not
| have
| > a
| > | one stop shop for info about sp problems, planning and gotcha's. Most
of
| > the
| > | time you need to search and scratch for any info in any number of
| places.
| > | The sp readme is just a starting point.
| > |
| > |
| > | "Jyothi Pai [MSFT]" <jyothip@.online.microsoft.com> wrote in message
| > | news:SABa#HDbDHA.2108@.cpmsftngxa06.phx.gbl...
| > | > Hi Frank,
| > | >
| > | > There is already a newsgroup out there:
| > microsoft.public.sqlserver.setup -
| > | > this newsgroup is the most appropriate for posting any issues
related
| to
| > | > installation of Service Packs. Did you get bounced around posting to
| > this
| > | > newsgroup?
| > | >
| > | > Regards,
| > | > Jyothi Pai
| > | > Microsoft Online Support Engineer
| > | >
| > | >
| > | > Get Secure! - www.microsoft.com/security
| > | > This posting is provided "AS IS" with no warranties, and confers no
| > | rights.
| > | >
| > | > --
| > | > | From: "frankm" <frank@.nxspxm.mallardcentral.com>
| > | > | Subject: Newsgroup Suggestion
| > | > | Date: Mon, 25 Aug 2003 12:59:20 -0500
| > | > | Lines: 13
| > | > | X-Priority: 3
| > | > | X-MSMail-Priority: Normal
| > | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | > | Message-ID: <OOEedKzaDHA.2580@.TK2MSFTNGP09.phx.gbl>
| > | > | Newsgroups: microsoft.public.sqlserver.server
| > | > | NNTP-Posting-Host: angrboda.ms.acxiom.com 206.66.66.9
| > | > | Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| > | > | Xref: cpmsftngxa06.phx.gbl
microsoft.public.sqlserver.server:302989
| > | > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > | > |
| > | > | It may be extremely useful for MS to start a SQL Server Service
Pack
| > | > | newsgroup. I've bounced around a number of MS SQL Server
newsgroups
| > for
| > | > some
| > | > | very useful info.
| > | > |
| > | > | I noticed that there is one for
MICROSOFT.PUBLIC.VSNET.SERVICEPACKS.
| > | > |
| > | > |
| > | > | FrankM
| > | > | You know you are in trouble when
| > | > | the learning curve turns into a death spiral
| > | > |
| > | > |
| > | > |
| > | > |
| > | >
| > |
| > |
| > |
| >
|
|
|