Viewing 15 posts - 376 through 390 (of 399 total)
Also - make sure if you have columns that do not allow for nulls that you are in fact sending something to that column. The ones that do allow...
February 8, 2011 at 9:19 am
SSIS is certainly a more advanced app if you are not familiar with SQL Server to begin with, but I would agree with Steve's idea.
If you are not comfortable with...
February 8, 2011 at 9:15 am
Yeah - sorry about that Craig. That's what I get for posting after nearly 24 straight hours of coding. Kind of like drunk dialing - just don't do...
February 7, 2011 at 9:05 pm
Hi Craig -
CalcBalance1 is the leftover debt. It's also the new balance for the originating account. I guess I have it wrong. I thought they would...
February 6, 2011 at 3:13 pm
Here is a prime example of the problem I am having with my current code. This is the part where the IF statement has determined that an account has a...
February 6, 2011 at 11:07 am
Lutz - thank you for your reply. I had initially thought of trying to treat it as a SELECT CASE, but I am still trying to figure out all...
February 6, 2011 at 7:56 am
That is perfect...I think I should be able to reconfigure the RAID5 Array without too much difficulty at this point before rollout.
Craig, thank you again for all of your wisdom...
February 4, 2011 at 3:37 pm
Perhaps new, but well spoken and you bring your own research to the table. You're one of the folks that makes it worth hanging around here for. A...
February 4, 2011 at 3:10 pm
Not usually a good idea, unless this server is incredibly robust and they're just being cheap on disks. If you end up needing the swapfile, which is more common...
February 4, 2011 at 2:58 pm
Something you mentioned that scares me, on a second thinking. You're storing your backups on the same array that your primary databases are on... Ummm... NOOOOOOOOOOOoooooooooo!!!!! :w00t:
Lose 2...
February 4, 2011 at 2:51 pm
... 🙂 Or just build yourself a nice little SSIS package that will foreach file loop the backup directories and move them where you like... and include it as...
February 4, 2011 at 2:31 pm
I also forgot to mention that my K: Drive is my largest partition for my backups. Nothing fancy going on there - just a plain ol' maintenance plan for...
February 4, 2011 at 2:09 pm
Hi Craig -
No - your evaluation hit the nail on the proverbial head! I appreciate it, and would have loved to have gone with an idea like yours,...
February 4, 2011 at 1:37 pm
Hi Craig -
The RAID 5 Array is composed of a 4x146gb Array. The disk IO in this array is pure data, and some non-clustered indexing to go along with...
February 4, 2011 at 1:10 pm
Viewing 15 posts - 376 through 390 (of 399 total)