Viewing 15 posts - 1,756 through 1,770 (of 5,678 total)
Ray K (2/22/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
February 22, 2012 at 3:35 pm
Thanks for the excellent setup. You're close, you just need to use grouping and having.
SELECT
p.ID,
p.[name]
FROM
#Degree
join #DegreeJct on #Degree.ID = #DegreeJct.DegID
join #People AS p on #DegreeJct.UserID = p.ID
where Deg...
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
February 22, 2012 at 3:20 pm
sudhirnune (2/21/2012)
> Windows Group is created and added it as part of Login (SO that any user part 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
February 22, 2012 at 1:11 pm
One other piece of discussion that noone's brought up yet.
WHERE isnumeric(score) = 1
This cannot be trusted to go first. It's quite possible to end up with conversion errors...
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
February 22, 2012 at 12:45 pm
GilaMonster (2/22/2012)
Brick wall. And now I'm honouring promises and decisions that I didn't make. Wonderful.
Ow. Sorry to hear.
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
February 22, 2012 at 12:05 pm
Execution Plans for both? Time to execution and statistics? Data volume of the core tables and sub tables, vs. resultant volume in the temps? Indexes?
The query itself...
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
February 22, 2012 at 12:02 pm
David Walker-278941 (2/22/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
February 22, 2012 at 12:00 pm
Koen,
Thanks for the information. I think I puzzled out why the engine and not the component was complaining. Since the column wasn't mapped inside the component, the component...
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
February 21, 2012 at 11:41 am
sumitagarwal781 (2/17/2012)
both are totally different, Drop removes the object from database and truncate just deallocates the data pages but retains the definition.
If you drop the object to recreate it 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
February 17, 2012 at 4:16 pm
Jeff Moden (2/17/2012)
Agreed on the SELECT/INTO but you really don't want to do that across a linked server. It WILL lock the source in that case.
Yeah, precisely the scenario...
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
February 17, 2012 at 2:42 pm
I ended up forced to go to SSIS to enforce a table to table BULK with minimal. I can't for the life of me figure out a direct way...
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
February 17, 2012 at 12:34 pm
GSquared (2/17/2012)
bitbucket-25253 (2/17/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
February 17, 2012 at 12:16 pm
Hey guys, I'm having trouble getting minimal logging with BULK to work via T-SQL. Can anyone who's more familiar give me a hand here: http://www.sqlservercentral.com/Forums/Topic1253552-338-1.aspx
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
February 17, 2012 at 11:43 am
ColdCoffee (2/16/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
February 16, 2012 at 6:35 pm
SQLRNNR (2/16/2012)
Golf
Boredom
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
February 16, 2012 at 6:00 pm
Viewing 15 posts - 1,756 through 1,770 (of 5,678 total)