Based on the statistics ... ( are they accurate ? / auto_updateon ? )

how about:

create procedure sp_DBA_RowCount

@TableName varchar(130) = null

, @TableSchema varchar(130)= null

, @MinRows int...

Post your sql errorlog file.

What's the db status ?

Is it online/offline/in recovery ?

Did you try sp_who_is_active to figure out what's going on ?

( http://sqlblog.com/blogs/adam_machanic/archive/2010/11/23/who-is-active-wins-gold-from-sql-server-magazine.aspx )

(b)locking, ...

"Guestimate" is the keyword.

You could start with determining each columns max data length (/2 for the number of chars)

Then create your trial table and try the import.

Keep in mind to...

someone forgot to update the download xls :blink:

the chaps already helped out 😉

the complex and/or/and/or where clause

The suggested:

WHERE QO01ACCIDENT_YEAR in ('2008','2009','2010')

AND

(QO01SUBMIT_AGENCY_ORI = 'XXXXXXXXX'

OR

QO01MUNICIPALITY = 'XXXX')

provides the same predicates,...

It doesn't accept invalid FK values.

Please post ddl (the actual please) of your involved tables as well as the sqljob giving the error as well as the actual error...

Certainly there has been something wrong with a foreign key value for the inserted batch.

I would query the source table using a where not exists correlated query using the foreign...

Stefan Krzywicki (4/20/2011)

---

CirquedeSQLeil (4/20/2011)

---

GilaMonster (4/20/2011)

---

LutzM (4/20/2011)

---

Is there any other method than using the mouse pointer? There are so many words on the screen. How else to keep track where the...

it should be col1 + col2

Ninja's_RGR'us (4/20/2011)

---

Nothing blunt in there... just solid experience. I don't...

Another thread requesting the same options:

http://www.sqlservercentral.com/Forums/Topic1096149-391-1.aspx

Ninja's_RGR'us (4/20/2011)

---

ALZDBA (4/20/2011)

---

GilaMonster (4/20/2011)

---

Ok, I'm going to be blunt (and probably unpopular)

I have seen this happen before. App on a weak server moved to a nice powerful monster, and performance...

GilaMonster (4/20/2011)

---

Ok, I'm going to be blunt (and probably unpopular)

I have seen this happen before. App on a weak server moved to a nice powerful monster, and performance promptly degraded...

Edward-445599 (4/20/2011)

---

ALZDBA (4/20/2011)

---

AWE is not needed on x64 OS with a x64 SQLinstance. ( it already has the ability to address all your ram )

Did you perform full db maintenance...

:w00t::w00t::w00t::w00t::w00t::-D:-D:-D:-D

How's that for a dyping error 😉