Showing posts with label startup. Show all posts
Showing posts with label startup. Show all posts

Wednesday, March 28, 2012

Hide Document map at startup of report

Hi
How can i set the document map to startup with the report hidden but not gone.
--
Thanks
FrancoisHi
Sorry i did not express myself clearly just now. What i meant to say is when
the user run the report i want the document map to be hidden and only to be
display if the user click on the document map icon.
Thanks
Francois
"Francois" wrote:
> Hi
> How can i set the document map to startup with the report hidden but not gone.
> --
> Thanks
> Francois

Sunday, February 19, 2012

Help: Can I load all table content to the memory during SQL server Startup?

Dear Sir,
I use SQL 2000 server. I want to load all the table content to the
memory the SQL server startup.
How can I do that?
My computer has 2 G RAM. The total space of the databse is 1G.
I have set the mininum memory is 1G (in dynamic configue SQL memory) in SQL
server and check the "Reserved physical memory for SQL server". But no all
data load into the memory during SQL server startup.
I just know that if I write a SQL statement to request records, these
records will be load into memory.
SO, I think it is not a good method to select all tables once after the SQL
server just startup.
Thank you for your help!
--
Regards,
Anthony LamAssuming you really want to do this, create a stored procedure which reads the rows and mark it as a
startup proc (sp_procoption).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"AA" <anthony@.jadeflex.com> wrote in message news:%23ARNLe$gDHA.3272@.tk2msftngp13.phx.gbl...
> Dear Sir,
> I use SQL 2000 server. I want to load all the table content to the
> memory the SQL server startup.
> How can I do that?
> My computer has 2 G RAM. The total space of the databse is 1G.
> I have set the mininum memory is 1G (in dynamic configue SQL memory) in SQL
> server and check the "Reserved physical memory for SQL server". But no all
> data load into the memory during SQL server startup.
> I just know that if I write a SQL statement to request records, these
> records will be load into memory.
> SO, I think it is not a good method to select all tables once after the SQL
> server just startup.
> Thank you for your help!
> --
> Regards,
> Anthony Lam
>