Viewing 15 posts - 33,226 through 33,240 (of 39,810 total)
Timeframe is this month, though feedback from SP1 could change that.
April 4, 2006 at 9:19 am
Not sure where that thread is, but you can use it. However, if things need to move there, then what happens to developement? Does it stop? Do you lose work?...
April 4, 2006 at 9:17 am
Before you restore a diff, you need to restore a full.
April 4, 2006 at 9:15 am
You also might choose to split up the tables on different periods. Heavily hit tables might be in a script that runs every night. Less used might be scheduled every...
April 4, 2006 at 9:14 am
Correct although in keeping with minimum permissions, you would not choose the Reader role. It gives permissions to multi-server jobs and this question mentions local jobs only.
April 4, 2006 at 9:13 am
I agree with the above. The transactions/sec is not indicative of a problem. It shows the amount of work being done in that database. And your application shouldn't be competing...
April 4, 2006 at 9:12 am
It might be just the expected load on that hardware with that number of users. Or it could be something you can reduce.
60-80% is less than 100%, which is where...
April 4, 2006 at 9:10 am
Besides the missing WHERE clause? On both updates and deletes?
Of course, I'm a production DBA. And I've had some good ones, fortunately with small databases.
- Restore QA over production by...
April 4, 2006 at 9:08 am
Everytime you execute an insert, update, or delete, MORE infromation is written to the log. That's what it is, a log of activity. When you take a log backup, these...
April 4, 2006 at 9:02 am
Login failed is a different message than the name resolution. It means the context of the package execution is running under a local or non-network account.
I suspect that you resetting...
April 4, 2006 at 8:59 am
If it thinks it more efficient, and perhaps 10 is the threshold, locks will be escalated.
I'd be interested in why you cannot manage the updates in one statement. Perhaps stating...
April 4, 2006 at 8:56 am
Neither identity or max(n)+1 will prevent gaps. They both assume the highest value in the table is also the number of values in the table.
Instead if you want to "issue"...
April 4, 2006 at 8:50 am
There's also a NO_LOG option. Look them up in BOL to see which might be more appropriate.
April 4, 2006 at 8:43 am
1. A reinstall wasn't necessary. You missed something.
2. Yes, use the server network utility. Set it to another port. If you have a good firewall router, you may be able...
April 4, 2006 at 8:41 am
Pedro, you need to learn the restore db syntax. Enterprise Manager requires more than one connection to run, so as soon as you start it, you can't restore master.
You need...
April 4, 2006 at 8:37 am
Viewing 15 posts - 33,226 through 33,240 (of 39,810 total)