Viewing 15 posts - 13,231 through 13,245 (of 22,213 total)
Paula-196779 (2/15/2011)
February 15, 2011 at 8:08 am
David Benoit (2/15/2011)
Grant Fritchey (2/15/2011)
February 15, 2011 at 7:31 am
Paula-196779 (2/15/2011)
February 15, 2011 at 7:29 am
Oh crud, and this is the point where I should have mentioned that my company has a couple of excellent backup compression products you might want to take a look...
February 15, 2011 at 7:23 am
Grant Fritchey (2/15/2011)
You really, really, really should not do that, for at least the reason you just discovered. If you...
February 15, 2011 at 7:22 am
Deletes are going to lead to indexes getting updated. That takes place in tempdb. Are you shrinking tempdb over & over? Don't do that. Grow it out to an appropriate...
February 15, 2011 at 7:10 am
Calculating the transaction log is pretty difficult. Basically, the size of the data being sent into the system times the number of transactions. It's a tough one. Just remember that...
February 15, 2011 at 7:08 am
On a side note, are you developing against the production database?
You really, really, really should not do that, for at least the reason you just discovered. If you take your...
February 15, 2011 at 7:05 am
There are many excellent monitoring tools out there. Most of them get the job done. Mainly there are differences in approach and output. The thing to do is explore which...
February 15, 2011 at 7:01 am
Hash match operators build a hash table, that can result in writes to tempdb. I also see a sort operation, again, writes to the tempdb. That's probably where that stuff...
February 15, 2011 at 6:52 am
This is a question best asked to Microsoft, not here. No one I know of who posts here regularly is an MS employee, let alone someone in their sales division...
February 15, 2011 at 6:49 am
You're absolutely on the road to being a dba. Don't worry. It doesn't hurt and you frequently make a little more money than developers. You just won't have as many...
February 15, 2011 at 6:47 am
For a single table, export it is the answer. I work for a company that makes three different tools, all focused around backup and restore, and we don't backup single...
February 15, 2011 at 6:29 am
I wrote this article on log backups just so I could use it in situations like this. Go here and read this[/url]. Hopefully it will help.
February 15, 2011 at 5:44 am
Kiara (2/15/2011)
# If the database supports a transaction processing system, then avoid using indexes because the
# performance of the insertion of new transactions will be degraded.
I disagree with this statement....
February 15, 2011 at 5:42 am
Viewing 15 posts - 13,231 through 13,245 (of 22,213 total)