Books, articles on printing reports

I am a developer. I current have the Developer Edition of SQL Server 2000 on
my desktop and I am installing VB.Net 2003 and Reporting Services so that a
report, that uses data from a SQL Server 2000 database, can be printed.
I seek the minimal education available that will enable me to design this
report that my customers, who using the database, will print. Are there
suggestions for books or articles that meet this need?
Thanks.
JimMicrosoft SQL Server 2000 Reporting Services is pretty straight forward if
you avoid the filler about how the engine works (actually to be fair all the
books I've seen spend a lot of time on this), there is a better book but its
quite a bit more techy - hitch hikers guide to reporting services.
Phil
"James_101" <James101@.discussions.microsoft.com> wrote in message
news:F730DE37-5437-4E9C-BB8B-BA7776BDEBC9@.microsoft.com...
>I am a developer. I current have the Developer Edition of SQL Server 2000
>on
> my desktop and I am installing VB.Net 2003 and Reporting Services so that
> a
> report, that uses data from a SQL Server 2000 database, can be printed.
> I seek the minimal education available that will enable me to design this
> report that my customers, who using the database, will print. Are there
> suggestions for books or articles that meet this need?
> Thanks.
> Jim|||'Hitchhiker's Guide to SQL Server 2000 Reporting Services' is a very good
book on the subject ...
http://www.sqlreportingservices.net/
There are lot's of on-line resources here ...
http://msdn.microsoft.com/sql/2000/learn/bi/reporting/default.aspx
--
Brendan Reynolds
"James_101" <James101@.discussions.microsoft.com> wrote in message
news:F730DE37-5437-4E9C-BB8B-BA7776BDEBC9@.microsoft.com...
>I am a developer. I current have the Developer Edition of SQL Server 2000
>on
> my desktop and I am installing VB.Net 2003 and Reporting Services so that
> a
> report, that uses data from a SQL Server 2000 database, can be printed.
> I seek the minimal education available that will enable me to design this
> report that my customers, who using the database, will print. Are there
> suggestions for books or articles that meet this need?
> Thanks.
> Jim|||Best book I've read on RS is "CodeFez Guide to Reporting Services". They
released a PDF version a few weeks ago, PDF version is about $20. I found
it a lot easier to read than the others.
http://www.falafel.com/Products/tabid/58/CatalogItemID/19/CatalogID/1/psnavcmd/CatalogItemDetails/Default.aspx
--
Floyd
"James_101" <James101@.discussions.microsoft.com> wrote in message
news:F730DE37-5437-4E9C-BB8B-BA7776BDEBC9@.microsoft.com...
>I am a developer. I current have the Developer Edition of SQL Server 2000
>on
> my desktop and I am installing VB.Net 2003 and Reporting Services so that
> a
> report, that uses data from a SQL Server 2000 database, can be printed.
> I seek the minimal education available that will enable me to design this
> report that my customers, who using the database, will print. Are there
> suggestions for books or articles that meet this need?
> Thanks.
> Jim

Blocking Question

I am beginning to see blocked and blocking processes in
Lock / Process ID tab under the current activity window.
SQL Server resolves this after a while but is this
normal ' If not how can I resolve the blocking problems '
Database is a highly transactional ~500 user database.
Thanks for any feedback.Blocking is OK, as long as there's no dead lock. If one process opens a
transaction and then the second process try to access the same tables
used by the first one, the second process will be blocked. It will just
sit there and wait until the first process finish its job (commit or
rollback), so it's normal.
--
Eric Li
SQL DBA
MCDBA
Nick wrote:
> I am beginning to see blocked and blocking processes in
> Lock / Process ID tab under the current activity window.
> SQL Server resolves this after a while but is this
> normal ' If not how can I resolve the blocking problems '
> Database is a highly transactional ~500 user database.
> Thanks for any feedback.|||Just to add a little to Eric's answer. A little bit of blocking is normal
and can be OK as long as it doesn't wait too long. If your seeing a lot of
blocking you may need to tune some of your statements or indexes some.
--
Andrew J. Kelly
SQL Server MVP
"Eric.Li" <anonymous@.microsoftnews.org> wrote in message
news:eDAeTbPREHA.1048@.tk2msftngp13.phx.gbl...
> Blocking is OK, as long as there's no dead lock. If one process opens a
> transaction and then the second process try to access the same tables
> used by the first one, the second process will be blocked. It will just
> sit there and wait until the first process finish its job (commit or
> rollback), so it's normal.
> --
> Eric Li
> SQL DBA
> MCDBA
> Nick wrote:
> > I am beginning to see blocked and blocking processes in
> > Lock / Process ID tab under the current activity window.
> > SQL Server resolves this after a while but is this
> > normal ' If not how can I resolve the blocking problems '
> >
> > Database is a highly transactional ~500 user database.
> >
> > Thanks for any feedback.
>|||Hi,
Have a look into thebelow article which explains the strategies to reduce
blocking:-
http://www.sql-server-performance.com/sf_block_prevention.asp
Have a look into the below link as well to reduce locks
http://www.sql-server-performance.com/reducing_locks.asp
Thanks
Hari
MCDBA
"Nick" <anonymous@.discussions.microsoft.com> wrote in message
news:1491601c444f2$f95cf610$a001280a@.phx.gbl...
> I am beginning to see blocked and blocking processes in
> Lock / Process ID tab under the current activity window.
> SQL Server resolves this after a while but is this
> normal ' If not how can I resolve the blocking problems '
> Database is a highly transactional ~500 user database.
> Thanks for any feedback.|||Thanks to All.........
>--Original Message--
>I am beginning to see blocked and blocking processes in
>Lock / Process ID tab under the current activity window.
>SQL Server resolves this after a while but is this
>normal ' If not how can I resolve the blocking
problems '
>Database is a highly transactional ~500 user database.
>Thanks for any feedback.
>.
>

Blocking Question

I am beginning to see blocked and blocking processes in
Lock / Process ID tab under the current activity window.
SQL Server resolves this after a while but is this
normal ? If not how can I resolve the blocking problems ?
Database is a highly transactional ~500 user database.
Thanks for any feedback.
Blocking is OK, as long as there's no dead lock. If one process opens a
transaction and then the second process try to access the same tables
used by the first one, the second process will be blocked. It will just
sit there and wait until the first process finish its job (commit or
rollback), so it's normal.
Eric Li
SQL DBA
MCDBA
Nick wrote:

> I am beginning to see blocked and blocking processes in
> Lock / Process ID tab under the current activity window.
> SQL Server resolves this after a while but is this
> normal ? If not how can I resolve the blocking problems ?
> Database is a highly transactional ~500 user database.
> Thanks for any feedback.
|||Just to add a little to Eric's answer. A little bit of blocking is normal
and can be OK as long as it doesn't wait too long. If your seeing a lot of
blocking you may need to tune some of your statements or indexes some.
Andrew J. Kelly
SQL Server MVP
"Eric.Li" <anonymous@.microsoftnews.org> wrote in message
news:eDAeTbPREHA.1048@.tk2msftngp13.phx.gbl...
> Blocking is OK, as long as there's no dead lock. If one process opens a
> transaction and then the second process try to access the same tables
> used by the first one, the second process will be blocked. It will just
> sit there and wait until the first process finish its job (commit or
> rollback), so it's normal.
> --
> Eric Li
> SQL DBA
> MCDBA
> Nick wrote:
>
|||Hi,
Have a look into thebelow article which explains the strategies to reduce
blocking:-
http://www.sql-server-performance.co...prevention.asp
Have a look into the below link as well to reduce locks
http://www.sql-server-performance.co...cing_locks.asp
Thanks
Hari
MCDBA
"Nick" <anonymous@.discussions.microsoft.com> wrote in message
news:1491601c444f2$f95cf610$a001280a@.phx.gbl...
> I am beginning to see blocked and blocking processes in
> Lock / Process ID tab under the current activity window.
> SQL Server resolves this after a while but is this
> normal ? If not how can I resolve the blocking problems ?
> Database is a highly transactional ~500 user database.
> Thanks for any feedback.

Birthdate calculation

I am trying to calculate an individual's age by using the individual
birthdate (i.e. 02/12/1982) and subtracting the date from the current date.
Then divide the answer by 365.25.
When I format the dates as MMddyyyy and the subtract the individual
birthdate from the current date. Then divde the answer by 365.25. I am
getting the wrong number.
Do I need to convert the dates to an interger? If so, I have not found any
examples.
Thanks.You should be able to do something like:
=System.DateTime.Now.Substract (System.DateTime.Parse
(Fields!Birthday.Value)).TotalDays / 365.25
unless your field is already a datetime in which case you dont need to
Parse.|||I put the code in the Expression field.
=System.DateTime.Now.Substract (System.DateTime.Parse
(Fields!CREATION_DATE.Value)).TotalDays / 365.25
I am getting the message: Substract is not a member of 'Date'.
"arexey@.gmail.com" wrote:
> You should be able to do something like:
> =System.DateTime.Now.Substract (System.DateTime.Parse
> (Fields!Birthday.Value)).TotalDays / 365.25
> unless your field is already a datetime in which case you dont need to
> Parse.
>|||Subtract NOT Substract
too bad no intellisense in rs to avoid spelling errors.
"Mike" wrote:
> I put the code in the Expression field.
> =System.DateTime.Now.Substract (System.DateTime.Parse
> (Fields!CREATION_DATE.Value)).TotalDays / 365.25
> I am getting the message: Substract is not a member of 'Date'.
>
> "arexey@.gmail.com" wrote:
> > You should be able to do something like:
> >
> > =System.DateTime.Now.Substract (System.DateTime.Parse
> > (Fields!Birthday.Value)).TotalDays / 365.25
> >
> > unless your field is already a datetime in which case you dont need to
> > Parse.
> >
> >|||Thanks, it's working.
"mike" wrote:
> Subtract NOT Substract
> too bad no intellisense in rs to avoid spelling errors.
> "Mike" wrote:
> > I put the code in the Expression field.
> > =System.DateTime.Now.Substract (System.DateTime.Parse
> > (Fields!CREATION_DATE.Value)).TotalDays / 365.25
> >
> > I am getting the message: Substract is not a member of 'Date'.
> >
> >
> > "arexey@.gmail.com" wrote:
> >
> > > You should be able to do something like:
> > >
> > > =System.DateTime.Now.Substract (System.DateTime.Parse
> > > (Fields!Birthday.Value)).TotalDays / 365.25
> > >
> > > unless your field is already a datetime in which case you dont need to
> > > Parse.
> > >
> > >