Viewing 15 posts - 766 through 780 (of 5,678 total)
In this case Sean, since he's looking more for tuning help than code help, I'd request something a bit different.
As mentioned, we want to see the DDL for the source...
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
March 21, 2013 at 2:44 pm
I have a bit of a confusion here. BCP can build a comma delimited file for you. Why are you pre-constructing the CSV? What other issue did...
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
March 21, 2013 at 2:42 pm
majorbloodnock (3/19/2013)
First of all, Craig, thanks very much for the compliment; I do my best.
My pleasure, I assure you.
Regarding your question, I'm embarrassed to say I'm not entirely clear 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
March 19, 2013 at 5:22 am
Gary Varga (3/19/2013)
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
March 19, 2013 at 5:00 am
bitbucket-25253 (3/18/2013)
My one hundreth QOD has been accepted for publication on 20 Mar -21 Mar 2013
Rock on, my man. Rock 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
March 19, 2013 at 4:27 am
majorbloodnock (3/19/2013)Utterly agree. The more experience I gain (for that, read "the older I get" 😉 ) the more I see the technologies I work with purely as tools, and...
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
March 19, 2013 at 4:24 am
Lynn Pettis (3/18/2013)
Jeff Moden (3/18/2013)
Evil Kraig F (3/18/2013)
Alright, let's start with the basics. You said you've read up...
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
March 19, 2013 at 4:11 am
All security in SQL Server is cumulative unless an explicity DENY in one group overrides a setting from another. That includes both internal (SQL) and external (AD) group associations....
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
March 18, 2013 at 6:52 pm
LSAdvantage (3/18/2013)
Thank you for the very detailed explanation Craig! That is exactly what I need. That pivot query was very, VERY helpful.
If it makes you feel any better,...
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
March 18, 2013 at 5:49 pm
Ahhh, bitvector (bitmask, bitwise operators, combined flags, flagfield, etc...), my old friend.
Alright, let's start with the basics. You said you've read up on it but some of your difficulty...
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
March 18, 2013 at 4:45 pm
SQLRNNR (3/15/2013)
Lynn Pettis (3/15/2013)
Lynn Pettis (3/15/2013)
Hi, My name is Lynn and...
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
March 18, 2013 at 2:32 pm
Unfortunately, I agree with Lowell here. When you start trying to bombproof (I like that term) Excel importations, you're looking at VBA code which will open its own connection...
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
March 18, 2013 at 2:23 pm
Phil Parkin (3/14/2013)
...unless you're using 2012, in which case the result set definition moves to the Execute SQL task.
Haven't gotten my hands on 2012 yet, but does that include OLEDB...
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
March 15, 2013 at 1:33 pm
Phil Factor (3/14/2013)
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
March 15, 2013 at 1:29 pm
Phil, in some ways I agree with you. If a VERY small company doesn't have the infrastructure to support their business model, and they don't have the throughput 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
March 13, 2013 at 1:05 pm
Viewing 15 posts - 766 through 780 (of 5,678 total)