Viewing 15 posts - 151 through 165 (of 1,553 total)
Why do you want a cumulative update on fine each day?
It's easier to just query for that information, and you don't have to mess around with permanently storing a derived...
October 18, 2007 at 5:41 am
Nice, so then my guess was right on the nail 🙂
...and the anser to the op is; No, there is no risk of memoryleaks or 'runaway' multiples of overwritten variables...
October 18, 2007 at 5:34 am
So, what's the deal with not having a dates table?
It will solve all your problems, no need for complex functions or anything else exotic.
The main problem: How do you define...
October 18, 2007 at 3:26 am
😉
Look at the top.
The declaration of @p is inside the while loop.
...unless you're really asking for something else? 😎
October 18, 2007 at 3:19 am
T-SQL does. 😀
October 18, 2007 at 3:00 am
Just being picky, but...
There's no such thing as a LEFT JOIN being 'equivalent' to an INNER JOIN.
Those are quite different, different questions asking for different answers and works in...
October 18, 2007 at 2:13 am
Well, haven't given it much thought actually.
I routinely never declare/create/drop stuff inside loops unless restricted by scope or forced to do it for some reason. For the 'normal' stuff, I...
October 18, 2007 at 1:57 am
On the top of my head I can only come up with one op that is 100% write (or almost anyways), and that's an INSERT statement. (in the database data...
October 18, 2007 at 1:49 am
Well... Don't you think that RAID5 gives just that - 'most perf bang per buck'..?
I mean it's a relative between the perf given compared to the bucks it's costing... 🙂
And...
October 17, 2007 at 8:16 am
Does 'sp_get_log_shipping_monitor_info' give you what you need?
/Kenneth
October 17, 2007 at 8:05 am
My guess is that it won't be declared more than once, after the first time it's decalred, only the assignment will happen.
I'm guessing this due to the fact you can't...
October 17, 2007 at 7:19 am
Matt Miller (10/16/2007)
October 17, 2007 at 7:06 am
If the mission is to find some sort of 'evidence' of a certain action, then providing the db is not in simple recovery mode, the transaction log contains records of...
October 16, 2007 at 2:49 am
The 'problem' with financial systems is that they all too often use floats.. And expect them to be 'reliable'. Wrong tool for the wrong purpose.
/Kenneth
October 16, 2007 at 2:41 am
Dont know about anyone else but Ive never seen a calendar with 53 weeks.
This is one of the 'fun' parts with dates and calendars. When you say 'anyone', in places...
October 15, 2007 at 1:43 am
Viewing 15 posts - 151 through 165 (of 1,553 total)