.comment-link {margin-left:.6em;}
Gert .Net
[GertDotNet]
20050922
 
Autoclose and Autoshrink
When you notice that Enterprise Manager is getting slow (very slow) when opening the list of databases on a server, you should probably turn of AUTOCLOSE and AUTOSHRINK.

Here is a script that helps you in doing just that.

declare dbCursor cursor  for select name from sysdatabases
open dbCursor

declare @name as varchar(50)

fetch next from dbCursor into @name

while @@fetch_status = 0
begin
print @name
exec sp_dboption @name, 'autoclose', 'false'
exec sp_dboption @name, 'autoshrink', 'false'


fetch next from dbCursor into @name

end

close dbCursor
deallocate dbCursor


This is faster because all databases will be left mounted. If AutoClose is true, a lot of databases will have to be mounted in order to construct the list.
 
Basicode
Do you know, that in The Netherlands computer programs have been send over the normal radio channels.

You should tape them with a cassette-recorder, and then you could read them into your home-computer.

More information: http://www.xs4all.nl/~lennartb/basicode.html
20050912
 
New Fonts in Vista
For a short overview read this:
http://www.poynter.org/column.asp?id=47&aid=78683

 
Rare jongens die Hollanders
Site op zondag gesloten:
http://www.telegraaf.nl/i-mail/25363271/Site_Reformatorisch_Dagblad_weer_op_zondag_gesloten.html

Powered by Blogger