Viewing 15 posts - 1,711 through 1,725 (of 5,678 total)
ColdCoffee (3/22/2012)
Mathew Abraham (3/22/2012)
Update D set j=s.j, k=s.k from @table_D D,@table_S s where d.i=s.i
The problem is the CROSS JOIN. why do u want to do a cross...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 22, 2012 at 3:39 pm
Hmmm, that IS really odd.
You can't guarantee the order of the updates but I wouldn't expect the null to be ignored.
Wrapping the k setting with an isnull also doesn't correct...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 22, 2012 at 3:38 pm
Burninator (3/20/2012)
We're trying to locate a 6 month contractor to handle a SSRS report request overload from the business.
I'm your huckleberry...
Needs to be on-site in Phoenix, AZ. Chair warmth...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 20, 2012 at 6:16 pm
codebyo (3/20/2012)
Evil Kraig F (3/20/2012)
However,...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 20, 2012 at 6:12 pm
This is basically a running totals query, and I believe that's where Jeff's going with his solution so I won't work the same process twice. 😉
However, there's another concern with...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 20, 2012 at 5:13 pm
GilaMonster (3/20/2012)
I have a number of physics courses, a couple of astrophysics, one or two philosophy and a calculus one queued up to watch.
My hats off to you for considering...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 20, 2012 at 2:47 pm
It has nothing to do with the log backups and everything to do with how the file is grown. Kimberly Tripp's articles are the best I've seen on this...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 20, 2012 at 2:39 pm
I'm currently dealing with this exact issue. We're trying to locate a 6 month contractor to handle a SSRS report request overload from the business.
So far: Three people who...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 20, 2012 at 2:38 pm
Jack Corbett (3/15/2012)
Isn't there some Date guy too?
Nono, that was Data, from Star Trek... and he was a walking database, not a designer. That was Midnightian Soong....
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 15, 2012 at 4:37 pm
Grant Fritchey (3/15/2012)
GSquared (3/15/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 15, 2012 at 4:36 pm
Not a problem. Sorry, this fell off my radar for a bit and I got sucked into a project for a week so I hadn't reviewed old threads for...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 9, 2012 at 2:23 pm
I almost got this wrong but the 'select 2 answers' bit excludes the need for the answer 'both run to completion', which would thus give me 3 answers.
The first option...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 9, 2012 at 1:23 pm
I'm afraid we're going to have another polite disagreement, Travis. 🙂
TravisDBA (3/9/2012)
1. Shop doesn't want to spend the money to upgrade software/hardware
There's no reason to spend money 'fixing' something that...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 9, 2012 at 12:00 pm
jbalbo (3/9/2012)
Evil,This works great and I even understand it!! lol
Thanks
Joe
Great, I'm glad that helped. 🙂 Good luck.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 9, 2012 at 11:44 am
MidBar (3/9/2012)
So anything just clicked in your mind?
Ah, so it's the sub-procedures to the reports you want to adjust for pre-calculations. Gotcha. Offhand, no. Most of the...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 9, 2012 at 11:43 am
Viewing 15 posts - 1,711 through 1,725 (of 5,678 total)