Viewing 15 posts - 4,816 through 4,830 (of 5,678 total)
CirquedeSQLeil (11/24/2010)
WayneS (11/24/2010)
CirquedeSQLeil (11/24/2010)
Craig Farrell (11/24/2010)
CirquedeSQLeil (11/24/2010)
jcrawf02 (11/24/2010)
Should we point out that his view solution doesn't *just* give you the duplicates? 😉Yes - fire away!!!!!!!!!
I just ended up having to...
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 24, 2010 at 12:39 pm
WayneS (11/24/2010)
Craig - I thought about posting this over "there", but decided to keep this to us threadizens.http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/iso-11179-naming-conventions
(Just gotta love how it starts out by talking about you-know-who!)
Ah, 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
November 24, 2010 at 12:37 pm
CirquedeSQLeil (11/24/2010)
Craig Farrell (11/24/2010)
CirquedeSQLeil (11/24/2010)
jcrawf02 (11/24/2010)
Should we point out that his view solution doesn't *just* give you the duplicates? 😉Yes - fire away!!!!!!!!!
I just ended up having to thump Joe...
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 24, 2010 at 12:09 pm
Sachin Vaidya (11/24/2010)
So, creating a clustered index on non unique column is fine, right? However, I will definitely need a unique column if I would have to partition this table.
Yes,...
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 24, 2010 at 12:03 pm
CirquedeSQLeil (11/24/2010)
jcrawf02 (11/24/2010)
Should we point out that his view solution doesn't *just* give you the duplicates? 😉Yes - fire away!!!!!!!!!
I just ended up having to thump Joe over the head...
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 24, 2010 at 11:54 am
CELKO (11/24/2010)
I hope you know why NUMERIC(s,p) is not like DECIMAL(s,p).
Before some poor soul gets misled by this...
It's not?
http://msdn.microsoft.com/en-us/library/ms187746.aspx
decimal[ (p[ ,s] )] and numeric[ (p[ ,s] )]
Fixed precision...
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 24, 2010 at 11:24 am
Rod at work (11/24/2010)
Gianluca Sartori (11/24/2010)
CTRL + RWOW. Thank you. BTW, that control sequence isn't really obvious. (At least not to me.)
It's to toggle (R)esults. At...
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 24, 2010 at 10:59 am
Bhuvnesh (11/24/2010)
gedda (11/23/2010)
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 24, 2010 at 1:04 am
Ran into this the other day on a different task, but same error. It's the generic "We couldn't be more specific error, sorry." error.
A couple of questions. First,...
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 24, 2010 at 1:01 am
You're suffering under the misunderstanding that a clustered index needs to be unique. It doesn't. The Primary Key does, and there should be some key there to uniquely...
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 24, 2010 at 12:49 am
Ummm.... there's not much we can do for ya there. I'm not entirely sure the query definition fits in 8k bytes.
This is a hard limit of the worktables in...
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 23, 2010 at 11:56 pm
Thanks for the feedback, that's excellent news. Luck to you in the future.
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 23, 2010 at 7:41 pm
malik_nagel (11/23/2010)
Incorrect syntax was encountered while...
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 23, 2010 at 6:47 pm
WayneS (11/23/2010)
Alvin Ramard (11/23/2010)
Craig Farrell (11/23/2010)
Alvin Ramard (11/23/2010)
LutzM (11/23/2010)
Alvin, that's what you look like when you've had time to shave?!? 😀But isn't that counterproductive regarding hunting season?
Depends on what I'm...
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 23, 2010 at 6:44 pm
csoloway (11/22/2010)
I'm just looking for some documentation that speaks to what happens...
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 23, 2010 at 6:30 pm
Viewing 15 posts - 4,816 through 4,830 (of 5,678 total)