Is there a possible MS media player file demo of Reporting Service

I heard, from a friend, that there is a possible Microsoft media player file
that shows a demo of Reporting Services. The demo is supposed to show how to
access multiple textboxes in the Custom code, place a chart into a table,
etc...
Does any one know of the demo?
Thanks in AdvanceHave you looked on the Reporting Services web site for it yet? There's a
.wmv file at
http://www.microsoft.com/sql/reporting/productinfo/RS_AuthoringDemo.asp that
says it demos how to author, manage, and deliver reports but I haven't
watched it myself to see if it matches your description.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:C71996BA-6302-4B26-8A4E-89CC1D0073C3@.microsoft.com...
>I heard, from a friend, that there is a possible Microsoft media player
>file
> that shows a demo of Reporting Services. The demo is supposed to show how
> to
> access multiple textboxes in the Custom code, place a chart into a table,
> etc...
> Does any one know of the demo?
> Thanks in Advancesql

Is there a High water Mark in sql server

If you delete rows in a table and do a full table scan...
Is that supposed to read up to the highest block/extent that the
table ever attended.(like in some databases I use)
If so what is the best way to take care of such tables in sql server.

I appreciate your responses

VinceVincento Harris (wumutek@.yahoo.com) writes:
> If you delete rows in a table and do a full table scan...
> Is that supposed to read up to the highest block/extent that the
> table ever attended.(like in some databases I use)
> If so what is the best way to take care of such tables in sql server.

I'm afraid that I don't understand the question. Could you exemplify what
you are looking for?

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland Sommarskog <sommar@.algonet.se> wrote in message news:<Xns94018565C8FYazorman@.127.0.0.1>...
> Vincento Harris (wumutek@.yahoo.com) writes:
> > If you delete rows in a table and do a full table scan...
> > Is that supposed to read up to the highest block/extent that the
> > table ever attended.(like in some databases I use)
> > If so what is the best way to take care of such tables in sql server.
> I'm afraid that I don't understand the question. Could you exemplify what
> you are looking for?

Sorry
I hope this is in some clarifies the earlier post.

Example

My table contains 10000 rows

If a query is run that requires a full table scan all the blocks with
data are visited.

Now

9000 rows are deleted

Next Step
Run a query that requires a full table scan and all the blocks that
ever contained data are visited (Not only the one thousand now
present)

Remedy

If the table is exported ,truncated,imported
the highest point that ever contained data is readjusted at least in
Oracle

Does this work the same in sql server?...

Will appreciate your responses

Vince|||Vincento Harris (wumutek@.yahoo.com) writes:
> Example
> My table contains 10000 rows
> If a query is run that requires a full table scan all the blocks with
> data are visited.
> Now
> 9000 rows are deleted
> Next Step
> Run a query that requires a full table scan and all the blocks that
> ever contained data are visited (Not only the one thousand now
> present)
>
> Remedy
> If the table is exported ,truncated,imported
> the highest point that ever contained data is readjusted at least in
> Oracle
> Does this work the same in sql server?...

It sounds like what you are looking for is DBCC DBREINDEX. This commands
rebuilds all or the selected indexes for a table. Note that if you
have a clustered index on a table, the data pages are the leaf level
of that index, so DBREINDEX also caters for these. For a table that
does not have a clustered index, there is no command as far as I know
that takes care of the data pages. But it is recommendable to always
have a clustered index on a table.

An alternative is DBCC INDEXDEFRAG which can be run without locking out
other users.

Both commands are described in Books Online.

The reason that your question confused me, is that you used Oracle
terminology. In SQL Server you never talk about high-water marks,
for instance.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||> The reason that your question confused me, is that you used Oracle
> terminology. In SQL Server you never talk about high-water marks,
> for instance.

Right. SQL Server has a totally different internal structure than
Oracle has. In SQL Server, a table is basically a big linked-list and
the data blocks are essentially the leaf-blocks of the cluster index.
Those blocks are then doubly-linked back and forth so you can traverse
the table in a full table scan or in an index range scan. In fact, an
index range scan of the whole table is essentially (physically) the
same as a full table scan. I'm not sure exactly why, but SQL Server
has always had trouble with corruption of these link-list pointers.
Run DBCC to check (and fix) problems with these pointers.

Is SSRS 2000 compatible with any version of VS 2005?

