Viewing 15 posts - 23,896 through 23,910 (of 39,818 total)
jritson (5/13/2009)
It's interesting that you conclude so quickly that it is the inactivity and PC work that caused the pain.
Thanks for the sympathy and link, but it wasn't working...
May 13, 2009 at 7:45 am
I'd also suggest you go 64bit at this point on your machines. Especially with VMs.
Upgrading memory is easy, as mentioned above.
May 13, 2009 at 7:40 am
When you say you restored the server, how did you do that?
May 12, 2009 at 8:46 pm
Gus, nice post, and thanks for the details of how you use this in an interview.
May 12, 2009 at 3:59 pm
I'm still not sure you need to kill these processes. Maybe, but you might need lots of them before it would affect your server at all. We used to do...
May 12, 2009 at 3:45 pm
You ALWAYS want to have free space in your data and log files. Growing them is a relatively expensive process, so you have free space in there.
A 10MB log has...
May 12, 2009 at 3:34 pm
Ohh, I want video for the podcasts
May 12, 2009 at 1:46 pm
Wow. that's a new one on me. Thanks for the update.
May 12, 2009 at 1:45 pm
chkdsk isn't thorough enough. You need low level diagnostics, as well as double checking every software version in the I/O system (drivers, firmware,etc)
May 12, 2009 at 10:53 am
Paul,
I agree. Don't bait-and-switch. Let someone know what to expect in the interview.
May 12, 2009 at 10:11 am
I'm confused.
If you have nightly loads that make the log large, how is that space wasted? You need it every night. Shrinking during the day is silly. What else do...
May 12, 2009 at 9:55 am
Everything you do is a guess here. It's hard to estimate this unless you know the transaction load.
And if you do, then why not just run a log backup every...
May 12, 2009 at 9:19 am
The deallocations of pages are logged, not each row, so this is quick.
Also, keep in mind that a truncate is usually to clear out data. I've not seen it included...
May 12, 2009 at 9:18 am
I agree with John. This sounds like an issue outside of SQL Server.
May 12, 2009 at 9:17 am
Viewing 15 posts - 23,896 through 23,910 (of 39,818 total)