Viewing 15 posts - 2,551 through 2,565 (of 5,678 total)
kinderdesign (9/23/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
September 26, 2011 at 12:35 pm
Sean Lange (9/26/2011)
SwayneBell (9/26/2011)
L' Eomot Inversé (9/24/2011)
Burninator (9/23/2011)
Sorry Evil K – addresses can belong to many users/persons.
What gave you the impression that Craig thought addresses belonged to only one person?...
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 26, 2011 at 12:18 pm
Burninator (9/23/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
September 26, 2011 at 12:13 pm
Mike C (9/23/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
September 23, 2011 at 5:36 pm
Mike C (9/23/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
September 23, 2011 at 5:30 pm
Addendum on a second look:
[hashField] AS ([dbo].[getMd5Hash]([entryId])),
As a calculated column, non-persisted?
This table is just RIPE for pain.
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 23, 2011 at 4:18 pm
Mike C (9/23/2011)
So here's a question: assume 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
September 23, 2011 at 4:13 pm
j_depp_99 (9/23/2011)
Thanks to everyones responses..
A little easier to read the definition like so: (EDIT: I see you fixed it in your original post)
SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO...
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 23, 2011 at 4:10 pm
Mike C (9/23/2011)
Evil Kraig F (9/23/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
September 23, 2011 at 4:01 pm
Kinder, I think I'm understanding what you're trying to do, but not well enough.
Can you provide table DDL and sample data? You'll see what we're looking for in 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
September 23, 2011 at 3:59 pm
100's per second isn't a significant issue, usually, but it will depend on hardware and setup.
You'll want to make sure your clustered index is controlled to try to append 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
September 23, 2011 at 3:27 pm
snsingh (9/22/2011)
Thanks for looking into this.Fastloadmaxinsertcommitsize is 2147483647
Accessmode is openrowset using fastload
fastloadoption is TABLOCK,CHECK_CONSTRAINTS
Thanks
Sneh
Open Rowset? What are you loading this from?
What are your options in this drop...
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 23, 2011 at 3:01 pm
Yes. Yes. Yes.
This is a case where normalization is inappropriate. An address should belong to a particular individual, so you can change that person's atomic data appropriately without affecting...
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 23, 2011 at 1:01 pm
I'll third that the state by state discussion really isn't apt anymore, except in some rural areas. It's more jokes then actual hard feelings anymore.
The one thing I 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
September 23, 2011 at 12:59 pm
The wizard is using SSIS, but probably with different destination options.
Go to the destination and make sure data access mode is Table or View - fast load. Set maximum...
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 22, 2011 at 2:28 pm
Viewing 15 posts - 2,551 through 2,565 (of 5,678 total)