Viewing 15 posts - 2,506 through 2,520 (of 5,678 total)
Jack Corbett (9/30/2011)
....
What happens is I will get an error for one row that says "An error has occurred while sending this row to destination data 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
September 30, 2011 at 2:07 pm
Lexa (9/30/2011)
Evil Kraig F (9/30/2011)
Now would be a good time to defrag your stuff too.
Defrag with the overallocated DB? What do you use for defraging and why now be...
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
September 30, 2011 at 1:20 pm
40% is a lot, but if you have the room to spare, leave it be. Saves you time later and gives you enough room to not need to grow...
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
September 30, 2011 at 1:05 pm
aibogomolov (9/30/2011)
GilaMonster, what generally causes lock escalation?
5000+ rows.
See this: http://msdn.microsoft.com/en-us/library/ms184286.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
September 30, 2011 at 1:01 pm
You can pass the parameter as a Table Type (new for 2k8) of a table variable.
Another option is an XML string, or even a comma delimited string, which is then...
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
September 30, 2011 at 12:59 pm
To all those who feel this is an ugly question, remember this problem is an actually existing one if you have SSMS/VS 2k8 installed and you're still working with 2k5...
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
September 30, 2011 at 12:26 pm
Well, if replication and mirror/snapshots are out, really the only other option left is SSIS delta data moves, and that's going to rely on you having an efficient delta detection...
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
September 30, 2011 at 12:22 pm
Gianluca Sartori (9/30/2011)
The error message says it all: you cannot update views that reference more than one table.
Not entirely true, Gianluca. You just can't update more than one table's...
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
September 30, 2011 at 11:18 am
Byzza (9/29/2011)
Thank...
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
September 30, 2011 at 11:05 am
CELKO (9/29/2011)
Learn a few basics, be polite and we will talk after you re-post
Pot, this is the kettle. I'd really like to discuss your current hue...
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
September 30, 2011 at 12:23 am
Elliott Whitlow (9/29/2011)
Evil Kraig F (9/29/2011)
It's 2011, I've been at 5 positions since 2k8 came out, and I have *yet* to be at a company that has it in production.
Yikes,...
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
September 30, 2011 at 12:19 am
Byzza (9/29/2011)
I'm just having a complete brain fart today and I have forgotten how to do a basic update. Could someone help me please.
I have a table "dbo.tblGroup_Drawing...
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
September 29, 2011 at 7:22 pm
Technet article here: http://technet.microsoft.com/en-us/library/ms189087.aspx
Depends on your settings, either can be true.
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
September 29, 2011 at 5:00 pm
PASS: The big name thing we tell our bosses we're going to for our hidden agendas... Code Magpie's Anonymous. Remember, meetings are at 8, 10, and 12, both days.
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
September 29, 2011 at 4:37 pm
toddasd (9/29/2011)
But...it's Kansas 😛
Heheh, my reaction was: But it's FoxPro.
You might want to mention a bit more about the SQL Skills you'd like them to bring to the table for...
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
September 29, 2011 at 3:41 pm
Viewing 15 posts - 2,506 through 2,520 (of 5,678 total)