Viewing 15 posts - 3,436 through 3,450 (of 7,503 total)
Be sure to double check your sql2000 settings (config + security) before starting the upgrade.
In case of DRP, you may have to start from sql2000 again, so if you don'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
September 28, 2009 at 10:21 am
Unless you capture plan cache, you have no means of history !
And if thing start going bad, it may go steep downhill !
Bad design (view on view, ..) probably ......
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
September 28, 2009 at 7:43 am
Works like a charm.
Thanks for the tip Starunit. :smooooth:
Keep in mind, that with every hotfix / servicepack, this needs to be rechecked (composition of the xml as well as 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
September 28, 2009 at 1:26 am
Nice feedback Jack.
Keep in mind 24h don't make a week, month , year 🙂
Did you trace on the same weekday as when you detected the growth ?
Well, it is a...
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
September 28, 2009 at 12:22 am
Thank you for the refs, Dale.
I'll try them next week.
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
September 25, 2009 at 2:39 pm
did you try this in query analyser ?
alter table yourtable
add SurrogateId int identity(1,1) not null primary key
This should add the wanted column as well as the PK constraint (clustered by...
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
September 24, 2009 at 10:27 am
- SQL2005 introduced the OUTPUT clause. You could use that to do what you intend to.
- Why don't your perform a direct update of T2 ?
DECLARE @opt table (thecol int)
UPDATE...
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
September 24, 2009 at 7:35 am
PhilM99 (9/24/2009)
OK, if I do this am I on the right track?:
1) Manually:
Set recovery model to Full
Do a...
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
September 24, 2009 at 6:38 am
...
Should I set the recovery model to FULL?
If you want to be able to perform point in time restores, you should set it to full recovery mode.
Should I continue to...
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
September 24, 2009 at 4:00 am
Sunil Kanta (9/24/2009)
But, what for Non-Clustered Composite Index? 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
September 24, 2009 at 2:25 am
Apparently the index you tried to move was the one supporting the primary key of your table.
That index must 100% match your tables PK definition.
Altering that column sequence results 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
September 24, 2009 at 1:14 am
HTH
Just keep in mind, by switching to simple recovery, you can nolonger perform point in time recoveries !
You should revise your DRP for that db because you may need to...
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
September 23, 2009 at 7:40 am
another option is to move your table to its own database and then create database snapthots at your desire.
Please refer to SQL Server 2005 Books Online topic "Database Snapshots"...
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
September 23, 2009 at 2:59 am
Like Elliott W replied the job will not be automatically resubmitted because of a failover;
However, if the job has an active schedule or is being activated by any other means,...
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
September 23, 2009 at 2:52 am
Please reply at the duplicate thread : http://www.sqlservercentral.com/Forums/Topic792349-146-1.aspx
just because at this moment that thread has more replies.
Thanks.
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
September 23, 2009 at 2:46 am
Viewing 15 posts - 3,436 through 3,450 (of 7,503 total)