Analysis Server

Can somebody help me understand what it take to install and setup Analysis
Server?
Is it part of standard MSSQL 2000 setup procedure?
Thx
YuriW
Yuri,
The procedure to install Analysis services is mentioned in
BooksOnLine(BOL).Here is the url:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\ola
pdmad.chm::/aginstalling_5trn.htm
To access a url, open up BOL and in the 'Go' menu, select 'url' and feed in
the above value.In case you dont have BOL installed, here is the same page
in the web:
'Running Setup'
http://msdn.microsoft.com/library/en...asp?frame=true
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy. com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>
|||In addition to Dinesh's answer, simply put the SQL CD in, and do
autorun.exe... Choose Install Database components, the next window will
give you an option to install Analysis services... Click click you are
done..
Then install the service pack..
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
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy. com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>
sql

Analysis Server

Can somebody help me understand what it take to install and setup Analysis
Server?
Is it part of standard MSSQL 2000 setup procedure?
Thx
YuriWYuri,
The procedure to install Analysis services is mentioned in
BooksOnLine(BOL).Here is the url:
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\ola
pdmad.chm::/aginstalling_5trn.htm
To access a url, open up BOL and in the 'Go' menu, select 'url' and feed in
the above value.In case you dont have BOL installed, here is the same page
in the web:
'Running Setup'
/url]
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
[url]http://www.tkdinesh.com" target="_blank">http://msdn.microsoft.com/library/e...ww.tkdinesh.com
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy.com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>|||In addition to Dinesh's answer, simply put the SQL CD in, and do
autorun.exe... Choose Install Database components, the next window will
give you an option to install Analysis services... Click click you are
done..
Then install the service pack..
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
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy.com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>

Analyse Memory Leak from sqlsrv.exe

Hi,
Did somebody know what is the best practice to
detect Memory/CPU Leaks on SQL 2000/WIN 2000 ?
On Performance Manager I can see that sqlsrv.exe use
lot of Memory/CPU, now I would know wich DB, Connection or
query generate this leak.
PS: if I have more Instance on a Server, how can I se wich Instance
corrisponde with sqlsrv.exe in Task Manager?
Many Thanks for all input ...Try this:
http://www.sophos.com/virusinfo/ana...2tilebotav.html|||SQL Server will use as much RAM as you configure it for. That doesn't
indicate a memory leak. On a server that runs other applications you
may want to configure something less than the maximum RAM available to
SQL Server. On a dedicated server however, you should let SQL Server
manage memory allocation.
David Portas
SQL Server MVP
--

Analyse Memory Leak from sqlsrv.exe

Hi,
Did somebody know what is the best practice to
detect Memory/CPU Leaks on SQL 2000/WIN 2000 ?
On Performance Manager I can see that sqlsrv.exe use
lot of Memory/CPU, now I would know wich DB, Connection or
query generate this leak.
PS: if I have more Instance on a Server, how can I se wich Instance
corrisponde with sqlsrv.exe in Task Manager?
Many Thanks for all input ...
Try this:
http://www.sophos.com/virusinfo/anal...tilebotav.html
|||SQL Server will use as much RAM as you configure it for. That doesn't
indicate a memory leak. On a server that runs other applications you
may want to configure something less than the maximum RAM available to
SQL Server. On a dedicated server however, you should let SQL Server
manage memory allocation.
David Portas
SQL Server MVP

Analyse Memory Leak from sqlsrv.exe

Hi,
Did somebody know what is the best practice to
detect Memory/CPU Leaks on SQL 2000/WIN 2000 ?
On Performance Manager I can see that sqlsrv.exe use
lot of Memory/CPU, now I would know wich DB, Connection or
query generate this leak.
PS: if I have more Instance on a Server, how can I se wich Instance
corrisponde with sqlsrv.exe in Task Manager?
Many Thanks for all input ...Try this:
http://www.sophos.com/virusinfo/analyses/w32tilebotav.html|||SQL Server will use as much RAM as you configure it for. That doesn't
indicate a memory leak. On a server that runs other applications you
may want to configure something less than the maximum RAM available to
SQL Server. On a dedicated server however, you should let SQL Server
manage memory allocation.
--
David Portas
SQL Server MVP
--

alternative for last()

Hi,
Does somebody knows an alternative for the function last() in access. I've a
lot queries which uses last, but there is no alternative in sql server.
I used min/max but that did not gave me the right results. I need to know
the last row in a 1-to-many table situation.
Is there something like a hidden rowid i can use?Jason
See MAX(),MIN() funtions in the BOL.
\
"Jason" <jasonlewis@.hotrmail.com> wrote in message
news:OXIlbqZGFHA.3648@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does somebody knows an alternative for the function last() in access. I've
a
> lot queries which uses last, but there is no alternative in sql server.
> I used min/max but that did not gave me the right results. I need to know
> the last row in a 1-to-many table situation.
> Is there something like a hidden rowid i can use?
>|||Select top 1 * from table order by field desc
Madhivanan|||There is NO exact equivalent of the LAST function of Access in SQL server.
This is based on the relational concept that the rows in a table are not
ordered.
So anything like LAST, FIRST, NEXT etc are totally meaningless.
If you have a column that records data in any chronological order, you can
achieve the same by using the MAX function.

> Is there something like a hidden rowid I can use?
No, there is nothing like that exposed.
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Jason" <jasonlewis@.hotrmail.com> wrote in message
news:OXIlbqZGFHA.3648@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does somebody knows an alternative for the function last() in access. I've
> a
> lot queries which uses last, but there is no alternative in sql server.
> I used min/max but that did not gave me the right results. I need to know
> the last row in a 1-to-many table situation.
> Is there something like a hidden rowid i can use?
>|||HI Mad,
How is sytax if i want it to join with another table (the 1 side of
1-to-many)?
<madhivanan2001@.gmail.com> wrote in message
news:1109158964.898453.171390@.f14g2000cwb.googlegroups.com...
> Select top 1 * from table order by field desc
> Madhivanan
>|||If you have the concept of last, then there is some ordering.... If for
example you want the last price ( with the ordering being the title_id),
then sort the rows in the reverse order, so the last row becomes the first
row returned, and select the top 1... ie
select top 1 price from titles order by title_id desc
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
"Jason" <jasonlewis@.hotrmail.com> wrote in message
news:OXIlbqZGFHA.3648@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does somebody knows an alternative for the function last() in access. I've
> a
> lot queries which uses last, but there is no alternative in sql server.
> I used min/max but that did not gave me the right results. I need to know
> the last row in a 1-to-many table situation.
> Is there something like a hidden rowid i can use?
>|||Please post DDL and sample data so that we don't have to guess what
your table structure looks like:
http://www.aspfaq.com/etiquette.asp?id=5006
You'll aslo have to tell us what you mean by the "last row" there is no
fixed concept of first and last in a table because tables in SQL have
no inherent logical order.
David Portas
SQL Server MVP
--