Viewing 15 posts - 3,751 through 3,765 (of 5,678 total)
GSquared (3/11/2011)
GilaMonster (3/11/2011)
I signed off two official design documents back at the bank as "Database Overlord". No one commented.
I, for one, welcome our new reptilian overlords ....
(Now I can't remember...
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 11, 2011 at 11:27 am
What are you checking for? Existance, a value in TableA being 'x', that it's new?
Need more information on what you're doing to help walk you through how to do...
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 10, 2011 at 11:03 pm
Ummm, the 'select all that apply' choices are a radio button, can only pick one. Not good.
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 10, 2011 at 10:59 pm
jcrawf02 (3/10/2011)
I'm still working on my master plan of successfully naming a project A.C.R.O.N.Y.M., haven't been able to figure that one out yet.
You mean the unit of
Assault Crimes of...
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 10, 2011 at 4:05 pm
I answered wrong but it was a good question. I brainfarted like a few others and went after the 'data', not the log... so you could restore anytime up...
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 10, 2011 at 3:55 pm
p.stevens76 (3/10/2011)
CHEERS CRAIGTHAT WORKED A TREAT. THANKS A LOT
🙂
My pleasure, glad it worked... and thanks for the feedback. 🙂
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 10, 2011 at 2:13 pm
Khades (3/10/2011)
Oh wow, I did not know the magic tables would have that identity even if you don't directly insert/update/delete it, thanks!
I couldn't remember myself because I avoid triggers so...
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 10, 2011 at 1:47 pm
Jeff Moden (3/10/2011)
WayneS (3/10/2011)
and probably more efficient than correlated sub-queries.There's only one way to know, huh? 😉
As usual: It depends...
...and it depends a LOT on the indexing. (The proof...
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 10, 2011 at 1:42 pm
Tom.Thomson (3/10/2011)
Of course there are some real horrors, with getting on for 500 common uses. Acronyms are often a bad idea because they are so thoroughly ambiguous. 😉
I have...
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 10, 2011 at 1:39 pm
CirquedeSQLeil (3/10/2011)
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 10, 2011 at 12:55 pm
Khades (3/9/2011)
How do I get the identity column values from the errorPK table?
Trigger:
The inserted table will carry the identity when you go to insert into ErrorFK.
Check this code 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 10, 2011 at 12:45 pm
Hey Jeff,
A bit of research is showing me that this is, at best, a mess.
For example, to deal with doc_ids, apparently you need to use sp_fulltext_keymappings http://msdn.microsoft.com/en-us/library/cc645845.aspx... but that doesn't...
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, 2011 at 11:59 am
GilaMonster (3/9/2011)
Craig Farrell (3/9/2011)
Ah, that explains a few things. I'd wondered who'd pissed in your cheerios yesterday, and was just glad it wasn't me. 😉
Oh, I didn't think...
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, 2011 at 10:41 am
Khades (3/8/2011)
Except I guess, if I do use a trigger. How do I make it use only those rows that were inserted along with the PK of that table? Do...
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, 2011 at 10:26 am
rjohal above is correct, it's most likely got to do with the statistics difference between temp tables and table variables affecting the query plan. Temp tables store more accurate...
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, 2011 at 10:11 am
Viewing 15 posts - 3,751 through 3,765 (of 5,678 total)