Viewing 15 posts - 166 through 180 (of 183 total)
Good deal, i've got a nice little script i use to see the db size and log size and % used (*this is only good on 2005 & 2008,...
September 23, 2009 at 7:09 am
if you type in
dbcc sqlperf(logspace)
what are your results?
if your backing up the log you should be able to minimize the log growth, but if the log does need to...
September 23, 2009 at 6:56 am
Hey Sunil,
I'm going to do this by using the GUI
1. Right Click on the database you want to restore
2. Click Tasks | Click Restore |Click Database
3. put in all...
September 23, 2009 at 6:48 am
Agree you need to take into account Business rules and other systems that may have dependencies on one another, as well as capturing the performance counters.
At my last job we...
September 1, 2009 at 6:30 am
in the script put
use [databasename];
go
[insert remainder of the script]
September 1, 2009 at 5:30 am
What version of SQL Server are you running?
You will need to open up a new maintinace plan, and have the steps within the plan follow the type of steps done...
August 31, 2009 at 1:30 pm
I understand this may sound overly cautious, but if you store SSIS packages on the server then there is always the chance that someone could hack in and get the...
August 31, 2009 at 1:21 pm
agreed. I've been talking with my SA's about that. They manage a 3rd party software that manages the alerts for all the servers, and they have only 1...
August 31, 2009 at 6:27 am
Hey Leo,
If you do a search on performance counter on SSC you will get plenty of results, but here is the first one in the list...
June 16, 2009 at 8:56 am
Hey All,
I've got a server with 8GB ram, it is using an unusally high amount 7.2 GB, but my hardware counters are fine (New DBA I...
June 16, 2009 at 7:35 am
never mind, was freaking out and logged into the wrong server.......this is what waking up at 3am to do upgrades will do to you....
move along....nothing to see hear......
June 12, 2009 at 11:22 am
Agree with SS I just ran into this on a cluster upgrade from 05 to 08. At first "The Service" error they were talking about for me was...
June 12, 2009 at 11:04 am
GilaMonster (4/16/2009)
No need. The stats update will invalidate all plans.
Hey Gail just to clarify should i delete the system auto created statistics or should i just run sp_updatestats and update...
April 16, 2009 at 11:31 am
Tim Walker (4/15/2009)
If you have an upgrade from 2000 to 2005 you may well have some compilation differences.
One good way to detect this (after...
April 15, 2009 at 7:34 pm
Viewing 15 posts - 166 through 180 (of 183 total)