Viewing 15 posts - 2,101 through 2,115 (of 7,499 total)
"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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 21, 2011 at 11:47 am
someone forgot to update the download xls :blink:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 21, 2011 at 3:28 am
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,...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2011 at 2:47 pm
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2011 at 2:40 pm
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2011 at 1:54 pm
Stefan Krzywicki (4/20/2011)
CirquedeSQLeil (4/20/2011)
GilaMonster (4/20/2011)
LutzM (4/20/2011)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2011 at 1:11 pm
it should be col1 + col2
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2011 at 1:05 pm
Ninja's_RGR'us (4/20/2011)
GilaMonster (4/20/2011)
ALZDBA (4/20/2011)
"Blunt" has been redefined :hehe:Sorry, will see if I can tone it down when I get home.
Nothing blunt in there... just solid experience. I don't...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2011 at 12:02 pm
Another thread requesting the same options:
http://www.sqlservercentral.com/Forums/Topic1096149-391-1.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2011 at 12:00 pm
Ninja's_RGR'us (4/20/2011)
ALZDBA (4/20/2011)
GilaMonster (4/20/2011)
I have seen this happen before. App on a weak server moved to a nice powerful monster, and performance...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2011 at 9:59 am
GilaMonster (4/20/2011)
I have seen this happen before. App on a weak server moved to a nice powerful monster, and performance promptly degraded...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2011 at 9:38 am
Edward-445599 (4/20/2011)
ALZDBA (4/20/2011)
Did you perform full db maintenance...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2011 at 8:25 am
Ninja's_RGR'us (4/20/2011)
Wow you learn something new everyday :- dbcc updateusage () with count_cows
:w00t::w00t::w00t::w00t::w00t::-D:-D:-D:-D
How's that for a dyping error 😉
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2011 at 6:42 am
another msdtc resource: http://blogs.msdn.com/b/asiatech/archive/2009/11/18/how-to-configure-msdtc-resource-for-windows-2008-failover-cluster.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2011 at 6:37 am
Keep in mind , if these new addresses are not addressable from the current addresses (vlan/ranges) this needs to be an all in one operation or your cluster may become...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2011 at 6:35 am
Viewing 15 posts - 2,101 through 2,115 (of 7,499 total)