Viewing 15 posts - 946 through 960 (of 5,678 total)
Need more information about each schema to help you write the code directly, but here's the short form:
SELECT
-- all fields except identity
FROM
-- duped table
GROUP BY
-- all...
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
December 6, 2012 at 11:10 am
The only way I can think of modifying the schema components is to open it as XML, find/replace, then reload the XML. Sorry, I just brainfarted on the fact...
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
December 6, 2012 at 11:06 am
You'll get no performance increases from their removal, but you'll probably get readability and maintenance improvements from having less objects to keep track of.
EDIT: I should say no significant performance...
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
December 5, 2012 at 5:36 pm
I'm assuming you've tried this, but have you thought about beers after work with these people, individually, and having a frank discussion about what you're percieving? I'm not saying...
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
December 5, 2012 at 3:44 pm
If possible, can you offer a lot more detail into the data status on the two databases and future intent?
If you're looking at a complete overwrite on one 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
December 5, 2012 at 2:36 pm
Yes, but you have to prep to do it from the start, using configurations. However, in theory, you should only need to change the Data Source object. What...
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
December 5, 2012 at 2:25 pm
dogramone (12/3/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
December 3, 2012 at 8:45 pm
ScottPletcher (12/3/2012)
At 3AM, with production workers waiting, I don't want someone trying to design for something that will never exist!
Perhaps, but honestly I was hard pressed to answer your...
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
December 3, 2012 at 8:21 pm
*wipes away a tear from his eye* Damn, Jeff... that's... that's just beautiful. *sniff*
I couldn't for the life of me figure out how to get out 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
December 1, 2012 at 12:48 pm
Steven Willis (11/30/2012)
No loops, no cursors, no cte
You've answered the data, not the problem, with this. You cannot recurse in both directions, you cannot deal with more than 2...
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
November 30, 2012 at 8:28 pm
capnhector (11/30/2012)
so far an extension of my adjacency list by searching up and down (not the fastest thanks Mickey T. by the way) and dwains loop solution are the only...
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
November 30, 2012 at 8:25 pm
Sarwan (11/30/2012)
Can you...
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
November 30, 2012 at 12:41 pm
Typically I do it for merge replication. Considering how much I try to avoid that particular method of replication, I don't do it much.
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
November 30, 2012 at 12:36 pm
Olly, a question before I work this code.
First, you put in 0-length strings, '', instead of NULLS where teh data is missing for PRVID/PrvName. Are these NULL, or actually...
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
November 30, 2012 at 10:13 am
Michael Gerholdt (11/30/2012)
Somehow the TransactionOption had got set to "Required" on the first container, but not the others.Setting it back to "Supported" provided the expected behavior.
Much appreciated!
My pleasure. Sounds...
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
November 30, 2012 at 10:01 am
Viewing 15 posts - 946 through 960 (of 5,678 total)