Viewing 15 posts - 136 through 150 (of 1,553 total)
You know... I was just wondering....
Have you guys ever stopped and considered exactly what you're testing?
Or how the tests are done? (which coincides with the 'what' btw)
No, I haven't read...
October 23, 2007 at 8:13 am
It's actually Sergiy's (or rather I saw him post it the first time I saw it, long time ago) 😉
/Kenneth
October 23, 2007 at 7:52 am
... or Swedish... or any other non-english language where days are spelled differently 😉
If you want to know which day of the week a given date is, then there is...
October 23, 2007 at 7:16 am
Yikes! :blink:
A few things noticed before my eyes went blank...
Cursor - get rid of it. Now, I didn't read close enough what it actually did, but I'd be surprised if...
October 23, 2007 at 7:05 am
Why not use the and and only unambigous, language and datesetting independent format we have?
'SSYYMMDD'
..should work with any SQL Server anywhere in the world.
/Kenneth
October 23, 2007 at 1:31 am
I have no idea about points...
I think they are just another name for 'number of posts'....?
/Kenneth
October 22, 2007 at 2:33 am
Greg,
ok, and how are these mails staged?
one-by-one? By the thousands? (or millions?)
Are you looking for the 'batch-approach' that Jeff speaks of, or is it less?
Just trying to set the frames...
October 22, 2007 at 2:29 am
Well, there seems to be a few different ways to implement this feature of 'workdays'...
Atm it seems the race is about millions of rows in batchmode, and 30 days. But...
October 19, 2007 at 8:59 am
Well, according to these counts (they are the complete table?) it looks like your qyery is hitting just about every row. I'd expect this table to be scanned, since you're...
October 19, 2007 at 2:34 am
Is the 'problem column' indexed in any way?
If it is, is the statistics up to date?
How many rows are expected to have this value? ('NR' was it?)
If it's too common...
October 19, 2007 at 2:08 am
..still down the 'you want a dates table' path... 😉
Assume we have a very simple one. Fulldate and if the day is a holiday or not.
Haven't tried this on any...
October 18, 2007 at 9:08 am
I've found that date tables are fine for RBAR... but, how would you use the date table in this instance of batch code and still have some semblance of performance?...
October 18, 2007 at 8:20 am
Greg Snidow (10/18/2007)
Kenneth, I probably should refer to it as weekdays, but as far as my production is concerned no weekends are work days.
Ah, ok. That's another story then....
October 18, 2007 at 8:14 am
Another idea... The penalty is only applied if the Delay is > 0.
So, why not make Delay a computed column?
Then any penalties in the Borrower table will be dynamic, and...
October 18, 2007 at 6:34 am
Yea, thought there might be something preventing that with the current looks of tables.
Though, it seems like this is in the build-process, so perhaps some schema changes still is an...
October 18, 2007 at 5:53 am
Viewing 15 posts - 136 through 150 (of 1,553 total)