Viewing 15 posts - 226 through 240 (of 605 total)
Just to back up majorbloodnock, Toshiba are good.
I borrowed a Dell from work and just didn't like the machine. Resolution was horrible, keyboard was terrible and well it only...
February 7, 2008 at 4:27 am
Yelena Varshal (1/10/2008)
Does not work this way. People requested their databases back 6 month after we moved them and did not move databases that we were told nobody was using.
One...
January 11, 2008 at 2:16 am
Andras nailed it.
For databases that are small in terms of transactions, no it's not really that important if they are on the same drive.
Regardless, I like to adopt the seperate...
January 9, 2008 at 2:31 am
As was suggested, profiler would tell you who is logging in to which databases.
Also, you could look at datetime columns within tables to identify last insert/update time. However, bear...
January 9, 2008 at 2:25 am
Gail answered your question but I would add a little advice on top of her post.
Your transaction log is growing for a reason. IE..You have many inserts, updates &...
January 4, 2008 at 2:10 am
srimkumarp (1/3/2008)
in old server the AWE is disabled, and also i run the rebuild and reorganize the index on that particular database only . remaining application databases working fine .
wht...
January 4, 2008 at 2:05 am
Have you monitored perfmon? To start with, I'd look at the Physical Disk IO counters.
Does this happen all of the time or do you get periods between errors where...
January 3, 2008 at 4:31 am
If that was the case, I would re-check every configuration. We recently moved servers and I did catch myself out. I forgot to enable AWE on one of...
January 3, 2008 at 2:10 am
Can you not restore the database to a test box and run each job that is scheduled to run every night to see which one causes the growth?
3GB is not...
January 2, 2008 at 10:45 am
Good advice from the previous 2 posts.
From your post, it's seemingly growing faster than in the past - at this point, I would ask myself "why"?
A new process could have...
January 2, 2008 at 10:30 am
What I have done and will continue to do is read up and play about with SQL Server in areas which I feel I need to catch up on. ...
January 2, 2008 at 10:21 am
Unfortunately you don't get them free.
Depending on your support contract you may get a certain number of support calls per year before they become chargable.
Check this link out.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;offerprophone&sd=tech#faq607
January 2, 2008 at 10:09 am
Pandeysharp,
To create a scheduled job, use sp_add_job and sp_add_jobstep. If you did want to run schedule the job, also look at sp_add_jobschedule.
You probably want to look at the syntax...
December 18, 2007 at 5:58 am
By default, no, you can't set a backup size of 20% of the database. Well, not a command I have seen and to be honest, not one I'd every...
December 18, 2007 at 5:55 am
I agree. Also, when you are setting timeout values for a backup to complete, you'll be chasing your tail. You could come across network or disk issues which...
December 12, 2007 at 9:04 am
Viewing 15 posts - 226 through 240 (of 605 total)