Viewing 15 posts - 5,206 through 5,220 (of 5,678 total)
Awesome link, thanks, exactly what I was looking for. With a little puzzlement, I've figured out how to get it to do what I want (I think).
However,...
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
October 27, 2010 at 10:07 pm
Steve Jones - SSC Editor (10/27/2010)
pin a post in that forum? Or others? Don't want to pin in every forum.
Shame you can't have those two links just be immediately clickable...
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
October 27, 2010 at 9:39 pm
So, you want fresh topics in that forum, rather then responses to the pinned topic? Just confirming from what I see. When I read the pinned item it...
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
October 27, 2010 at 9:32 pm
Check out this article:
http://msdn.microsoft.com/en-us/library/ms141237.aspx
In particular, this section:
In addition to the fast load options exposed in the OLE DB Destination Editor dialog box,you can configure the OLE DB destination to use...
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
October 27, 2010 at 7:54 pm
That looks right to me... I assume that's a simplified trigger for our benefit.
Some things can ignore triggers, like Bulk Insert has the ability to turn it off. ...
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
October 27, 2010 at 7:32 pm
Under 99% of circumstances, you'd run the procedure via a query window.
Example, if you made this proc:
CREATE PROC AlphaProc
(@blah INT = NULL)
AS
SELECT @blah
You would run it for different variables like...
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
October 27, 2010 at 6:43 pm
Steve Jones - SSC Editor (10/27/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
October 27, 2010 at 6:00 pm
Steve, I did a search (honestly, a brief one) about basic troubleshooting/optimizations for queries that I think would save a lot of headaches if I could just link some folks...
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
October 27, 2010 at 5:34 pm
Piotr.Rodak (10/27/2010)
Having said that, wouldn't you be looking for something like
select #tmp.key1, #tmp.key2 FROM #tmpinner join
(
SELECT key1 FROM #tmp
EXCEPT
SELECT key1 FROM #tmp2
) q on #tmp.key1 = q.key1
?
Regards
Piotr
Pretty much, but...
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
October 27, 2010 at 5:10 pm
PHXHoward (10/26/2010)
Using your example, I tried to do it this way:
declare @Version int
set @Version = '10000'
SELECT DP.Name, DV.Version
FROM DatabaseProduct DP
JOIN DatabaseVersion DV
ON...
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
October 26, 2010 at 6:27 pm
sasi.tripuraneni (10/26/2010)
hello,Can any one please post Sr level interview questions, its very urgent!
thanks
Sasi.
Question 1: Did you ever go to SSC 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
October 26, 2010 at 5:52 pm
GSquared (10/26/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
October 26, 2010 at 4:49 pm
mtillman-921105 (10/26/2010)
Steve Jones - SSC Editor (10/26/2010)
My son says this reminded him of me. Yikes.
You remind him of which one? Steve or Bill? 😀
That's really funny by 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
October 26, 2010 at 3:27 pm
virpan_17 (10/26/2010)
I hope that my question is clear.
As mud.
Alright, you have a table. Col1 is varchar with an assumed column indicating level that's calculated by LEN(Col1). Easy...
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
October 26, 2010 at 2:18 pm
drew.allen (10/26/2010)
Craig Farrell (10/25/2010)
Okay, the error message is simple enough, but I thought the point of EXCEPT was to reword the anti semi-join operation?
The purpose of EXCEPT is to handle...
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
October 26, 2010 at 11:04 am
Viewing 15 posts - 5,206 through 5,220 (of 5,678 total)