Viewing 15 posts - 3,871 through 3,885 (of 7,503 total)
As always, it is acceptable if it serves you good.
I think MS Best practices states a number of 5 or 7.
Here are some nice guidelines on common stuff:
http://technet.microsoft.com/nl-be/library/cc966401(en-us).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
March 29, 2009 at 10:49 am
As always, it depends!
What are your goals for this replication ?
What's the db relationship for your 2 sql2005 instances ?
(duplicates or not) and how are they duplicated at SQL2008 ?
-...
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
March 29, 2009 at 10:38 am
Indeed.
You need another kind of temp table (#mytable) in stead of a table variable (@mytable) to
be able to use it in combination with exec !
--edited--
Regarding the nested exec...
That would mean...
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
March 27, 2009 at 2:02 am
What you are trying to do is to compose dynamic sql (because objects change).
Must read all time reference: http://www.sommarskog.se/dynamic_sql.html
Any query needs a fixed object name to act on.
If you still...
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
March 26, 2009 at 3:46 pm
- start a trace to figure out what 's going on.
(you can have the trace start a new file every xMB, and so if the issue didn't occure during...
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
March 26, 2009 at 3:42 pm
bhindla (3/25/2009)
I'm running (or trying to run) SQL2K8 on W2K3 SP2. I know SQL2005...
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
March 26, 2009 at 5:46 am
As already stated, double check you are pointing the SMO properties to the specifics you are querying, scripting, modifying,... !!
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
March 24, 2009 at 11:38 am
Opting for the left join, would mean a vertical split of the data into a number of tables.
As always ... it depends ... mainly on your performance goals, but as...
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
March 24, 2009 at 11:27 am
Keep in mind SQLAgent has settings (activated by default) for job history.
- Total number of rows
- Max number of rows per job
If you have many jobs, you may be hitting...
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
March 24, 2009 at 11:22 am
Never mind, I created a carthesian resultset because I didn't include all elements to be compared in the ON-clause of the join.
Now it's working a bit better, but still doesn'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
March 24, 2009 at 6:38 am
I got things working a little bit :crazy:
I have attached the sample data and the needed queries.
The problem is the comparison query never ends ....
This server has +/- 1400 shares...
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
March 24, 2009 at 1:56 am
You need to specify :
OR new file locations as proposed above.
OR use the 'replace' keyword to overwrite an existing database !
I advise to always specify the target file locations, so...
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
March 23, 2009 at 2:43 pm
You may want to work with a delete loop of smaller chuncks of your data.
Keep in mind your logfile may grow during this operation.
I don't know where I got this...
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
March 23, 2009 at 7:17 am
For sqlserver I suggest you use the bigest allocation unit size your windows supports.
It will be the smallest unit of allocation for any file(extend) on that volume.
So the smaller it...
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
March 23, 2009 at 7:10 am
Thank you Jacob.
I'll give it a try.
Johan
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
March 23, 2009 at 1:37 am
Viewing 15 posts - 3,871 through 3,885 (of 7,503 total)