Viewing 15 posts - 3,226 through 3,240 (of 5,678 total)
tfifield (5/5/2011)
I thought about that about 1 minute after I posted it and did the old Homer Simpson DOH! I then got a bunch of phone calls from clients...
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
May 5, 2011 at 2:21 pm
Tom.Thomson (5/5/2011)
The MS documentation makes an absolutely clear distinction between "heap" and "heap structure". For example the sentence...
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
May 5, 2011 at 11:55 am
Nils Gustav Stråbø (5/5/2011)
Could it be that network latency causes ack messages to be delivered too...
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
May 5, 2011 at 11:53 am
^ What Howard said. Everyone's in public at all times. All deny's on SQL Server are exclusive Denies, they can't get overridden. Deny connect to public locks...
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
May 5, 2011 at 11:49 am
By chance do you have a timeout parameter set on your BEGIN CONVERSATION line?
Also, you mention you can't find the message in the queue, but by chance have you seen...
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
May 5, 2011 at 11:44 am
Stefan Krzywicki (5/5/2011)
Are you using agencies for this position? Is it contract or perm?
Yes and perm.
Regarding the exceptions: I currently have to make those often enough for medical reasons (dental),...
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
May 5, 2011 at 11:29 am
bimplebean (5/4/2011)
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
May 4, 2011 at 5:01 pm
Another choice, especially if they're all coming from the same source database, would be log shipping.
You CAN tell transactional to wait a while, but depending on volume you're going 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
May 4, 2011 at 4:59 pm
barry.a.seymour (5/4/2011)
Here's my situation: I have to refresh table data nightly; however I need to leave everything else (procedures, views, stored procedures) intact.
I personally would look into a transactional...
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
May 4, 2011 at 4:33 pm
Stefan Krzywicki (5/4/2011)
Craig Farrell (5/4/2011)
GSquared (5/4/2011)
Craig Farrell (5/3/2011)
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
May 4, 2011 at 4:19 pm
JMI (5/4/2011)
"Data access mode" in OLE DB Destination.
That's where the problem was!
As soon as i switched to fast load
it took only 2 min to load 3 half...
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
May 4, 2011 at 12:08 pm
That unfortunately is merely the column maps. We'd need to see connection information, what type of load is it doing (fast or not), is it table locking, what 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
May 4, 2011 at 11:47 am
Thanks very much for the google-fu'ing. I'll be over here reading... and getting my jaw back off the floor.
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
May 4, 2011 at 11:43 am
JMI (5/4/2011)
I am usingfor MS Access connection:
Native OLE DB/Microsoft Jet 4.0 OLE DB Provider
(the actual mdb file is Access 2000 version)
My first question here is how fast can you usually...
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
May 4, 2011 at 11:27 am
Hm, I almost NEVER qualify my table names with the schema names, particularly dbo.
This is a bit of an eye-opener for me. Can someone point me in the direction...
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
May 4, 2011 at 11:22 am
Viewing 15 posts - 3,226 through 3,240 (of 5,678 total)