http://www.sqlservercentral.com/blogs/steve_jones/2008/09/28/sunday-morning/

Printed 2014/11/28 12:20AM

Sunday Morning

By Steve Jones, 2008/09/28

I woke up early, with my schedule a bit messed up from last week and yesterday. I was tempted to lay in bed with my wife, but since there was a kid in our bed and I knew I'd be getting up early with Kyle this week, I decided to get moving.

It was nice and quiet, no kids, and so I answered a few posts, getting back above 400 (my monthly goal) and cleaning up the site. A nice cup of coffee, a bar, and some water keeping me fueled.

For some reason I don't mind these quiet early mornings, first thing I do in the day, getting work done. When Tia's gone, however, I struggle in the afternoons for some reason. I tend to go to lunch with friends and then do something around the house since I can't work. That usually means more late nights, which throw off my productivity in the morning, and I can't be productive like I am today.

On the bright side, I saw some interesting things in the forum.

Someone had an OS error, could not create file (called from xp_subdir) and they reported back that it was a remote disk and the SQL Service was running under a local account. Changed it to a doman account and it worked.

Quite a few people don't understand how logs work, thinking they are like regular log files and get written to as things happen and then grow. Someone, perhaps me, needs to write a good reference article on this. I have a good general one from Gail Shaw, but I need to get another one out there.

Got a good idea for an editoral, but it's a secret :) 

Someone had performance issues from bulk loading to a table every minute. Wow, that's quite a system if it's any size. Partitioning could help, staging, perhaps separate disk arrays, but ultimately I think you just need more horsepower (disk, memory, and CPU) in your server. 


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.