Viewing 15 posts - 14,911 through 14,925 (of 26,486 total)
vinothraj (12/17/2010)
December 17, 2010 at 6:57 am
Have you asked why and can you share their thought pattern here? Just insisting doesn't mean it is correct. I would hope that they would be open to...
December 17, 2010 at 6:25 am
First, unless there are io system issues that prevent it, running backup of multiple databases simultaneously shouldn't be a problem.
Second, my suggestion really wasn't to run simultaneous backups, but backup...
December 17, 2010 at 6:08 am
RichB (12/16/2010)
Cant run a backup as they are serialisable, and we have to wait for the last one to complete...
???
December 16, 2010 at 10:36 pm
I would have to say Service Broker as one. There is a lot one can do with it, and quite a bit of the necessay infrastructure is already built....
December 16, 2010 at 10:33 pm
Not sure if this will fully meet your needs but it seems to fulfill your currently known requirements and should run under SQL Server 2000:
-- See how you start off...
December 16, 2010 at 10:28 pm
Having been using GETDATE() since I started using SQL Server, that is what I use. However, now that I am using Oracle, I have to change my ways. ...
December 16, 2010 at 10:05 pm
There is still a problem with my code based on your previous post. How would you correct my code? I have already identified the necessary fix.
December 16, 2010 at 8:46 pm
Craig Farrell (12/16/2010)
This...
December 16, 2010 at 8:21 pm
Suggestion, instead of building your queries inside the apsx code, try encasulating the queries inside stored procedures or views and select from those. If the query has to change...
December 16, 2010 at 8:10 pm
If you don't mind, I'd like to ask a question first. Why are you separating the date and time? I would think it would make more sense to...
December 16, 2010 at 8:01 pm
Jeff,
Don't worry, mine doesn't fully work properly either. To make it work every time, you have to add enough 9's after the decimal point to fill the precision of...
December 16, 2010 at 7:40 pm
Before giving you a sugestion, what was the actual (full) error message you received?
A suggestion, if possible, backup locally then move to a network location.
December 16, 2010 at 7:28 pm
hoanglong88i (12/16/2010)
20 ...
December 16, 2010 at 7:23 pm
Based on code above, please remember that round(value, length, 1) will truncate, not round.
Here is possibly another method, but not tested to the extremes.
/* Non-Integer Data */
SELECT
...
December 16, 2010 at 7:18 pm
Viewing 15 posts - 14,911 through 14,925 (of 26,486 total)