Viewing 15 posts - 2,476 through 2,490 (of 7,499 total)
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
Two advantages:
1) the best solution for your company :kiss:
2) the sweet taste of victory for you 😀
ps
don't just make it work, study it so you know how it works.
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 7, 2011 at 12:02 pm
IMO you need to read a little bit on mirroring and the role of a witness ! ( even if it is trivial )
In our typical use cases, we implemented...
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 7, 2011 at 4:12 am
Straight forward, using no rocket science, primitive:
I hope you are already producing sqlserver database backups on a regular basis !
You need to figure out if you want a point...
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 7, 2011 at 12:58 am
Viewing 15 posts - 2,476 through 2,490 (of 7,499 total)