Viewing 15 posts - 2,101 through 2,115 (of 7,506 total)
Condolences and prayers to your friend's family.
I've lost an ex colleague last Friday who fought the battle against her cancer for a year.
That are the kind of events that really...
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 25, 2011 at 1:21 pm
did you try:
http://support.microsoft.com/kb/918992
or
http://www.sqlservercentral.com/scripts/31776/
Keep in min you would better do this procedure including login SIDs !
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 25, 2011 at 1:11 pm
Before Okt 2008, Easter day and New years day where the only two days our production would be in full stop.
The only occasion to do some real systems maintenance for...
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 24, 2011 at 8:27 am
Jack Corbett (4/23/2011)
http://www.sqlservercentral.com/Forums/Topic1094168-146-3.aspx
I hope my reply isn't too terse. I made...
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 23, 2011 at 5:33 am
you would have walked a safer path just posting the requested info !
Your solution may have worked, but might have been avoidable.
If I'm correct 2TB is the default max size...
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:46 pm
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...
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 12:04 pm
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 ?
(b)locking, ...
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:52 am
"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
Viewing 15 posts - 2,101 through 2,115 (of 7,506 total)