Viewing 15 posts - 16 through 30 (of 144 total)
I've always monitored from a server other than my SQL server. Also, be sure you have sufficient disk space to hold the PERFMON log file. It can grow pretty large (although,...
Terry
May 19, 2006 at 8:54 am
I'd also suggest going back to Bloomberg. As a vendor of yours (who I'm sure you're paying very handsomely), they shoud not subject your DB to any kind of integrity...
Terry
May 18, 2006 at 8:12 am
Simply issue a backup of the database(s) to a different disk on the server (or totally to another server). Once the new disk is in, simply restore the database(s). Or...
Terry
May 12, 2006 at 8:42 am
If you're doing all the tables in the database, your can use a maintenance plan to perform it as well. Create the plan with the wizard, schedule it as frquently...
Terry
May 12, 2006 at 8:38 am
I use UNC paths. What version of SQL are you running because this was not available in 7.0? Also, it's my understanding that MS doesn't recommend doing this (but we...
Terry
May 12, 2006 at 8:11 am
When looking at the sp_ solution, I notice I only have data in sysjobhistory going back about 3 weeks. I guess if I run the sp_ going forwar to a...
Terry
May 5, 2006 at 9:37 am
try something like this:
select substring(ad.account_number,1,2)as AcctPreFix, count(*) as Total
from annual.annual_account_detail aad,
common.common_account_detail cad,
annual.annual_status aas
where aad.ar_id = cad.account_id and cad.account_id
Group BY ad.account_number
Terry
May 2, 2006 at 1:44 pm
Just a note, if you're backups aren't done, and put to tape, and you have a major crash and cannot restore the data, they are going to look at YOU...
Terry
May 2, 2006 at 8:03 am
If Tivoli has the file locked when it's backing up it will cause your SQL backup to fail. Try to avoid any contention with respect to file locks on the...
Terry
May 2, 2006 at 6:53 am
Paul, if you run sp_configure on both servers, is everything the same (or at least similar)?
Terry
May 2, 2006 at 6:50 am
Any other cool commands like this that you can think of? I know they're in BOL but with everything in there...I can't tell you how many times I've seen this...
Terry
April 28, 2006 at 3:01 pm
I figured that was the table but I expected a column called model or recovery or somthing that was a little more explainatory. Thanks for the quick response.
Terry
April 28, 2006 at 1:21 pm
FYI - from my Query Analyzer, both shift-F1 and F1 bring up BOL.
Terry
April 28, 2006 at 8:38 am
The database was originally full. Someone changed it to "simple" during the course of the day (without my knowledge) causing the job to fail. Had I been alerted to the...
Terry
April 28, 2006 at 6:50 am
I've added a filter to ELM to trap the warning so I guess this issue is closed. But still, does anyone have any idea why it doesn't log to the...
Terry
April 27, 2006 at 9:10 am
Viewing 15 posts - 16 through 30 (of 144 total)