Viewing 15 posts - 3,691 through 3,705 (of 14,953 total)
Wow, this sounds seriously like homework.
Before you could even start, you need to know what is expected with regards to calculating the interest on late dues payments. Is it...
July 22, 2011 at 12:46 pm
Real crashed = you try to go on-site to bring it back up, but the fire department won't let you back in the building untill the fire is actually extinguished.
On...
July 22, 2011 at 12:39 pm
I'd definitely isolated test/dev from prod. Physically isolate if at all possible. After all, you should be TRYING to crash your test box, otherwise you won't know if...
July 22, 2011 at 12:34 pm
How "crashed" is "crashed". Like, the server caught on fire and the CPU is vaporized? Or Windows Server shut down and you have to use the power switch...
July 22, 2011 at 12:27 pm
Do you have a table in your actual database that just lists customers? As per usual normalization practices? That would make this even simpler, and probably faster as...
July 22, 2011 at 12:24 pm
Ever since the Core-2 architecture came out, Intel has been seriously outperforming AMD. Used to be the other way around, for a LONG time, but not any more.
Also, even...
July 22, 2011 at 12:22 pm
1 second per row is too long. 200k records at 1 second per row is a bit over 55 hours. Just so you have the right scope on...
July 22, 2011 at 12:17 pm
GabyYYZ (7/22/2011)
And now for something completely different. Applies to DBA's as well.http://www.thegeekstuff.com/2011/07/lazy-sysadmin/%5B/url%5D
I like it.
Not sure about the command-line bit, but if I stretch that to scripting instead of using...
July 22, 2011 at 9:24 am
Is the file-create step before the FTP step in the package (green arrow from one to the next in the control flow)?
July 22, 2011 at 7:20 am
You can use Substring in varbinary just like in varchar. Get the start and stop point, pull the substring, find what you need inside of that.
Again, you're probably better...
July 22, 2011 at 7:18 am
Yes. First you find where your first character is, then the one you want to terminate with, and use Substring to pull out the piece in between. Then...
July 22, 2011 at 7:14 am
bopeavy (7/22/2011)
TravisDBA (7/22/2011)
bopeavy
I don't think it came across that way. Then again must everything is taken from your own perception.
Ir is very easy to confuse truth with...
July 22, 2011 at 7:12 am
Does the inner query, with the Union clause and all that, work without the For XML clause?
If so, does it work with the For XML clause, without the outer part...
July 21, 2011 at 2:47 pm
You're welcome.
No way to indicate "resolved", on purpose. What if someone comes by tomorrow with a better answer than mine? Gives them the chance to post it.
Keep in...
July 21, 2011 at 10:47 am
djackson 22568 (7/21/2011)
July 21, 2011 at 8:48 am
Viewing 15 posts - 3,691 through 3,705 (of 14,953 total)