Viewing 15 posts - 2,476 through 2,490 (of 7,502 total)
Indeed, Antwerp was a mess this morning. Slippery roads and unadapted driving style causing "fun" traffic jams all over the place 🙁
Regarding the pastries, I was aiming for the theme...
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
January 10, 2011 at 1:44 am
Koen (da-zero) (1/9/2011)
Tom.Thomson (1/9/2011)
ALZDBA (1/8/2011)
Not feeling tip top today.I'll have to refrain from xmas tree burning fest and drink :ermm:
:darn:
?? :ermm:
Do you Americans work to 14th night instead of...
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
January 10, 2011 at 1:32 am
Keep in mind there may be non-related rows that have the same
Bedrag, Boekdatum and Omschrijving1, but belong to a different account.
SELECT Rekening
,...
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
January 10, 2011 at 1:17 am
Can you post the full DDL of your tables ? (object explorer \ rightclick on the table name and script table as create to ...)
This way we can...
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
January 9, 2011 at 2:45 pm
What's are the primary key columns of the source table and which are the key columns you must use to make sure you are comparing the correct rows.
Once you figure...
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
January 9, 2011 at 12:52 pm
just a subtle remark.
Make it a unique constraint ! That is implemented with a unique non-clustered index by sqlserver, but will result in everybody knowing it is a constraint and...
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
January 9, 2011 at 12:00 pm
Chris Kitchen (1/9/2011)
Hi,Thanks for you reply, I never stated that we were restoring the master database every night.
My bad Chris. Sorry for that.
We are planning on using 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
January 9, 2011 at 11:01 am
Mind me asking why you perform the restore of master every night ?
Keep in mind, your instance will not be available to others during your restore ops !
There are other...
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
January 9, 2011 at 9:33 am
Indeed, warm wine is only good in the sauces grandma makes 😉
With the many flavored gin these days, I prefer doing the gin menu :hehe:
Mainly because I don't like...
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
January 9, 2011 at 9:19 am
Thank you for correcting that George.
Index tuning wizard is the correct name.:blush:
It can be found in SQLserver Profiler toolbar option "tools".
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
January 9, 2011 at 3:16 am
Koen (da-zero) (1/9/2011)
ALZDBA (1/8/2011)
Not feeling tip top today.I'll have to refrain from xmas tree burning fest and drink :ermm:
Too much jenever? 😉
Aha, you know the drill :-D:w00t:
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
January 9, 2011 at 3:09 am
Not feeling tip top today.
I'll have to refrain from xmas tree burning fest and drink :ermm:
:darn:
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
January 8, 2011 at 12:10 pm
AFAIK there are no missing index info gathered in sql2000.
You'll need to trace for a reference load and have that analysed by database tuning advisor (included in SQL2000).
Then evaluate those...
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
January 8, 2011 at 12:06 pm
there are log reader tools on the market that can generate undo sql for your transaction.
However, you should also take into account what the impact will be for your system....
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
January 8, 2011 at 12:02 pm
Seems a familiar request : http://www.sqlservercentral.com/Forums/Topic1044104-148-1.aspx
Someone ( your boss ) is kind of focused on really wanting SSIS 😉
If you build a package that does the flip/flop (switch) operation 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
January 8, 2011 at 10:24 am
Viewing 15 posts - 2,476 through 2,490 (of 7,502 total)