Viewing 15 posts - 2,146 through 2,160 (of 5,678 total)
Rob Schripsema (12/5/2011)
Great question. Not what I would have expected....but then, many aspects of SQLVariants are not what I would expect.
Agreed, it's like opening Pandora's Box. I'm not even...
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
December 6, 2011 at 12:08 pm
Yeah, I so wanted to go... a shame. Ah well, time to review who made the cut.
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
December 6, 2011 at 11:33 am
drew.allen (12/5/2011)
CELKO (12/5/2011)
Your approach to SQL is fundamentally wrong.
Your approach to SQL training is fundamentally wrong. Without specifics on what you think is fundamentally wrong, why you think 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
December 5, 2011 at 3:03 pm
amos-870870 (12/5/2011)
Ninja's_RGR'us (12/5/2011)
amos-870870 (12/5/2011)
unfortunatly ether/or table that gets updated will remove them from the view.I'd still try repeatable reads in a single transaction... just out of curiosity ;-).
I have not...
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
December 5, 2011 at 1:45 pm
Lowell (12/5/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
December 5, 2011 at 1:36 pm
:blink:
To confirm, you're in SQL 2000? Also, what is your current import mechanism? DTS, BCP, Bulk?
EDIT: I removed a number of confusing items I wrote. I really,...
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
December 5, 2011 at 12:39 pm
I'd personally approach this utterly differently, but a lot of that comes from the necessity of CYA.
Archive the file with a different file name using a move. Even a...
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
December 5, 2011 at 12:36 pm
jshahan (12/5/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
December 5, 2011 at 12:34 pm
There's a concern with the premise of this problem. Cadavre's code illustrates the concern nicely. He had to include the identity() field.
You have no indicators in the original...
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
December 5, 2011 at 12:13 pm
I was going to get back involved here, but after what appears to have happened over the weekend and this morning, I'll pass.
Nico, did Ninja use the best phrasing in...
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
December 5, 2011 at 11:43 am
GilaMonster (12/5/2011)
jcrawf02 (12/5/2011)
Did you guys see this? http://arstechnica.com/business/news/2011/12/bill-would-end-overtime-pay-requirement-for-many-more-it-workers.arsOne more reason I'm glad I'm not American...
The difference Gail is if you WERE American (or working here) you'd be getting paid enough...
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
December 5, 2011 at 11:40 am
Ninja's_RGR'us (12/5/2011)
amos-870870 (12/5/2011)
Ninja's_RGR'us (12/5/2011)
amos-870870 (12/5/2011)
You know what the problem was, I was using references that were outside SQLServerCentral.No sure what you mean by this?
What I mean is SQLServerCentral has a...
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
December 5, 2011 at 11:39 am
p-nut (12/5/2011)
CREATE TABLE ClientVersion (id int identity(1,1),...
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
December 5, 2011 at 11:35 am
Hm, nice problem setup, and an interesting scenario. I've never seen a difference in 1 row estimation vs. accurate 227000 row estimation NOT make a difference...
Is the 405000 base...
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
December 5, 2011 at 11:31 am
Ninja's_RGR'us (12/5/2011)
amos-870870 (12/5/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
December 5, 2011 at 11:22 am
Viewing 15 posts - 2,146 through 2,160 (of 5,678 total)