Viewing 5 posts - 1 through 5 (of 5 total)
Hi,
I am not sure if such a counter exists. Instead you could use a WMI event alert. Write a little script that queries sp_spaceused or DBCC showfilestats. That should do...
December 30, 2010 at 4:12 am
Perry Whittle (6/30/2009)
what about databases that have open connections what do you want to do about these
use master
go
/* set DB offline */
alter database myDB set single_user
with ROLLBACK IMMEDIATE; -- all...
June 30, 2009 at 7:40 am
The beauty about the complevel is that you can have a SQL 10 instance that runs databases in complevel 8, 9 and 10. Meaning no matter what complevel your connecting...
March 27, 2009 at 5:42 am
Grant Fritchey (7/22/2008)
GilaMonster (7/22/2008)
Grant Fritchey
You can also need to update statistics on smaller tables where large percentages of the data changes regularly.Wouln't the auto update take care of that?
I've...
July 22, 2008 at 5:51 am
If you have the db options
'auto_create_statistics' and
'auto_update_statistics' on
you don't have to update them manually (check with sys.databases). You should turn on these options:
alter database 'myDB' set auto_create_statistics on;
alter database 'myDB'...
July 22, 2008 at 5:05 am
Viewing 5 posts - 1 through 5 (of 5 total)