Viewing 15 posts - 3,856 through 3,870 (of 7,499 total)
Since partitioning is an advanced topic, it is highly recommendable to read BOL and to read the white paper on partitioning.
(make sure you have the latest version of BOL !)
-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 31, 2009 at 1:12 pm
Is you database case sensitive ?
If you enter a default schema for a user, it will nolonger search the way it did in sql2000 !
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 31, 2009 at 1:08 pm
AFAIK you only need to install the backward components if you want to be able to modify the packages.
Keep in mind to put your DRP for this upgraded server in...
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 31, 2009 at 1:03 pm
We always have 'sa' for actual db owner.
With application service accounts that created databases and dbobjects..
-On SQL2000 the attitude is like Jerry Hung stated.
-On SQL2005 those db are also altered...
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 31, 2009 at 9:59 am
I've also found some nice perf. info at http://www.ramsan.com/products/products.htm
If I get the chance, I'll certainly try it out.
That depends entirely on the "current" economic situation.
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 31, 2009 at 9:55 am
Your question wasn't posted completely.
also you'll need to figure out the "fomat" of your integer time column(s).
- are they expressed in seconds ?
- are they just numerical representations 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
March 31, 2009 at 12:11 am
how up to date are your statistics ?
(sp_updatestats / dbcc updateusage(0) with count_rows)
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 30, 2009 at 12:04 pm
Your on SP2 without any cumulative updates. (current is sp3)
Do you see any other messages in your sqlserver errorlog file ?
I would try to start a trace and figure out...
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 1:20 pm
you could opt to compress your .BAK files (zip or rar).
This way you would end up with about 25% of your backup file sizes.
With that volume (1TB) spread your...
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 1:11 pm
Hopping in late ...
I've recently had about the same issue....
http://www.sqlservercentral.com/Forums/Topic678236-21-1.aspx
JohnG and Jacob helped out well.
Jacob Sebastian's article on XML are great.
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 1:00 pm
What service pack are you on ?
Post the results of:
Select @@version
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:50 am
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
Viewing 15 posts - 3,856 through 3,870 (of 7,499 total)