Viewing 15 posts - 4,816 through 4,830 (of 5,685 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...
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...
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...
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,...
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...
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...
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...
November 24, 2010 at 10:59 am
Bhuvnesh (11/24/2010)
gedda (11/23/2010)
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,...
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...
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...
November 23, 2010 at 11:56 pm
Thanks for the feedback, that's excellent news. Luck to you in the future.
November 23, 2010 at 7:41 pm
malik_nagel (11/23/2010)
Incorrect syntax was encountered while...
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...
November 23, 2010 at 6:44 pm
csoloway (11/22/2010)
I'm just looking for some documentation that speaks to what happens...
November 23, 2010 at 6:30 pm
Viewing 15 posts - 4,816 through 4,830 (of 5,685 total)