Viewing 15 posts - 2,551 through 2,565 (of 5,685 total)
kinderdesign (9/23/2011)
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?...
September 26, 2011 at 12:18 pm
Burninator (9/23/2011)
September 26, 2011 at 12:13 pm
Mike C (9/23/2011)
September 23, 2011 at 5:36 pm
Mike C (9/23/2011)
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.
September 23, 2011 at 4:18 pm
Mike C (9/23/2011)
So here's a question: assume a...
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...
September 23, 2011 at 4:10 pm
Mike C (9/23/2011)
Evil Kraig F (9/23/2011)
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...
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...
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...
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...
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...
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...
September 22, 2011 at 2:28 pm
Viewing 15 posts - 2,551 through 2,565 (of 5,685 total)