Showing posts with label regards. Show all posts
Showing posts with label regards. Show all posts

Tuesday, March 20, 2012

A book for Report server

Dear all

Please can u suggest a good reference book available to study report server..

Regards

Polachan

I am currently reading Microsoft SQL Server 2005 Reporting Services (Sams Publishing) by Michael Lisin and Jim Joseph. I think it is a good book. I also have the other book written by Brian Larson. That is also a good book. The first book I think delves more into the technical details of how RS works behind the scenes. The Brian Larson book is more for beginners, but we use it most here.

Hope this helps.

|||

Thank u sir..

Can I ask to u one doubt regarding the parameter for drill through related to report server

regards

Polachan

sql

Saturday, February 11, 2012

4 GB Size limitation

Hi,

Can somebody tell me if the 4 GB database size limit is per database or for all the databases

Regards

Harish

The limit is per database and its only for the data file not the log file.|||Thanks Euan.|||

Do you have any supporting documentation about this in the MS Site

Sorry to bother.

|||

Here is one place, comparing to MSDE

http://msdn2.microsoft.com/en-us/library/ms165672(SQL.90).aspx

Interesting blog...

http://blogs.msdn.com/czhower/archive/2006/01/06/510192.aspx

|||

Thank you.

Is there any limitation on number of databases. I mean, How many 4 GB databases can I have(Provided there is disk space).

I might be asking the basics, but need to finalize on a product architecture.

Thanks

|||

You can have as many 4 GB databases as your hardware allows. Needless to say, there is a practical limit to how many database can be managed and accessed given the other limitations of 1 CPU and 1 GB Ram.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.