Viewing 15 posts - 2,581 through 2,595 (of 7,506 total)
Indeed, next time I'll actually plan breaks in my slides and have them taken !
I did have some twinkles in the stomach before the ppt, but IMO that's positive stress....
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
December 15, 2010 at 12:39 pm
- did you prepare your migration using "Microsoft SQL Server 2008 Upgrade Advisor" http://www.microsoft.com/downloads/en/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en
It may point you to potential issues.
- I didn't find a gap today to actually test...
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
December 15, 2010 at 8:05 am
Brandie Tarvin (12/15/2010)
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
December 15, 2010 at 6:00 am
Any advise on doing presentations (the thing, not the content) ?
http://www.sqlservercentral.com/Forums/Topic1034954-61-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
December 15, 2010 at 5:09 am
Thank you for the sympathy.:-D
Indeed: a good spoon or 3 of honey already did a good job, but there's still a long way to go.
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
December 15, 2010 at 5:07 am
There are a number of great articles on
- cursor avoidance:
-- http://www.sqlservercentral.com/articles/T-SQL/66097/
- RBAR avoidance:
--http://www.sqlservercentral.com/articles/Performance+Tuning/62278/
attached you'll find on one slide of the presentation I gave yesterday.
It was supported by the...
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
December 15, 2010 at 5:03 am
GilaMonster (12/15/2010)
WayneS (12/14/2010)
Gail, are you trying for sainthood?No. You have to be dead to become a saint. Doesn't sound appealing.
tsss, details ... details... :hehe:
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
December 15, 2010 at 2:02 am
Craig Farrell (12/14/2010)
WayneS (12/14/2010)
Gail, are you trying for sainthood?Yeah, she is.
First step to become asaint is to get beatified.
If guess that certainly will not be a problem :hehe:
Say 5 "hail...
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
December 15, 2010 at 1:11 am
your table is a heap, so rebuilding your indexes may not give you the result you aim for.
It isn't using the index [ixcustsalesman] your created for column [id_salesman].
Can you define...
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
December 15, 2010 at 12:16 am
Typical questions on migration:
- did you perform post migration actions like:
-- DBCC CHECKDB (0) WITH ALL_ERRORMSGS, DATA_PURITY;
---- kb http://support.microsoft.com/kb/923247
-- rebuild all indexes
-- update all statistics
-- dbcc updateusage
- were you...
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
December 14, 2010 at 10:58 am
No problem. 😉
In many cases production continuity is more important than going for the bug.
However, if this re-occurs, you may have to invest time to figure out why it stops...
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
December 14, 2010 at 4:54 am
How about some feedback, so others can your this thread as a ref.;-)
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
December 14, 2010 at 4:51 am
If that one is free on your server, that should be ok.
However, I must admit, I haven't found a list of "reserved ports" yet.
There must be some kind of convention,...
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
December 13, 2010 at 5:12 am
Also keep in mind there may be some firewall configuration stuff to perform on both sides !
(allow the port numbers)
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
December 13, 2010 at 1:27 am
Paul White NZ (12/13/2010)
I have not yet summoned the courage to hit 'download'...
edit: ok so I...
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
December 13, 2010 at 1:15 am
Viewing 15 posts - 2,581 through 2,595 (of 7,506 total)