Viewing 15 posts - 7,321 through 7,335 (of 18,926 total)
The only thing I ever saw was a "best guess" script. It was matching the tables by finding columns with the same name and IIRC data types.
Now that will...
January 17, 2011 at 11:43 am
Thanks for the help.
And the least I can say is WOW that's screwed up.
However I was able to get myself out of it with this "simple" expression :...
January 17, 2011 at 10:50 am
add this to your where clause :
AND starttime >= DATEADD(n, -30, GETDATE())
Of course it might also make good sense to to check on the endtime instead...
January 17, 2011 at 9:05 am
Yes I think part of it is done async. However you're still starting a process outside the transaction which is outside the control of sql server db engine... never...
January 17, 2011 at 7:38 am
Grant Fritchey (1/17/2011)
Ninja's_RGR'us (1/17/2011)
January 17, 2011 at 7:20 am
I'm not even sure you have a size problem. From what you are saying the whole db takes less than 30 GB? It's very small by most...
January 17, 2011 at 6:25 am
Well yes and no.
Then what you need is to mash up the periods into a single row which will then cause a single update.
Then you'll have a simple update statement...
January 17, 2011 at 5:40 am
The transaction has to wait for something external to the application before completing. It's like waiting for the mailman to pick up the mail before taking the next breath.
Also...
January 17, 2011 at 5:38 am
christopher.hawkes (1/17/2011)
Thanks for the information about UPDATE queries only updating a row once, I never realised this but now everything makes sense.
Looks like i'll be writting a loop and firing...
January 17, 2011 at 2:19 am
Well here's to plan B. Sending mails from triggers is a bad idea anyways.
Make a log table that saves the history of the processed orders.
Then create a job that...
January 16, 2011 at 7:09 pm
Just a hunch, try using SET NOCOUNT ON in the trigger.
January 16, 2011 at 4:34 pm
SQL08Kid (1/14/2011)
January 14, 2011 at 12:16 pm
BETWEEN >>> where date >= and date <=
my version >> where date >= and date <
That slight variation excludes the very first MS of the next day correcting...
January 14, 2011 at 10:05 am
No offense but 170 GB is still a rather small db. Performance shouldn't be all that bad if the ssrs queries are well written.
I was thinking about that option...
January 14, 2011 at 10:03 am
Any reason why you cannot report directly from prod (for a little while).
January 14, 2011 at 9:55 am
Viewing 15 posts - 7,321 through 7,335 (of 18,926 total)