I am awaiting my free VS 2005 Standard that I'm supposed to get for
viewing online videos on an MS website, and I am curious if SSRS for
SQL Server 2000 can be used with VS 2005'
Thank you, TomI forgot to search the list before I asked, I apologize...
It seems that RS 2005 is compatible with SQL Server 2000, and that RS
2005 will work with VS 2005, but is RS 2005 even available as a
separate download/install for SQL Server 2000'
I looked on the MSSQL downloads page and did not see it...unless it is
not a separate download...I don't expect my agency to be interested in
SS 2005 for quite a while.
Thank you, Tom|||RS 2005 is part of SQL Server 2005. You cannot get it separate. Any box
running RS 2005 must have a SQL Server 2005 license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tlyczko" <tlyczko@.gmail.com> wrote in message
news:1148307676.169124.284530@.38g2000cwa.googlegroups.com...
>I forgot to search the list before I asked, I apologize...
> It seems that RS 2005 is compatible with SQL Server 2000, and that RS
> 2005 will work with VS 2005, but is RS 2005 even available as a
> separate download/install for SQL Server 2000'
> I looked on the MSSQL downloads page and did not see it...unless it is
> not a separate download...I don't expect my agency to be interested in
> SS 2005 for quite a while.
> Thank you, Tom
>|||Sorry to hijack this. I have RS2000 running on my dev machine and would
like to be able to run RS2005 side by side with this. Is this possible?
I cannot uninstall 2000 as it used for dev of production reports and I
could not make any changes if I needed to?
TIA
Bruce L-C [MVP] wrote:
> RS 2005 is part of SQL Server 2005. You cannot get it separate. Any box
> running RS 2005 must have a SQL Server 2005 license.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "tlyczko" <tlyczko@.gmail.com> wrote in message
> news:1148307676.169124.284530@.38g2000cwa.googlegroups.com...
> >I forgot to search the list before I asked, I apologize...
> >
> > It seems that RS 2005 is compatible with SQL Server 2000, and that RS
> > 2005 will work with VS 2005, but is RS 2005 even available as a
> > separate download/install for SQL Server 2000'
> >
> > I looked on the MSSQL downloads page and did not see it...unless it is
> > not a separate download...I don't expect my agency to be interested in
> > SS 2005 for quite a while.
> >
> > Thank you, Tom
> >|||Both Report Designers can be installed side by side. RS 2005 comes with its
own version of VS 2005 so you do not need to purchase VS 2005 to run the
designer. However, if you want to create custom assemblies then you would
need to purchase VS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"theaddict" <theaddict@.gmail.com> wrote in message
news:1148316677.949788.85080@.y43g2000cwc.googlegroups.com...
> Sorry to hijack this. I have RS2000 running on my dev machine and would
> like to be able to run RS2005 side by side with this. Is this possible?
> I cannot uninstall 2000 as it used for dev of production reports and I
> could not make any changes if I needed to?
> TIA
> Bruce L-C [MVP] wrote:
>> RS 2005 is part of SQL Server 2005. You cannot get it separate. Any box
>> running RS 2005 must have a SQL Server 2005 license.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "tlyczko" <tlyczko@.gmail.com> wrote in message
>> news:1148307676.169124.284530@.38g2000cwa.googlegroups.com...
>> >I forgot to search the list before I asked, I apologize...
>> >
>> > It seems that RS 2005 is compatible with SQL Server 2000, and that RS
>> > 2005 will work with VS 2005, but is RS 2005 even available as a
>> > separate download/install for SQL Server 2000'
>> >
>> > I looked on the MSSQL downloads page and did not see it...unless it is
>> > not a separate download...I don't expect my agency to be interested in
>> > SS 2005 for quite a while.
>> >
>> > Thank you, Tom
>> >
>|||What about publishing and running srs2000 .rdl files to sql server 2005? Is
this possible?
"Bruce L-C [MVP]" wrote:
> Both Report Designers can be installed side by side. RS 2005 comes with its
> own version of VS 2005 so you do not need to purchase VS 2005 to run the
> designer. However, if you want to create custom assemblies then you would
> need to purchase VS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "theaddict" <theaddict@.gmail.com> wrote in message
> news:1148316677.949788.85080@.y43g2000cwc.googlegroups.com...
> > Sorry to hijack this. I have RS2000 running on my dev machine and would
> > like to be able to run RS2005 side by side with this. Is this possible?
> > I cannot uninstall 2000 as it used for dev of production reports and I
> > could not make any changes if I needed to?
> >
> > TIA
> >
> > Bruce L-C [MVP] wrote:
> >> RS 2005 is part of SQL Server 2005. You cannot get it separate. Any box
> >> running RS 2005 must have a SQL Server 2005 license.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "tlyczko" <tlyczko@.gmail.com> wrote in message
> >> news:1148307676.169124.284530@.38g2000cwa.googlegroups.com...
> >> >I forgot to search the list before I asked, I apologize...
> >> >
> >> > It seems that RS 2005 is compatible with SQL Server 2000, and that RS
> >> > 2005 will work with VS 2005, but is RS 2005 even available as a
> >> > separate download/install for SQL Server 2000'
> >> >
> >> > I looked on the MSSQL downloads page and did not see it...unless it is
> >> > not a separate download...I don't expect my agency to be interested in
> >> > SS 2005 for quite a while.
> >> >
> >> > Thank you, Tom
> >> >
> >
>
>